Completed

Excel VBA script to consolidate data

I need an Excel VBA script written to append data to a master worksheet.

Example Scenario

I have a new & empty workbook [login to view URL]

I have multiple files, all of which contain 1 worksheet.

I need to copy specific data from the worksheet and paste it into the master worksheet.

The range of data may vary. The range of data to be copied usually starts at cell A6 and ends P##. There is always a blank row following the last row of data to be copied. So you’ll need to dynamically find the data range.

It would be nice if I could select multiple files at a time, or at least point to a file directory and have the script process all files that exist.

Skills: Excel VBA, Excel, Excel Macros

See more: excel vba access sheet data, excel vba return xml data type, excel vba script modify existing vba, excel macro script insert data spreadsheet, excel vba update imported data, excel vba speed filling data, simple excel vba script, excel vba script find text, excel vba browse refresh data, excel vba chart show data table, excel vba change pivot data sources, excel vba insert csv data access database, excel vba script merge cells, excel vba refresh sheet data, excel vba compare columns data report, excel vba dashboard project data, excel vb script import data web, vba script scrape data website, excel vba script scrape website

About the Employer:
( 3 reviews ) Bel Air, United States

Project ID: #20285993

Awarded to:

bluesea1990

Happy [login to view URL] is your day? I have full experience in Excel Excel VBA Excel Macros . I can start just now and can do it perfectly. I hope to discuss more via chatting.Thanks.

$35 USD in 1 day
(3 Reviews)
2.8

7 freelancers are bidding on average $42 for this job

polarjin2017

Hello? Nice to meet you. I am excited to work with you on this project. I am ready to start work immediately. This is what i have done in Excel/Word/PPT/Access/VBA/MACRO. Just Creating forms, query, Macro, custom f More

$40 USD in 10 days
(84 Reviews)
6.6
rumarahman

I have 10 years experience with Data Processing in Excel. I work with: Excel Data Processing Data Collecting (Using Macro) MS Office VBA Excel VBA Macro Automation User Forms Data Analyzing PivotTable Char More

$80 USD in 1 day
(37 Reviews)
5.1
xinglong717

Hi. How are you? I read your description carefully and am very interesting in your project. I can start right now and can help you. If you hire me,i will do my best for your job and you can get the best results. Lookin More

$50 USD in 1 day
(9 Reviews)
4.1
sunshine7677

**Please send me a Message to discuss** Dear Client, I am Expert in Excel. I have 5+ Years of Experience in Data Entry, Web Scrapping, Web Research and MS Office. I will be there during your working hours to provid More

$30 USD in 1 day
(9 Reviews)
3.0
Karanpatel07

I will complete your work with professional skills I will fulfill your all needs I will attached rough copy of work so u can understand easily

$30 USD in 3 days
(0 Reviews)
0.0
sami31725

We have professional employ who have 3 to 4 years experience for data entry, data analysis, data collection, formatting, conditional formatting excel and virtual assistance. We will work for company and for individuals More

$30 USD in 14 days
(0 Reviews)
0.0