ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Excel 2003 points calendar (https://www.excelbanter.com/excel-discussion-misc-queries/149650-excel-2003-points-calendar.html)

shelian1

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.


All times are GMT +1. The time now is 02:30 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com