Suoritettu

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.

Taidot: tietojenkäsittely, Excel, Visual Basic

Näytä lisää: 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

Tietoa työnantajasta:
( 65 arvostelua ) Leipzig, Germany

Projektin tunnus: #16072763

Myönnetty käyttäjälle:

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 Lisää

11 $ USD 1 päivässä
(2 arvostelua)
0.5

38 freelanceria on tarjonnut keskimäärin 30 $ tähän työhön

jaylancer43

Expert Excel Programmer on [url removed, login to view] and have been featured by the freelancer community [url removed, login to view]) Relevant Skills and Experience I am an En Lisää

50 $ USD 0 päivässä
(539 arvostelua)
8.1
bouslimi1979

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

55 $ USD 2 päivässä
(192 arvostelua)
7.2
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 Lisää

50 $ USD 1 päivässä
(225 arvostelua)
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 Lisää

50 $ USD 1 päivässä
(150 arvostelua)
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 [url removed, login to view] check reviews. Relevant Skills an Lisää

50 $ USD 1 päivässä
(142 arvostelua)
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 Lisää

25 $ USD 1 päivässä
(35 arvostelua)
5.1
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 Lisää

25 $ USD 1 päivässä
(27 arvostelua)
4.8
30 $ USD 1 päivässä
(21 arvostelua)
4.8
usmanhassan123

A proposal has not yet been provided

30 $ USD 1 päivässä
(19 arvostelua)
4.9
30 $ USD 1 päivässä
(10 arvostelua)
4.6
yes0

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

25 $ USD 2 päivässä
(57 arvostelua)
4.2
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 Lisää

35 $ USD 1 päivässä
(3 arvostelua)
3.1
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 Lisää

25 $ USD 1 päivässä
(3 arvostelua)
2.7
Carlosemadrizmor

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

28 $ USD 5 päivässä
(2 arvostelua)
2.8
richcavanagh9

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

30 $ USD 1 päivässä
(1 arvostelu)
2.8
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 Lisää

50 $ USD 2 päivässä
(1 arvostelu)
2.4
hsingla85

Available Immediately | VBA Excel | Macros Working on similar project [url removed, login to view] Relevant Skills and Experience MS Excel | Macro | Data Analysis Propo Lisää

30 $ USD 1 päivässä
(2 arvostelua)
1.9
tuanthanhle

A proposal has not yet been provided

40 $ USD 1 päivässä
(1 arvostelu)
1.5
Joni058

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

30 $ USD 1 päivässä
(2 arvostelua)
1.6
30 $ USD 0 päivässä
(1 arvostelu)
1.0