VBA to find in multiple sheets and place near match. Previous thread: Inventory VBA

[baxius]

Previous thread: Inventory VBA
Hello,
I've received and modified a simple VBA from one of the helpfull people in here and i was wondering if anyone could help me modify even more. The thing i need is that the range of this code would be across all documents worksheets.
I1,I2,I3 stays in the first sheet. Date and Name in any other if I2 or I3 match is found. To make it even more clear :A single Excel document with multiple Sheets. First excel sheet would be for entry of a code "I2" or "I3" in this instance. Then it would find the matching value of "I2" or "I3" on any of the sheets, place a date and "I1" (name) in adjacent cells where the matching cells were found.

Please Login or Register  to view this content.

Thank you for any help or tips.

[Pepe Le Mokko]

Descriptive title added by OP Thx

[Olly]

(pending mod request)

[baxius]

Title changed.

[Olly]

Much better title.

Put this in the worksheet module, of the sheet where you are entering values in I1:I3

Please Login or Register  to view this content.

[baxius]

Works amazing. I hope a big Thank you is enough here, because i don't know how to repay you for this help. Thank you again.

[Olly]

Great. If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

Also, as a relatively new member of the forum, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.

[baxius]

I did for the previous help. Doesn't let me do it again. Marking as solved.