Macro to merge data from multi sheet Excel workbooks into one file

$10-30 USD

Completed

Posted

about 4 years ago

$10-30 USD

Paid on delivery

Hi, I would like you to please write a macro in Excel which merges data from multiple Excel workbooks. I have attached a series of Excel workbooks. Each has a worksheet called Шаблон для поставщика. This worksheet has, in row 3, a series of headers, with the data from row 4 downwards. I would like the macro to go through all files in a specified local folder. Any of those files that has a worksheet called Шаблон для поставщика should have all the data in that worksheet copied into the blank workbook in which the macro operates. I will eventually be hoping to merge around 4000 workbooks so this macro should be capable with dealing with large numbers of workbooks and many rows of data. The macro should also be capable of dealing with Russian text both in file names and in the documents themselves. Thanks.

Project ID: 24926380

About the project

8 proposals

Remote project

Active 4 yrs ago

Looking to make some money?

Email address

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:

@gokulanand

Hello I can get you a macro to merge all available workbook present in a directory. I can get it done in the next 2 to 3 hours Please let me know if you are interested. Thanks Gokul

$30 USD in 1 day

5.0

(121 reviews)

6.2

8 freelancers are bidding on average $21 USD for this job

@sivashamdz

Can i get example of Russian Text within filename or content Yes hoping to merge around 4000 workbooks so this macro should be capable with dealing with large numbers of workbooks and many rows of data Shall we chat now. Siva

$25 USD in 1 day

5.0

(4 reviews)

2.6

@awaisahmadnisar

I have prior experience of data entry and data migration so I can guarantee efficient and timely work at a very reasonable quoted price. Let me know if you are interested, so we can discuss further.

$20 USD in 3 days

0.0

(0 reviews)

0.0

@GreenTec7

Hi, I am Franklyn, a software engineer. I can help you. Contact me!.

$20 USD in 7 days

0.0

(0 reviews)

0.0

@salman745657

i work properly at the time punctuality maximum i upgrade my level the best of presentation i want to work with you

$20 USD in 7 days

0.0

(0 reviews)

0.0

@asharkhursheed

Virtual Assistant|Copy Paste|Excel|Web Research|Data Scraping|Linkdin|Background Removal I would kindly invite you to contact me if you have any questions about any of the services I listed below, I am always available and pride myself on quick replies. With successful completion of course to meet your Virtual Assistance needs, I ensure that the delivery meets the standards and requirements set out during the proposal. I am looking forward to working with you! We will provide those services that are listed below: Data Entry (All type) PDF to word Copy Paste PDF to excel Scanned Pages to excel/Word Image to MS Excel/Word Data Capturing From Websites Business Cards Data Entry Manually Typing Work Products posting PowerPoint Presentation Copy Paste Wordpress Article Posting E-commerce Product Entry Social Media Management All Types of Admin work. What you will get from me? • On-time Delivery, • Best Quality Work, • Super-fast Response (24x7 Available), • 100% Accurate and Error-free Work. Regards Ashar khursheed

$15 USD in 7 days