Forum Discussion
Enter a value-Have it populate cells in same row to the right-skipping 2 columns after every 5
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?
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!
