Previous Topic Next Topic

Updating Existing Worksheet

Closed
dkayeh1 Posts 24 Registration date Monday November 2, 2015 Status Member Last seen December 4, 2015 - Dec 4, 2015 at 03:24 PM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Dec 5, 2015 at 04:09 AM
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.
Related:

1 response

Answer 1 / 1
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Dec 5, 2015 at 04:09 AM
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

Similar discussions

Copying data from one Excel sheet to another.
Remedial -
Kav -

30 responses