Hi,
I have a big work book which is running multiple vlookups but it is really slow so i'm trying to put all my information onto one worksheet and have the vlookup look at that sheet rather than 20 other worksheets as well. i was wondering if there is a way to reference the multiple sheets to the one sheet automatically. I need to be able to add rows to the other sheets as these will keep growing over time.
The sheet i would like to put all the other information is called "combined parts"
I have attached an example of what i would like to do.
Thanks.
ND
Bookmarks