Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Dates that automatically update ...
Can anyone help me? What I want to do, is have excel update a timesheets pay
period dates automatically. Is this possible? For example, On a specific date, I want the pay period dates to change to the next pay period dates on 4 different sheets in the same excel document. How do I do that? If that is not possible, how can I change ONE date to change the rest of them on all 4 sheets? It is very time consuming to do it all manually. Your help is appreciated. Thank you! |
#2
|
|||
|
|||
I suspect it is possible to do the first part, but I'd have to think about it
to get to a solution. You could change one date and in the fields for the other 3 dates, reference the cell that you manually change. I'm sure someone can make this much prettier than my suggestion though. "Artanis" wrote: Can anyone help me? What I want to do, is have excel update a timesheets pay period dates automatically. Is this possible? For example, On a specific date, I want the pay period dates to change to the next pay period dates on 4 different sheets in the same excel document. How do I do that? If that is not possible, how can I change ONE date to change the rest of them on all 4 sheets? It is very time consuming to do it all manually. Your help is appreciated. Thank you! |
#3
|
|||
|
|||
hi artanis,for the second part of your question try this. if the date on
sheet one is in cell a1,activate the cell then go to edit - copy go to sheet 2 activate the cell that you want the date to change, go to edit - pasts special - past link. do this for each work sheet.the date should change every time you change the date on sheet 1. "Barb R." wrote: I suspect it is possible to do the first part, but I'd have to think about it to get to a solution. You could change one date and in the fields for the other 3 dates, reference the cell that you manually change. I'm sure someone can make this much prettier than my suggestion though. "Artanis" wrote: Can anyone help me? What I want to do, is have excel update a timesheets pay period dates automatically. Is this possible? For example, On a specific date, I want the pay period dates to change to the next pay period dates on 4 different sheets in the same excel document. How do I do that? If that is not possible, how can I change ONE date to change the rest of them on all 4 sheets? It is very time consuming to do it all manually. Your help is appreciated. Thank you! |
#4
|
|||
|
|||
It is very possible to do just that. Obviously, it will be advisable to do
it on one sheet only, and then to link the other sheets to this one. We would need more detail though to be able to help. This will be quite a complex "IF" statement, requiring maybe 12 levels, which means you will have to split your formula over at least 2 cells. I would need to know exactly what it is you want to do - cell references, changing dates etc "WYN" wrote: hi artanis,for the second part of your question try this. if the date on sheet one is in cell a1,activate the cell then go to edit - copy go to sheet 2 activate the cell that you want the date to change, go to edit - pasts special - past link. do this for each work sheet.the date should change every time you change the date on sheet 1. "Barb R." wrote: I suspect it is possible to do the first part, but I'd have to think about it to get to a solution. You could change one date and in the fields for the other 3 dates, reference the cell that you manually change. I'm sure someone can make this much prettier than my suggestion though. "Artanis" wrote: Can anyone help me? What I want to do, is have excel update a timesheets pay period dates automatically. Is this possible? For example, On a specific date, I want the pay period dates to change to the next pay period dates on 4 different sheets in the same excel document. How do I do that? If that is not possible, how can I change ONE date to change the rest of them on all 4 sheets? It is very time consuming to do it all manually. Your help is appreciated. Thank you! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I automatically update stock prices? | Excel Discussion (Misc queries) | |||
How do I automatically update chart source data links for moved fi | Charts and Charting in Excel | |||
How do I set my webpage to automatically update a changing spread. | Excel Discussion (Misc queries) | |||
Excel: How do I enter a date in one cell & automatically dates adj | Excel Discussion (Misc queries) | |||
Update multiple workbooks automatically | Excel Worksheet Functions |