Date Update automatically

New Contributor

Hi Want to replace the Date with a new date which is available in the next sheet but the condition is Every name is different each cell if the name is the same then check the date if the date is the same the leave as it or if it is different then update the new date from next sheet.

2 Replies
best response confirmed by amitsrm05452 (New Contributor)


It is possble to use Power Query in Excel.

Merage to sheets by name by all outer

Use if then else to pick up the updated cell.

After merge, you will combine 2 sheet in one.

If in older sheet column A and new sheet column B have the data you need to compare, 

You just need to add a custom column in PQ with fomular below

if [B]=null

then [A]

else if [A]=[B]

then [A]

else [B]


Thank you for your Support I will try And let you know.