Search across all worksheets and return the last cell in that column

[lukephillips]

Hi, I need a code that, for instance will search across multiple sheets, each called a different letter of the alphabet, for a surname, and then return the value of the cell at the bottom of its column.
I have tried looking at searching over multiple sheets, and returning the last value of a specific column, but cant get the two to work together.
Any help would be appreciated.

 

[lukephillips]

Thanks Peter. I've had a quick look and it works as treat. I never would have come up with that. Thankyou

 

[Peter_SSs]

Thanks Peter. I've had a quick look and it works as treat. I never would have come up with that. Thankyou

Glad to help.