Concluído

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.

Habilidades: Processamento de dados, Excel, Visual Basic

Ver mais: 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

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

ID do Projeto: #16072763

Premiar a:

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 Mais

$11 USD em 1 dia
(2 Avaliações)
0.5

38 freelancers are bidding on average $30 for this job

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 Mais

$50 USD in 0 dias
(539 Comentários)
8.1
bouslimi1979

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

$55 USD in 2 dias
(192 Comentários)
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 Mais

$50 USD em 1 dia
(225 Comentários)
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 Mais

$50 USD em 1 dia
(150 Comentários)
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 Mais

$50 USD em 1 dia
(142 Comentários)
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 Mais

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

$25 USD em 1 dia
(27 Comentários)
4.8
$30 USD em 1 dia
(21 Comentários)
4.8
usmanhassan123

A proposal has not yet been provided

$30 USD em 1 dia
(19 Comentários)
4.9
$30 USD em 1 dia
(10 Comentários)
4.6
yes0

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

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

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

$25 USD em 1 dia
(3 Comentários)
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 in 5 dias
(2 Comentários)
2.8
richcavanagh9

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

$30 USD em 1 dia
(1 Comentário)
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 Mais

$50 USD in 2 dias
(1 Comentário)
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 Mais

$30 USD em 1 dia
(2 Comentários)
1.9
tuanthanhle

A proposal has not yet been provided

$40 USD em 1 dia
(1 Comentário)
1.5
Joni058

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

$30 USD em 1 dia
(2 Comentários)
1.6
$30 USD in 0 dias
(1 Comentário)
1.0