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...
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.
- Hmm. I guess ther might be ways to ease your formula updating process, but for that I'd need more information, preferably a copy of the file. And I'd need to know whether or not the sequence of the weekly columns is identical for all 52 weeks. If so, we could probably write a macro that copies formulas from week 1 to 2...52
JKPieterse It is identical, other than the Week and Date numbers. I've attached the spreadsheet here. Thanks for your help! If you need any other piece of info, let me know.
- So basically you'd copy the column E:N and paste them onto O:X, Y:AH, AI:AR, etcetera?
But what to do with the values entered under the date columns?
Also, wouldn't it be easier to calculate the dates e.g. by adding placing this formula in F2: =E2+1 and then copying this formula to the right?