Find Jobs
Hire Freelancers

Create and Excel Marco which Copy and Pastes filtered data

$10-30 USD

Completed
Posted over 8 years ago

$10-30 USD

Paid on delivery
Hi Everyone, I'm looking for someone to create an excel macro which filters data in one spreadsheet and pastes it onto another. The only complex task is to randomly select rows before pasting. I've attached the project outline along with a couple of example spreadsheets so you can give me an accurate quote for the job. If you have any questions feel free to ask. Also, please quote the word "macro" in your proposal so I know you've understood the outline. Happy bidding!
Project ID: 8769409

About the project

21 proposals
Remote project
Active 8 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
Awarded to:
User Avatar
macro Hi, I have 3 years of experience with Excel VBA programming working for companies like IBM, MSCI and Ford Motor Company. I am able to complete almost any type of macro jobs. However I think you forgot to attach the description of the job.
$30 USD in 3 days
5.0 (115 reviews)
6.8
6.8
21 freelancers are bidding on average $29 USD for this job
User Avatar
Hello Sir, I am an Expert Techno-Functional Analyst having vast experience in lots of arenas of IT industry including Excel Macros and Formulas. I am an Engineering Graduate with an MBA degree. If you see I am among niche bidders who have zero failed projects and very high completion rate since I do not bid on projects which I am not certain of. I will not disappoint you, please give me an opportunity to work with you. No milestones required. Pay me only when your job is 100% done. Also I will provide you with a working version of file before you consider awarding me the project. I have some queries so request you please have a quick discussion in case you consider me with award. Thanks, Jay
$30 USD in 0 day
5.0 (667 reviews)
8.4
8.4
User Avatar
macro: Hi, I am good at excel and macro. Plz provide me the details. Looking forward to work on this project. Can u plz provide me the attachements.
$30 USD in 1 day
5.0 (814 reviews)
7.9
7.9
User Avatar
" MACRO "Can you please send or attach the Excel file with samples to clarify the project description. Ready to start. Thanks
$30 USD in 3 days
4.9 (268 reviews)
7.5
7.5
User Avatar
A proposal has not yet been provided
$30 USD in 1 day
4.9 (277 reviews)
7.2
7.2
User Avatar
Lets start. Having a team of Professionals. We provide high quality work with accuracy. Would you like to discuss more about your current requirements?
$30 USD in 1 day
4.9 (198 reviews)
6.4
6.4
User Avatar
Hi there, I have a vast experience in Excel and VBA and would be happy to help you on the project. Best regards, Eugene
$15 USD in 0 day
5.0 (251 reviews)
6.4
6.4
User Avatar
Hi, "Macro" i read your description. I'm able to create the macro. I can't see any attachments with your project. Please let me know where i can find that? Thank you, Karthik
$39 USD in 1 day
4.9 (109 reviews)
5.8
5.8
User Avatar
A proposal has not yet been provided
$25 USD in 1 day
4.9 (70 reviews)
5.8
5.8
User Avatar
Hi there! I'm a web developer.I'm get bachelor IT certificate on 2013.I have 3+ year in web development.I provide services with enthusiasm, creativity, pay until you are satisfied with my quality services and reach your purposes. My Services: Website design and development. Responsive website. Excel fomulas - Dashboard design -VBA Programming. Data entry -product upload-CMS- Virtual Assistant. Html-Css-javascript. PHP-Wordpress-C# Unity. Software Testing. Hire me for: - Fast turnaround time - satisfy 100%.Lifetime support. - Working everyday. - realtime responding.
$30 USD in 2 days
4.8 (50 reviews)
5.1
5.1
User Avatar
Dear client, I have a lot of experience with VBA and Excel. Send me a message for more information. Looking forward to work with u. Kind regards, Rens Slenders SlenDATA
$25 USD in 1 day
4.8 (20 reviews)
4.7
4.7
User Avatar
Hi there! I can take up this project right now and turn this around with a short time. Looking forward to discuss more details with you. I guess you haven't attached the files. If it's a small work I am comfortable at finishing for you at this rate. Thank you. Warm regards, Naseef Ummer
$25 USD in 0 day
5.0 (7 reviews)
3.5
3.5
User Avatar
"MACRO" Greetings! To mention about the task/job/Project, I assure you that I am an Expert and can do these kind of job VERY EASILY. I may be new to this Site, but I assure you I am very experienced and skilled with these kind of jobs The attachment is missing. "I request you to start the chat as I cannot start a chat with an Employer" Send the file in the chat, give me 30 mnts and I’ll show you the work done in 30 mnts. If you like the work, then ONLY HIRE me I take this opportunity to introduce myself as a highly talented Accountant and Analyst with strong technical knowledge and with an experience in the areas of Accounting, Algorithm, Audit and Business Analysis. With the Degrees in Engineering and MBA, I am specialized in Logical approaches and simplifying day to day business processes. With specialization in Excel and other Microsoft Office tools, I can provide the best reports merging different data from different reports exported from the software. If you need Customer/Vendor/Stock Analysis incorporating all data from different reports, then just hire me Sending customized mails or printing customized letters using Mail merge, or Business Reporting and Analysis or Presentations or Documentation or preparing some daily used templates like Invoice , I am one of the finest choices you can have. If your software cannot give you the right FIFO / LIFO adjustments for stocks / bills adjustment / ageing reports, then I'm the best choice Give me an opportunity.
$15 USD in 1 day
5.0 (1 review)
3.2
3.2
User Avatar
Hi, Your project seems to be easy and fun. I would love to do it. Randomly select a row doesn't look complex at all, it is only one statement: selected_line = Int((higher_limit - lower_limit + 1) * Rnd + lower_limit) where lower_limit is the first line in the batch of lines you want randomly select, and higher limit is the last line. For example if you want to randomly select a line between 1 and 200, then lower_limit=1, higher_limit=200. I am looking forward for your feedback. Thank you for your time. Zoltan
$15 USD in 1 day
5.0 (6 reviews)
3.1
3.1
User Avatar
A proposal has not yet been provided
$126 USD in 1 day
3.4 (4 reviews)
4.0
4.0
User Avatar
A proposal has not yet been provided
$25 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
Have written macros for excel sheet before and will be more than happy to render my services for getting the macro created to do the required job. Will look up the excel sheets and make sure the macro is working and is able to do the job wherever you use it.
$10 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
Good Afternoon, There are a few ways we can filter data and select rows for copy/paste. I would recommend an interface (control sheet) which you are able to input a value you want to filter. This will make your process versatile and user friendly. We can add some drop down menus so you can select which column you want to filter and select the quality of the match. This can be partial, exact or 'fuzzy' match. I would use an array (part of macro) to read the data set for increased speed and this also makes the macro robust and be able to work on more than one dataset if needed. The outputted results can either be on a separate spreadsheet or workbook(s). I can even filter the data by workbook depending on different parameters if needed. I specialise in data matching, integration and data distribution. I also write multi-dimensional arrays within VBA programmes (macros) which needs a high level of skill to achieve this. I have quoted the work 'macro' a few times and I will look forward to working with you if I have the successful bid. Thank you for reading my response. Jimmy Clarke
$25 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
A proposal has not yet been provided
$10 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
I have very good knowledge in excel. I have done 4 to 5 projects using macro. If you give an opportunity, I will give my best. Waiting for your positive reply. Kindly contact me if you are interested.
$15 USD in 1 day
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED KINGDOM
Kirkcaldy, United Kingdom
5.0
51
Payment method verified
Member since Jun 23, 2007

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.