Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
rotate columns
I'm needing to keep a running total of the last 7 days of hours worked for
several employees. I have it set each time excel opens the first time each day the date will change to the new dates. however I need the columns with the hours from the corresponding days to rotate with the days to the next columns. column for day 1 moves to column day 2 and so forth. and column for day 7 will just drop off when days 6 hours move to it. if this makes sense to anyone is there a way to do it?? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
rotate columns
you could do it with a macro attached to a "Start New Day" button that
inserts a new column (which would push everything off to the right) and deletes the last column. hth susan On Mar 26, 4:31*pm, redheadnitemare wrote: I'm needing to keep a running total of the last 7 days of hours worked for several employees. *I have it set each time excel opens the first time each day the date will change to the new dates. however I need the columns with the hours from the corresponding days to rotate with the days to the next columns. *column for day 1 moves to column day 2 and so forth. and column for day 7 will just drop off when days 6 hours move to it. if this makes sense to anyone is there a way to do it?? * |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
rotate columns
Thanks Susan, i will give that a try :)
"Susan" wrote: you could do it with a macro attached to a "Start New Day" button that inserts a new column (which would push everything off to the right) and deletes the last column. hth susan On Mar 26, 4:31 pm, redheadnitemare wrote: I'm needing to keep a running total of the last 7 days of hours worked for several employees. I have it set each time excel opens the first time each day the date will change to the new dates. however I need the columns with the hours from the corresponding days to rotate with the days to the next columns. column for day 1 moves to column day 2 and so forth. and column for day 7 will just drop off when days 6 hours move to it. if this makes sense to anyone is there a way to do it?? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can I rotate data in Excel table (rows to columns, and vv)? | Excel Discussion (Misc queries) | |||
How do I rotate data in a spreadsheet so that rows become columns? | Excel Discussion (Misc queries) | |||
rotate rows and columns in a spreadsheet | Excel Discussion (Misc queries) | |||
Can I rotate excel sheets so columns are rows & vice-versa (i.e.. | Excel Discussion (Misc queries) | |||
How I do I rotate text in an excel cell? The rotate commands is g. | Excel Discussion (Misc queries) |