ExcelBanter - Updating with current date

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Updating with current date (https://www.excelbanter.com/excel-discussion-misc-queries/177952-updating-current-date.html)

Gloria Lewis

Updating with current date

I have two lists of data, a Master List and a daily list. I would like to
update a column called "Received date" in the Master List with the current
date if a match is found on the daily list.

These are the column names on the daily list (Program_nbr, Item_nbr) and for
the master list (Program_nbr, Item_nbr, Received_date). Thanks. Using Excel
2003.

All times are GMT +1. The time now is 08:51 PM.