Okay, I have figured out how to do a VLOOKUP from two different workbooks based off a thread I have found in this site (very helpful). What I need to do is a lookup from one workbook to another where the data set I need is in one workbook, but I'm not trying to match on anything. I simply want to pull in that data set for comparison.
To take this one more step, I have to create a new worksheet every week based off date. So, I need the formula to continously reference the one workbook regardless of creating a new worksheet.
Thanks, you guys do great work and are a huge service to the average joe's such as myself.
To take this one more step, I have to create a new worksheet every week based off date. So, I need the formula to continously reference the one workbook regardless of creating a new worksheet.
Thanks, you guys do great work and are a huge service to the average joe's such as myself.
