Hello-
I've got a list of Vendor IDs (Col A) & Product IDs (Col G). The Vendor ID is 6 digits long, starting with 1 (10000). I have a list of product IDs for these Vendors that I created using the Vendor ID, also 6 digits long, but, the last number increments up if they have multiple products...
Hi there-
I am trying to create a data sheet that will pull (eventually) from the sheets I load to the workbook. There are many sheets, but, the data is ALWAYS in the same position on the source sheets (O10-O24). What I'm trying to do is set up the summary/helper sheet to pull the data back...
Luke-
I've tried this techinique, and, it says the address is not valid? Here's what I've got:
=HYPERLINK("[Book6.xls]Department "&A2&"!A1","Take me to Department: "&A2)
Where Book6 is my file, and, Department 23 is a sheet name in that book.
Any thoughts as to where I'm going wrong?