Hi
I am looking for a way to automate gathering survey data collected on excel worksheets onto a master database.
I need to copy from the range $A$2:$C11 on a Worksheet named "Survey" from up to 400 workbooks into one worksheet, along with the Workbook name column $A and the data into the columns $B:$D. All workbooks will be located in the one directory.
The data from the next worksheet is to be placed directly below the last data pasted.
There will also be a hidden worksheet "Lookup".
The data should look as follows:
FileName Report Ad hoc Frequency
CC2200 ERA No Never
CC2200 GR Yes Never
CC2200 HL Yes Monthly
CC2200 IES No Annually
CC2200 MCI Yes Annually
CC2200 NCI Yes Annually
CC2200 OLS Yes Annually
CC2200 RAS Yes Weekly
CC2200 RTC No Weekly
CC2200 VAR No Annually
Information in Column A should be the file name and the data placed in Columns B:D
There is no issue about the sequence of the data.
I would greatly appreciate any assistance.
Thanks in advance
I am looking for a way to automate gathering survey data collected on excel worksheets onto a master database.
I need to copy from the range $A$2:$C11 on a Worksheet named "Survey" from up to 400 workbooks into one worksheet, along with the Workbook name column $A and the data into the columns $B:$D. All workbooks will be located in the one directory.
The data from the next worksheet is to be placed directly below the last data pasted.
There will also be a hidden worksheet "Lookup".
The data should look as follows:
FileName Report Ad hoc Frequency
CC2200 ERA No Never
CC2200 GR Yes Never
CC2200 HL Yes Monthly
CC2200 IES No Annually
CC2200 MCI Yes Annually
CC2200 NCI Yes Annually
CC2200 OLS Yes Annually
CC2200 RAS Yes Weekly
CC2200 RTC No Weekly
CC2200 VAR No Annually
Information in Column A should be the file name and the data placed in Columns B:D
There is no issue about the sequence of the data.
I would greatly appreciate any assistance.
Thanks in advance