Завершено

excel macro for importing data from excel sheets inside a folder into a single sheet

Hi,

I have the following requirements for an excel macro: There is a folder with many excel files containing data, and I want to merge these files.

The data within the files have a similar structure: a fixed number of columns (to be defined manually within the macro) and a variable number of rows. All files have the same header (first row) which shall be copied only once. So, I would like to have an excel file with macro code in which I want to define the folder (not all the single file names!) comprising the files to be “merged”, I want to define the number of relevant columns, and the macro shall merge the data. Merging means opening each individual file, copy the data, and paste it to the file comprising the macro. If e.g. the first file comprises data in the cells A2: P30 (A1:P1 would be the header that shall not be merged), the data from the cells A2:P30 shall be copied into the excel file with the macro, being pasted into cells A2:P30. Then the original data file shall be closed again, the next file from the folder shall be opened (maybe you do the opening in alphabetical order), data shall be copied (e.g. in this case A2: P6), and pasted to the excel file with the macro, specifically into cells A31:P35, etc. These cell ranges are examples only! Please note that some files may comprise more than 1k lines

The macro should work for both xls and xlsx

I added two files to be processed, and a file comprising merged data.

Final remark: I finally need an invoice. As invoices don’t comprise amounts paid via milestones, I don’t work with milestones. If you insist on a milestone, you should look for another project.

Квалификация: Обработка данных, Excel, Visual Basic

Показать больше excel vba import worksheet from another workbook, macro to import data into excel, excel macro import data from another workbook, excel vba import data from another excel file, excel vba import data from another workbook without opening, vba import file, excel vba copy sheet from another workbook without opening, excel vba import worksheet from closed workbook, macro update data multiple sheets sheet, excel macro sort data existing sheets, macro excel sheets merging folder, excel macro copy files single sheet, excel macro post data url sheet, macro importing data internet exlorer excel 2007, importing data excel sheet j2ee struts web applications

О работодателе:
( 67 отзыв(-а, -ов) ) Leipzig, Germany

ID проекта: #16072763

Поручен:

maitham10

Easy task. I can give you more than one option to do it in macro. Just let me know if you need my help. I will be more than happy to help you with that file. Relevant Skills and Experience I am an external auditor. My Больше

$11 USD за 1 день
(4 отзывов(-а))
1.3

36 фрилансеров(-а) в среднем готовы выполнить эту работу за $31

jaylancer43

Expert Excel Programmer on freelancer.com and have been featured by the freelancer community https://www.freelancer.com/community/articles/jay-patkar-freelancer-success-story) Relevant Skills and Experience I am an En Больше

$50 USD за 0 дней(-я)
(549 отзывов(-а))
8.1
bouslimi1979

ALL IS CLEAR Relevant Skills and Experience VBA Proposed Milestones $55 USD - m

$55 USD за 2 дней(-я)
(201 отзывов(-а))
7.3
schoudhary1553

Greeting, I have understood your excel macro for importing data from excel sheets inside a folder into a single sheet task and can do it with your 100% satisfaction. Relevant Skills and Experience I have more than 5 Больше

$50 USD за 1 день
(232 отзывов(-а))
7.3
avinav606lx

Hi there, I can provide you quick solution which is independent of number of files and record in the folder. I can provide you the invoice. I can write the VBA script quickly. I'm an expert in Excel VBA with over 5+ y Больше

$50 USD за 1 день
(152 отзывов(-а))
6.4
rengrish

Hi I have already done same kindly of requirements. I have code immediately and i can complete the job within hour or two. Kindly ping back. I assure you 100% accurate [login to view URL] check reviews. Relevant Skills an Больше

$50 USD за 1 день
(142 отзывов(-а))
5.9
SShtv

Your task is clear to me and I am ready to do it for a total amount of 25USD I have a lot of practical experience in Excel, including programming in VBA. Relevant Skills and Experience This is a screenshot of one of m Больше

$25 USD за 1 день
(46 отзывов(-а))
5.3
aimefx

Hi, I can I can merge all excel files in a filter into one file. and I can automate that when you add new files in folder it will update to merged file. Relevant Skills and Experience 7 years experience in excel. Pro Больше

$25 USD за 1 день
(29 отзывов(-а))
4.9
usmanhassan123

A proposal has not yet been provided

$30 USD за 1 день
(21 отзывов(-а))
5.0
$30 USD за 1 день
(23 отзывов(-а))
4.8
$30 USD за 1 день
(10 отзывов(-а))
4.6
yes0

Stay tuned, I'm still working on this proposal.

$25 USD за 2 дней(-я)
(57 отзывов(-а))
4.2
Carlosemadrizmor

I already have this macro, I just need to update for your requirement. You only will pay after feel happy.

$28 USD за 5 дней(-я)
(3 отзывов(-а))
3.1
CanadianQuality

Native English speaker, Excel/VBA Expert. I've looked over your files and can do this for you. No problem. Send me a chat request if you'd like to talk further! Relevant Skills and Experience I do this kind of stuff Больше

$35 USD за 1 день
(3 отзывов(-а))
3.1
Overseashelp

Hello, i am interested in your project. you can check my profile to have an idea about my reviews. I can create the macro you need to merge data into one sheet. Waiting ti hear from you. thank you. Relevant Skills and Больше

$50 USD за 2 дней(-я)
(3 отзывов(-а))
3.2
Devotion20

Hi there! I have this code written already. Let me know if you are interested. I’m Bhakti from India and I’m really interested in the project you’ve posted. I am ok with your invoice condition Relevant Skills and Expe Больше

$25 USD за 1 день
(3 отзывов(-а))
2.7
richcavanagh9

Hello. US citizen. English is primary language. I understand your project, clearly, and I can build you a solution.

$30 USD за 1 день
(1 отзыв)
2.8
hsingla85

Available Immediately | VBA Excel | Macros Working on similar project https://www.freelancer.com/projects/php/process-excel-csv-files-manpluate/ Relevant Skills and Experience MS Excel | Macro | Data Analysis Propo Больше

$30 USD за 1 день
(3 отзывов(-а))
2.6
tuanthanhle

A proposal has not yet been provided

$40 USD за 1 день
(1 отзыв)
1.5
Joni058

Allow me to do this task pls You will love my work :) Looking forward to your kind response ....

$30 USD за 1 день
(2 отзывов(-а))
1.6
krishnaagr89

Hi,I have read your requirements and I’m pretty confident that I will be able to get your work done within the given time your requirements conclude., Relevant Skills and Experience MS exel Proposed Milestones $25 US Больше

$25 USD за 1 день
(2 отзывов(-а))
0.8