VBA Vlookup multiple sheets

[kh4w4r]

Hello,
A novice question, is it possible to make a search sheet and after the criteria for search is entered.
A code to look for the results from multiple sheets and bring back results.
E.g.
I have 10 different suppliers and if I put in a supplier number and search and results I am after is you received delivery twice in March and once in May and so on.


Sent from my iPhone using Tapatalk

[tranhaithang]

Hi kh4w4r,
if it's possible, can you post an example here?
My suggestion is before jumping to VBA, we could play around with indirect & index first. it would be easier when after sometimes you review your formula again

Thang Tran

[kh4w4r]

Thanks for the reply Thang; I will post in few days time. I do not want to be rude by not replying thought just let you know.


Sent from my iPhone using Tapatalk