T
tomandrobyn
Hi Frank, I just want to be able to find out which sheet (on a seperate
worksheet) has the date I'm looking for. I want to be able to enter
9-25 and have it show which sheet (Week 1, Week 2, Week 3, Week 4,
Week5) it's on for each store. The date is on L1 of each sheet and the
sheet name is on M1.
So when I enter a date in A1, each store's cell would come up with the
Week # (maybe half are on the Week 3 tab, half are on the Week 5 tab).
Thanks Frank
worksheet) has the date I'm looking for. I want to be able to enter
9-25 and have it show which sheet (Week 1, Week 2, Week 3, Week 4,
Week5) it's on for each store. The date is on L1 of each sheet and the
sheet name is on M1.
So when I enter a date in A1, each store's cell would come up with the
Week # (maybe half are on the Week 3 tab, half are on the Week 5 tab).
Thanks Frank