Macro to grab data from all sheets in given directory

Closed - This job posting has been filled and work has been completed.
Admin Support Data Entry Posted 3 years ago

Fixed Price

Budget: $6
Delivery by December 4, 2012

Start Date

December 3, 2012


I am in need of a macro that will grab information from all sheets in all workbook(s) located in a specific directory. I would like Columns A to N to be copied if column A contains a date. I would then like the rows copied on the second row of the workbook the macro is run from.

The workbook will be called ErrorDatabase, while the sheet with the consolidated info should be called ConsolidatedErrors.

I would to be able to choose the directory in a manner similar to this:

About the Client

(4.57) 3 reviews

United States
Brooklyn 03:08 PM

7 Jobs Posted
58% Hire Rate, 1 Open Job

$71 Total Spent
4 Hires, 0 Active

Member Since Dec 3, 2012