Updating existing data from new worksheet by replacing only corresponding values

pvkvimalan

New Member
Joined
Dec 19, 2017
Messages
27
Office Version
  1. 2019
  2. 2016
Platform
  1. Windows
Dear All,


I have a Master sheet where I use to show the overall project progress. I get updates from my Contractors on a weekly basis. Both the sheets are of same formats and fields. The master sheet acts as a repository of all data (Numbers and dates). I want the Contractor sheets to feed the master data by following conditions

1. The Master datasheet already has Numbers and Dates
2. The Update shall add numbers on already existing value (i.e., say I have 3 in a cell, with 2 is the new update, so the data must be 3+2=5)
3. The dates for those updates must be replacing the existing dates ( Say if the previous date was 3-Jul-2020 and the new date is 8-Aug-2020; so he data in Master sheet for that corresponding cell must be the new date i.e., 8-Aug-2020)
4. The changes must affect only for the cells corresponding to the contractor updates while retaining existing data from other cells.

Any help in this will be grateful and appreciated.

Adding the sample file in the link. Sample File Link
 

Excel Facts

What is the last column in Excel?
Excel columns run from A to Z, AA to AZ, AAA to XFD. The last column is XFD.

Forum statistics

Threads
1,223,236
Messages
6,170,915
Members
452,366
Latest member
TePunaBloke

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top