Updating existing data from new worksheet by replacing only corresponding values

pvkvimalan

New Member
Joined
Dec 19, 2017
Messages
14
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
 

Some videos you may like

Excel Facts

Format cells as currency
Select range and press Ctrl+Shift+4 to format cells as currency. (Shift 4 is the $ sign).

Watch MrExcel Video

Forum statistics

Threads
1,114,119
Messages
5,546,042
Members
410,722
Latest member
Jojo3008
Top