I have made a mistake creating an Excel workbook containing 12 worksheets. I am using a legal copy of Excel 2007.
I have a new Excel workbook to record and analyse weather statistics; temperature, humidity and similar data.
There are 12 worksheets, each one for a single year.
Each worksheet has 12 months, each month consisting of 16 rows and 31 columns per month, with blank cells at the end of rows for months with 28 and 30 days. The error is in one single line in each month.
While doing some back record conversion I have realised that in my master blank worksheet, and consequentially every copy there is an error for February.
A key Cardinal temperature for farmers and growers is the 11 day rolling average temperature. It is easy to create cell formulae to add 11 cell's data then divide by 11 to correct the error. The problem is then how to copy the amended row with 30 or 31 formulae to all the other sheets.
I have realised that when I created the master sheet, I introduced an error in one line of formulae because I used 30 days for February not 28/29. This means that for March to December, in one row for each of the 10 months there is an error.
Is there a way to copy 10 separate rows of amended formulae (1 in March, April etc) in one copy and paste operation to each worksheet? Or do I have to copy the 10 amended rows individually into each of the 12 year's worksheet? ie 120 separate copy and paste operations. So is it 12 copy and pastes or `120?
Thank you for reading