Hey, I have been working on a project for awhile now that has involved a large inventory sheet to keep track of medical supplies. Currently I have been working on a two way Vlookup. I can look up an items serial sumber and it will auto fill the name or I can look up the name and it will auto fill the serial number. With my two weeks of learning of VBA in my spare time I have built a couple of different small Macros that function as Vlookup. However there are 3 problems I am running into, which is why I'm here.
1) The reference sheet or master sheet, where I am looking up the data, is a separate workbook. I can get around this with a Vlookup Formula in the cell itself, but in VBA I keep hitting brick walls, and it wont pull from the external reference book.
2) I can get Vlookup to work for a single row, but in my workbook I have 50 rows across 23 worksheet. I could copy and paste the line of code 50 times and adjust a couple of data points, but there has to a be a more efficient way for the program to do it. I don't mind putting in the workm but when I hit execute I don't want to strain the system.
3)Goes hand in hand with (2) I have 23 worksheets I want to apply this to, however, I want to exclude the 24th worksheet as it is a totals worksheet. How do I apply this to some worksheet and not others in the workbook. I have tried building an array, but the Vlookup function keeps rejecting it.
Thanks for any help or advise you can give.
Bookmarks