Updating Existing Worksheet

Closed
Report
Posts
24
Registration date
Monday November 2, 2015
Status
Member
Last seen
December 4, 2015
-
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
-
Hello, everyone I hope everyone's holiday's are great. I want to thank everyone in advance for their help with this situation I am having in excel.

I have a workbook where I have data from companies listed in the first worksheet, calculations in the second worksheet, and summaries in the third worksheet. I have created a fourth worksheet to add data from the previous year from the companies as it comes in from their inspections. The problem is after all of that year is finally inputted in the worksheet and the updates are completed than I want it to over-ride the first worksheet. Keep into account that all of the data is not being updated just certain areas of the worksheet which is probably about 200 rows out of the 675 rows that are there.

Is there a way to do this without copy & paste that seems tedious. Is there any insight into this dilemma that I have.


Any suggestions are welcome and thank you fro them.

1 reply

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
not knowing or understanding all, one suggestion would be to copy from a template sheet on to the main sheet, so instead of fixing a row at a time, you can reset the whole sheet in one go