Forum Discussion
Date Update automatically
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.
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]
2 Replies
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.
