Cancelado

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.

Habilidades: Processamento de dados, Excel, Visual Basic

Veja mais: map data excel files, check data excel files, macro compile data excel files, how to merge multiple excel files into one workbook 2010, merge multiple excel files into one sheet vba, combine multiple excel files into one workbook vba, consolidate data from multiple worksheets in a single worksheet, combine excel files into one workbook, how to combine multiple excel files into one worksheet using macro, copy data from multiple worksheets into one, macro to consolidate data from multiple workbooks, sql, excel, vb.net, 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

Acerca do Empregador:
( 68 comentários ) Leipzig, Germany

ID do Projeto: #16072065

26 freelancers estão ofertando em média $29 para esse trabalho

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 Mais

$100 USD in 3 dias
(213 Comentários)
7.3
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 Mais

$15 USD em 1 dia
(61 Comentários)
5.7
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 em 1 dia
(29 Comentários)
5.7
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 Mais

$25 USD em 1 dia
(29 Comentários)
4.1
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 Mais

$30 USD em 1 dia
(16 Comentários)
3.6
$25 USD em 1 dia
(6 Comentários)
3.2
hsingla85

Available Immediately | Excel Expert | VBA Guru | Assured quality of the work. Working on similar project https://www.freelancer.com/projects/php/process-excel-csv-files-manpluate/ Stay tuned, I'm still working on Mais

$30 USD em 1 dia
(4 Comentários)
2.7
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 merging data from excel files Propo Mais

$25 USD em 1 dia
(3 Comentários)
2.3
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 Mais

$25 USD em 1 dia
(3 Comentários)
2.3
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 Mais

$10 USD em 1 dia
(4 Comentários)
1.3
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 Mais

$20 USD em 1 dia
(1 Comentário)
0.8
$25 USD em 1 dia
(0 Comentários)
0.0
dmungroo

A proposal has not yet been provided

$25 USD in 3 dias
(0 Comentários)
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 Mais

$20 USD in 2 dias
(0 Comentários)
0.0
nkch754964

A proposal has not yet been provided

$25 USD in 7 dias
(0 Comentários)
0.0
sohelpct

A proposal has not yet been provided

$20 USD em 1 dia
(3 Comentários)
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, Mais

$25 USD em 1 dia
(0 Comentários)
0.0
adnankhan54321

I am Professional Data administrator and Personal assistance. Relevant Skills and Experience I have been working for last 5 years. I am expert of data-entry,Accounting,Microsoft Access, MS-Word, PowerPoint, Excel, Cop Mais

$25 USD em 1 dia
(0 Comentários)
0.0
Saran2493

A proposal has not yet been provided

$20 USD in 2 dias
(0 Comentários)
0.0
$25 USD em 1 dia
(0 Comentários)
0.0