Find Jobs
Hire Freelancers

Create a macro that will continuously copy multiple sheets into one sheet

$30-250 USD

Cancelled
Posted almost 11 years ago

$30-250 USD

Paid on delivery
I have an excel file with multiple (more than 20) spreadsheets, each spreadsheet contains some data. I need to create a macro that will copy three columns that are located at different locations from each spreadsheet and paste the data from the three columns into another summary spreadsheet. The macro must be able to update the summary spreadsheet when I make changes in the multiple (more than 20) spreadsheets and also copy three columns when I add a new sheet.
Project ID: 4751365

About the project

16 proposals
Remote project
Active 11 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
16 freelancers are bidding on average $103 USD for this job
User Avatar
Kindly Please check my comments, past feedback in the following message board, we look forward to your response.
$178 USD in 4 days
4.9 (179 reviews)
6.5
6.5
User Avatar
Consider it done. Check your PM for my bid details.
$111 USD in 1 day
5.0 (73 reviews)
5.6
5.6
User Avatar
Such jobs are my daily practice. In my approach you'll have opportunity to consult details with me, to test pilot solutions if necessary in order to achieve an optimal final solution. Further use of macros, fixing of bugs and minor changes are included in the bid without any additional fees. Regards
$111 USD in 3 days
4.9 (48 reviews)
5.6
5.6
User Avatar
It seems a quick task for a Excel macro expert.....Lets discuss the procedure in detail and start off......I can complete Macro within few hours.
$64 USD in 1 day
5.0 (92 reviews)
5.5
5.5
User Avatar
Hi, I will give u an appliaction which will take the excel file paths and do all of stuff automatically. Advantage of this is, it will work on that system also where there is no excel installed. See my similar applications links in your PMB
$150 USD in 3 days
5.0 (21 reviews)
5.4
5.4
User Avatar
I can take on the job. Let me know.
$111 USD in 3 days
5.0 (72 reviews)
5.2
5.2
User Avatar
Hello; I read your project, and got the point exactly... your 5-star excel & vba coding expert is ready to help you...regards,
$80 USD in 3 days
5.0 (38 reviews)
5.1
5.1
User Avatar
Excel VBA Expert. Please check PM for details. Thanks.
$66 USD in 3 days
5.0 (14 reviews)
3.7
3.7
User Avatar
Hi, I have over 8yrs of experience working with excel macros and formulas. I would like to take up this project. Please provide me some sample data so we can get started. thanks & regards
$60 USD in 5 days
4.7 (7 reviews)
2.7
2.7
User Avatar
Can help you with this
$172 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Ready to start this job for you quickly and with high quality. Faraoon
$70 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
I can easily do that job for you.
$100 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Efficient & dedicated freelancer, always provide a timely & quality deliverables, proficient in excel. Have delivered such projects in past & assure you quality deliverable. I am 13+ years of experience in this field please rest assured you will be leaving it in safe hands.
$111 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I can take of this immediately and have extensive experience with excel in nearly every IT job I have held. My bid is relatively low as I am new to Freelancer and am looking to get some work to develop a reputation.
$60 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
Greetings for the United Kingdom! Hi Macartria, I'm a newbie to freelancer and looking to start on my first project. I'd love to get cracking on your project asap and am happy to say I've got the necessary VBA macro programming skills to do everything that you have requested in your brief. I will aim to create a macro which detects the number of sheets within the workbook and if this changes will automatically repopulate the 'Summary Sheet' which will filter just for the 3 columns that you have asked for. I'm happy to turn this around within 24 hours if you let me know asap that you would like my services and that the spreadsheets are nicely laid out. Feel free to send me a copy of your spreadsheet via direct message if you wish me to glance my eyes over it and provide any advice. Look forward to hearing from you. Kindest Regards ExcelDictionary
$55 USD in 1 day
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED STATES
Los Angeles, United States
5.0
18
Payment method verified
Member since Jun 16, 2010

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.