Enter a value-Have it populate cells in same row to the right-skipping 2 columns after every 5

[hamilton808]

Hi,

I'd like to be able to:

- Enter a value into a cell

- Have that same value populate some cells in the same row to the right

- Not all cells to the right, just every 5 columns to the right, then skip 2 columns, then repeat

Thanks!

[#2]

@hamilton808 

Is there any reason why you can't just put formulas into those cells that would get it? For example, if you're doing your entry in cell A2, then all you'd need to do in the columns where you want the value to repeat would be to enter =A2

You could copy that down for all those columns to as many rows as desired.

If you want to be fancy and have it stay blank until column A has an entry, then enter in those other columns =IF(A2="","",A2)

Now, since this is kind of an odd request, could you satisfy my curiosity and maybe that of a few others by explaining why you are looking to do this?

[#3]

Thanks for your help! 

We'll experiment with that.

The use case is a spreadsheet for scheduling laborers on a job site. The skipping columns is to leave Saturday/Sunday empty.

The number in the cell would represent the number of workers, and the columns filled in would represent the number of days based on the dates we fill in.

Thanks again!

@mathetes