Find value across a workbook

[tompee29]

Hi,

I need some code which will find a value in a workbook.
The value will only appear once in the workbook but i wont know what sheet the value will be in.

On the attached workbook there is a simpified version.

In this example i would need to find the value in A1 in sheet a, this would be on worksheet b.

I need to scale this up though, any ideas?

Cheers,
Tom.Test Sheet.xlsm

[davesexcel]

What's your example supposed to show? they are identical sheets.
try:

Please Login or Register  to view this content.