timmo246
04-06-2012, 12:21 AM
Hello,
I'm just a beginner at VBA and need help to build a macro to search for values (unique ID) from 1 workbook containing one worksheet in another workbook containing 8 worksheets and then display the result in the first workbook.
I would like the macro to run in a file called 'G_W_P.xlsx' that contains a unique ID string (e.g. CBX246) in Column A only. Column A has approximately 400 rows.
The macro would need to look at Row 2 in Column A of this workbook ('G_W_P.xlsx') and search for the unique ID fom that cell within Column A of eight different sheets of a second workbook file called 'G&W - S&C.xlsx'.
I would like the macro to display the worksheet(s) from 'G&W - S&C.xlsx' where the unique ID was found in Column B, C, D etc. of 'G_W_P.clsx' next to the unique ID that was searched for.
The macro would then repeat the process for all rows within the first workbook ('G_W_P.xlsx').
Could someone tell me if this is possible and how hard it would be to code?
Many thanks,
Tim.
I'm just a beginner at VBA and need help to build a macro to search for values (unique ID) from 1 workbook containing one worksheet in another workbook containing 8 worksheets and then display the result in the first workbook.
I would like the macro to run in a file called 'G_W_P.xlsx' that contains a unique ID string (e.g. CBX246) in Column A only. Column A has approximately 400 rows.
The macro would need to look at Row 2 in Column A of this workbook ('G_W_P.xlsx') and search for the unique ID fom that cell within Column A of eight different sheets of a second workbook file called 'G&W - S&C.xlsx'.
I would like the macro to display the worksheet(s) from 'G&W - S&C.xlsx' where the unique ID was found in Column B, C, D etc. of 'G_W_P.clsx' next to the unique ID that was searched for.
The macro would then repeat the process for all rows within the first workbook ('G_W_P.xlsx').
Could someone tell me if this is possible and how hard it would be to code?
Many thanks,
Tim.