Hi there,
I need help to find an automated way to find data within a workbook and copy it over to another sheet.
On sheet 2 I have a list of data which I need to find from a huge amount of data on sheet 1.
Once the row has been found in sheet 1, it needs to automatically copy and paste onto a new sheet (sheet 3).
Please note for each row of data on sheet 2 there may be 1 or more rows of data in sheet 1 that needs to be found and copied to sheet 3.
Each day I will have a new list in sheet 2 that will need to be found in sheet 1 and copied to sheet 3.
The whole row in sheet 1 with the matching data should be copied into sheet 3 automatically.
I am not sure where to begin....
thanks
Gaynor
I need help to find an automated way to find data within a workbook and copy it over to another sheet.
On sheet 2 I have a list of data which I need to find from a huge amount of data on sheet 1.
Once the row has been found in sheet 1, it needs to automatically copy and paste onto a new sheet (sheet 3).
Please note for each row of data on sheet 2 there may be 1 or more rows of data in sheet 1 that needs to be found and copied to sheet 3.
Each day I will have a new list in sheet 2 that will need to be found in sheet 1 and copied to sheet 3.
The whole row in sheet 1 with the matching data should be copied into sheet 3 automatically.
I am not sure where to begin....
thanks
Gaynor