Find & copy

[Paul08]

Can anyone please help with this as i dont know much about VBA

I have a workbook made up of multiple sheets, columns B-H contain the data and column A is a reference to that data

I would like to search through all the sheets to find n (whatever i input) and return that value on a new sheet along with its reference in column A

Many Thanks

[JOHN H. DAVIS]

Maybe:

Please Login or Register  to view this content.

[AB33]

This is code from Ron and adjusted by some one for my needs. It may not be give a solution, but it will give a start

Please Login or Register  to view this content.