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

Fullført Lagt ut 6 år siden Betales ved levering
Fullført Betales ved levering

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.

Databehandling Excel Visual Basic

Prosjekt-ID: #16072763

Om prosjektet

33 bud Eksternt prosjekt Aktiv 6 år siden

Tildelt til:

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 Mer

$11 USD på 1 dag
(7 omtaler)
1.8

33 frilansere byr i gjennomsnitt $32 for denne jobben

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 Mer

$50 USD på 0 dager
(821 Omtaler)
8.8
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 Mer

$50 USD på 1 dag
(426 Omtaler)
8.3
bouslimi1979

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

$55 USD på 2 dager
(314 Omtaler)
7.8
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 Mer

$50 USD på 1 dag
(179 Omtaler)
6.6
usmanhassan123

A proposal has not yet been provided

$30 USD på 1 dag
(93 Omtaler)
6.5
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 Mer

$25 USD på 1 dag
(100 Omtaler)
6.3
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 Mer

$30 USD på 1 dag
(10 Omtaler)
4.6
yes0

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

$25 USD på 2 dager
(59 Omtaler)
4.3
Carlosemadrizmor

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

$28 USD på 5 dager
(5 Omtaler)
3.8
Joni058

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

$30 USD på 1 dag
(6 Omtaler)
3.4
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 Mer

$25 USD på 1 dag
(7 Omtaler)
3.5
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 Mer

$50 USD på 2 dager
(3 Omtaler)
2.9
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 Mer

$35 USD på 1 dag
(3 Omtaler)
3.1
richcavanagh9

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

$30 USD på 1 dag
(1 anmeldelse)
2.8
tuanthanhle

A proposal has not yet been provided

$40 USD på 1 dag
(1 anmeldelse)
1.5
vikptbar

Hi! I'm expert in Microsoft Excel and Visual Basic for Applications. I can complete your project in few days. No milestones :) Relevant Skills and Experience excel, vba Proposed Milestones $50 USD - For all the work

$50 USD på 2 dager
(0 Omtaler)
0.0
Thebestuget

I have excellent skills on Excel. I can do this project in quick time. I have written excel micros for split and merge of 10+ files. This would be an excellent project Turnaround time will be one day Relevant Skills a Mer

$25 USD på 1 dag
(0 Omtaler)
0.0
Rabbanyhossain

Hi there, I see the job requirement. I have an experience in this type of work. More on chat. Thanks Relevant Skills and Experience Data Processing, Excel, Visual Basic Proposed Milestones $25 USD - complete

$25 USD på 1 dag
(0 Omtaler)
0.0
Benita13

Hi, I’m currently working at Citibank as a data manager, hope I can help you. Benita

$25 USD på 1 dag
(0 Omtaler)
0.0
AttaMuhammad786

Dear Employer, With my best experiences, which are required for your project, makes me a better candidate to bid on your project, Relevant Skills and Experience Dear Employer, With my best experiences, which are requi Mer

$25 USD på 2 dager
(0 Omtaler)
0.0