VBA/Excel Help (the final step)

[T-rev]

I'm almost done with my massively tedious Project, thank you to everyone who has helped me get to where i am

i only have 1 last peice to complete this massive puzzle lol

I have column L as a Category column, and 10 sheets with the names of the Categories in cell A1 of each sheet.

every sheet has a list of codes e.g XYZ,ARV etc (there are no duplicates).

i require a peice of code that looks up the code in column A on the master list, finds it on 1 of the sheets, and returns the value in cell A1 of that sheet

preferably using paste special - values only.


Thanks to all the awesome VBA and excel Guru's that take time out of their lives to help Newbies like myself

 

[T-rev]

i require a peice of code that looks up the Code in column A

i meant the VALUE in Column A, starting with A3.