I'm reposting this question maybe a little better then last time.
Thanks to Andrew Poulsom for answering the last post. I didn't see anything in "template wizard for date tracking" that would do what I'm wanting, unless I'm overlooking it.
I have worksheet 1 I'd like to link the data to that date in the calender on worksheet 2
Sample of what I'd like the out come to be.
I was thinking of an IF statement in each cell, was hoping for something a little simpler.
Thanks to Andrew Poulsom for answering the last post. I didn't see anything in "template wizard for date tracking" that would do what I'm wanting, unless I'm overlooking it.
I have worksheet 1 I'd like to link the data to that date in the calender on worksheet 2
Sample of what I'd like the out come to be.
Book1 | ||||||
---|---|---|---|---|---|---|
A | B | C | D | |||
5 | Date | 9/7/2006 | ||||
6 | ||||||
7 | Job# | 65023-j | ||||
8 | ||||||
9 | Customer | State of AL | ||||
10 | ||||||
11 | impressions | 2,000,000 | ||||
Sheet1 |
Book1 | |||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | |||
1 | Sep-06 | ||||||||||||||||||||||
2 | Sunday | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday | ||||||||||||||||
3 | 27 | 28 | 29 | 30 | 31 | 1 | 2 | ||||||||||||||||
4 | job# | customer | Impression | job# | customer | Impression | job# | customer | Impression | job# | customer | Impression | job# | customer | Impression | job# | customer | Impression | job# | customer | Impression | ||
5 | |||||||||||||||||||||||
6 | |||||||||||||||||||||||
7 | |||||||||||||||||||||||
8 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | ||||||||||||||||
9 | job# | customer | Impression | job# | customer | Impression | job# | customer | Impression | job# | customer | Impression | job# | customer | Impression | job# | customer | Impression | job# | customer | Impression | ||
10 | 65023-j | State of AL | 2,000,000 | ||||||||||||||||||||
11 | |||||||||||||||||||||||
12 | |||||||||||||||||||||||
Sheet2 |
I was thinking of an IF statement in each cell, was hoping for something a little simpler.