Peruttu

merging data from excel files

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.

The data also has a header (first row) which shall not be copied.

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

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ää: map data excel files, check data excel files, macro compile data excel files, merging data excel word 2010, extract data excel files, macro extract data excel files, find common data excel files, compare data excel files, automatically import data multiple files excel, vbs excel import data several files, vbscript merging different collumns different excel files, combine data excel files, merging data files, fetch data excel files

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

Projektin tunnus: #16072065

28 freelanceria on tarjonnut keskimäärin 29 $ tähän työhön

bouslimi1979

Hi, I ll code a macro where you will select the folder containing the files to merge, and it will generate the output file. 2 things : do you want to select the columns to be copied ? and for invoice Relevant Skills a Lisää

100 $ USD 3 päivässä
(192 arvostelua)
7.2
The24CarrotsInc

Greetings for the day!! We have experience working on this subject. We ensure 100% QUALITY with ON-TIME Deliveries. Please allow us to take this opportunity. Thanks & Regards, Team@The24CarrotsInc Relevant Skills an Lisää

15 $ USD 1 päivässä
(54 arvostelua)
5.3
zu02

Hi, there I can code your current project Relevant Skills and Experience I'm programming in VB/SQL/Access since 1997 Proposed Milestones $30 USD - default

30 $ USD 1 päivässä
(27 arvostelua)
5.6
magentapowa

Hello You mention you will manually select columns, for example "B:G". Will this apply to all workbooks from the selected group of workbooks? Either way I can definitely help you. Relevant Skills and Experience I hav Lisää

25 $ USD 1 päivässä
(21 arvostelua)
3.9
huongth

Hi. I can create auto scripts to scrape websites, auto click, format txt, csv, xls, xlsx, doc, docx, rtf, json, xml, database files as you request. I can start right now Relevant Skills and Experience I am an expert i Lisää

30 $ USD 1 päivässä
(14 arvostelua)
3.4
hsingla85

Available Immediately | Excel Expert | VBA Guru | Assured quality of the work. Working on similar project [url removed, login to view] Stay tuned, I'm still working on Lisää

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

Dear Sir I saw your project now and I can do and I can give you quality work so if you chose me for your project then please message me. Thank You Relevant Skills and Experience Data Processing, Excel, Visual Basic P Lisää

25 $ USD 1 päivässä
(1 arvostelu)
1.7
w3saddam

Dear sir I am honest and hard worker . I am full time freelancer . I will start now . Give me a chance to make a sample if you like my sample then you can hire me Regards saddam hossen Relevant Skills and Experience Lisää

20 $ USD 1 päivässä
(1 arvostelu)
0.8
maitham10

I did same task before. I would be more than happy to help you with your excel file. Looking forward to hear from you Relevant Skills and Experience I am an auditor who spends most of his time working on excel. If yo Lisää

10 $ USD 1 päivässä
(3 arvostelua)
0.9
25 $ USD 1 päivässä
(1 arvostelu)
0.4
Hilyadinda

A proposal has not yet been provided

15 $ USD 1 päivässä
(0 arvostelua)
0.0
sajedkhan1206

Assalam O Alaikum.. you can give me oppertunity.. thanks Relevant Skills and Experience i have already more than 6 years experience in data Entry Proposed Milestones $25 USD - 123

25 $ USD 1 päivässä
(0 arvostelua)
0.0
25 $ USD 1 päivässä
(0 arvostelua)
0.0
dmungroo

A proposal has not yet been provided

25 $ USD 3 päivässä
(0 arvostelua)
0.0
masudnatseo

Hello I am interested to to this project. I am available to start your project right now. I have a high speed internet connection and my typing speed really cool. Thanks Relevant Skills and Experience Data Processing, Lisää

25 $ USD 1 päivässä
(0 arvostelua)
0.0
adrian1696

I have an average typing speed of 80 wpm and above 90% accuracy and proficient with most computer office tools. I also take note of every detail that I am given and finish tasks before deadlines. I make sure to give 10 Lisää

20 $ USD 2 päivässä
(0 arvostelua)
0.0
ronyislam1996

Hello sir! I saw your project. I can do it . I am a new freelancer but I am expert in data entry. I hope I can give you my best work Which you want. Please give me this job sir. Thank you! Relevant Skills and Experien Lisää

16 $ USD 1 päivässä
(0 arvostelua)
0.0
nkch754964

A proposal has not yet been provided

25 $ USD 7 päivässä
(0 arvostelua)
0.0
sohelpct

A proposal has not yet been provided

20 $ USD 1 päivässä
(0 arvostelua)
0.0
imchandan1996

Hey , I am very motivated and I like to learn new things not only in IT, but in my life. I am a very friendly person and a good team player. Relevant Skills and Experience i have good knowledge with great experience Lisää

14 $ USD 1 päivässä
(0 arvostelua)
0.0