Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
This question is also in General Questions with no response yet.
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Display columns or rows based on values | Excel Discussion (Misc queries) | |||
Lookup and Display Multiple Unique values based on criteria | Excel Worksheet Functions | |||
Display a sequence of cell values based on the week | Excel Discussion (Misc queries) | |||
Excel 2007 Display value based on values in another column range | Excel Worksheet Functions | |||
Shortcut key to display change the display from displaying cell values to cell formulae | Excel Programming |