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:
( 67 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ä
(4 Arvostelua)
1.3

36 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_26% %project_currencyDetails_sign_sub_27% tähän työhön

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

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

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

$55 USD 2 päivässä
(201 arvostelua)
7.3
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ä
(232 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ä
(152 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 [login to view URL] 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ä
(46 arvostelua)
5.3
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ä
(29 arvostelua)
4.9
usmanhassan123

A proposal has not yet been provided

$30 USD 1 päivässä
(21 arvostelua)
5.0
$30 USD 1 päivässä
(23 arvostelua)
4.8
$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
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ä
(3 arvostelua)
3.1
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
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ä
(3 arvostelua)
3.2
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
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
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 Lisää

$30 USD 1 päivässä
(3 arvostelua)
2.6
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
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 MS exel Proposed Milestones $25 US Lisää

$25 USD 1 päivässä
(2 arvostelua)
0.8