I am using MS office 2000. I use query to import a list of client names and their individual contract numbers from a billable report which is in a separate excel workbook.
EX:
15 ABC
30 Group
12 Joe Smith Co.
I then take this info and put it into a chart. My problem is that each new week, I create a new billable report worksheet. Currently my query data is coming from 071407 but now I want it to come from 072807 and so on and so forth. How can I change this? (And if so, automatically would be great). Thanks!
EX:
15 ABC
30 Group
12 Joe Smith Co.
I then take this info and put it into a chart. My problem is that each new week, I create a new billable report worksheet. Currently my query data is coming from 071407 but now I want it to come from 072807 and so on and so forth. How can I change this? (And if so, automatically would be great). Thanks!