| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Automatically rotate Months and Data
Hi,
I have a sheet that I am working on similar to this: Product Sales November October September YTD Product Views 1,131,753 28,012,673 30,080,398 140,200,182 I have the months setup as follows: =DATE(2008,(MONTH(NOW())),1) =DATE(2008,(MONTH(NOW()))-1,1) =DATE(2008,((MONTH(NOW()))-2),1) The problem is I have not figured out how to get the data to automatically change. Right now I have the data pulling from a second sheet using VLOOKUP. At the beginning of each month I need to go edit the data to reflect the correct month. Any Thoughts on how I can have the data automatically roll like the months? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Automatically Transfer Clients from last 4 months to another sheet | Excel Discussion (Misc queries) | |||
| How do i rotate data - see below | Excel Discussion (Misc queries) | |||
| Automatically update charts for only the most current 12 months? | Charts and Charting in Excel | |||
| sum automatically from last 12 months based on current date | Excel Worksheet Functions | |||
| How I do I rotate text in an excel cell? The rotate commands is g. | Excel Discussion (Misc queries) | |||
Threaded Mode
