Automatically populate forward planner based on interval

[mobileangusAIM]

Hi,

I have a requirement to forward plan events at a 6 weekly interval for a 12 month period, each cell is a week number and I put a 1 in the cell that corresponds to the event happening in that week.


However, sometimes the event happens early and late which then requires the whole years forward planning to be changed.



What i'm trying to create is if i put a 1 anywhere in the range A1-AZ52, it will automatically count 6 from that entry and put a 1 in the cell, this will then cascade along the range adding a 1 at every 6th cell going forward in time.

Your thoughts please

Regards

[Pete_UK]

I think the easiest approach is to put this formula in cell G1:

=A1&""

then you can copy this down and across to suit. Enter any value (it could be x) in any cell, and it will be reproduced every 6 cells to the right.

Hope this helps.

Pete