Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2003 points calendar
I am using one of your spreadsheets for attendance/points for our employees
to keep track of their days missed. I started it last Aug & now I had to revamp it to carry over points from last year to this year. But now I need to change the calendar dates for this year & I want all the work sheet to be able to change with the MASTER sheet. So in other words I want to change the MASTER sheet calendars & all the other 50 sheets read what is changed on the MASTER sheet. That way I would only have to make the changes once (ON THE MASTER) & the rest would change with it. HOW DO I DO THAT? I tried to copy & paste special function but that takes so long & then it also puts "0" in every cell that don't have anything in it on the MASTER. Can anyone help me with this. I hope I have made it clear to what I want to do. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Calendar in Excel 2003 | Excel Discussion (Misc queries) | |||
Column chart not displaying some data points - Excel 2003 | Charts and Charting in Excel | |||
Benefit attendance calendar make 2 items .5 points not 1 pt | Excel Worksheet Functions | |||
Excel 2003 xy chart - problem plotting more than 330 points | Charts and Charting in Excel | |||
Outlook 2003 calendar events into Excel 2003? | Excel Discussion (Misc queries) |