Forum Discussion
How to update (copy and paste) similar groupings of columns across one spreadsheet?
Hello All! I have this sheet that we are using to record data on a daily basis. Within the data entry tab of the worksheet is 52 formulaically identical groupings of columns for each week. While...
Wouldn't it be simpler to have just ONE set of columns and then to insert a column as the first one that contains the weeknumber (repeating on all rows for each week)? If you need to just look at week 1, you filter the table on that column.
JKPieterse Yes, that would be simpler. This is a sheet that I was given by my management that they have used for years, so I want to avoid changing it as much as possible. If I can't end up finding a solution, I'll probably do what you recommend. But I ideally won't change this spreadsheet in any way.
- Well, one thing which will make this easier is to stop using merged cells.
JKPieterse Yeah... the merged cells are a pain to work with... But again, I'd like to avoid changing the formatting of this sheet in any way. The guys that use this on a daily basis are already comfortable using this sheet and my copy and paste problem doesn't warrant changing their daily process.
