Macro - Lookup ID In Various Sheets Before Recording Data

[sgp]

Hi

I have a macro that records data into another sheet in one column based on the ID number - works great
..however now I want the macro to search ID columns in three different worksheets - tried to adjust the code but keep getting errors!!! - Is this even possilble??


Below is an example of the code, thanks!

Please Login or Register  to view this content.

[Kelshaer]

1. do you have any other sheets in the same wokbook than thos you will search in?
2. If answer to wuestion 1 is yes then provide the exact names of the 3 sheets you want to search

[sgp]

Yes that's correct.
Worksheet names are 'Minor', 'Major' and 'Direct' - I do have more worksheet but only need the macro to search in these worksheets.

Thanks.

[Kelshaer]

I can't figure out what your code does.
Anyway the below loop should contain the code that you want to run on every sheet

Please Login or Register  to view this content.

Sorry but unless you describe exactly what you want and attach a file (if possible) then that's the most I can do.

[sgp]

Thanks for you help..I tried out the code but didn't quiet work, i've attached an example - hope it makes sense! Thanks again.

[sgp]

Any ideas?

[Kelshaer]

Use this

Please Login or Register  to view this content.

[sgp]

Thanks - Just what I was looking for

However, how would I be able to code out if the details contained in different column other than one column - attached example thanks for your help!!!!

Will mark as solved

[sgp]

Example attached here!!