Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Display a sequence of cell values based on the week
I have a block of cells with data; A1:L38. There are 169 sequences or types
of these blocks possible. Each individual block coorelates to a week from Sunday to Monday. Ex. sequence id 43 coorelates to the week of Dec 1 at 00:01 in the morning which is Monday to Sunday the 7th at 11:59 pm. This is not literally true as the first week I roll this out will actually be sequence id 1 and so on. If I rolled this out today, next week would be sequence 2. So I have 169 weeks of different combinations of these cells contained within A1:L38. How can I auto fill a sheet ("Data") with the correct block for the week that is current when you open the worksheet. Any ideas? Thanks in advance. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Display "this week" column headers w/date & day of week? | Excel Worksheet Functions | |||
Excel 2007 Display value based on values in another column range | Excel Worksheet Functions | |||
display different images based on cell value? | Excel Worksheet Functions | |||
Display zero at the begnning of a number sequence in Excel | Excel Discussion (Misc queries) | |||
Can I display a cell based on a calculation (eg M(14/2)? | Excel Worksheet Functions |