Copying cells from 1 sheet to multiple sheets

**stevenwhite1968** · 05-05-2011, 06:45 AM

Hi,

I have a yearly planner, containing 53 worksheets.
I populate sheet 1 with weekly tasks, monthly tasks, 3 monthly tasks and 6 monthly tasks.
I then fill the cells :
weekly: blue
monthly : green
3 monthly: yellow
6 monthly : purple

What I want to do is copy the blue cells over all 53 worksheets, into the same cell location
green cells onto every 4th worksheet
yellow onto every 12 worksheet
6 monthly onto every 26th worksheet.

so if cell "c3" was weekly, with blue fill it would be copied over all 53 worksheetsinto cell "c3".

**Mandy11** · 05-10-2011, 02:15 AM

Copy it then group the sheets you want to copy it to and paste it one of the sheets. This should copy it on all of the sheets in the same location. But be careful, it will over write whatever is currently in that cell.

**royUK** · 05-10-2011, 02:19 AM

I can't see why you need 53 , it should be possible to build one sheet to contain the tasks & another as a week view. The week view could be updated based on the date using formulas, maybe VLOOKUP or HLOOKUP. I have done similar sheets in this way

**stevenwhite1968** · 05-10-2011, 09:49 AM

I wish could do as you say Roy, but the client requires an audit trail and a view of the future work! We were doing it a very similar to your suggestion until this requirement came up.
They also need this sort of plan for in excess of 20 sites