i have a master sheet "master" that shows the latest info from other
worksheets. In my "insurance info" worksheet i have Jan~Dec, all exactly the
same. If i update one of the months i want all other info to update in the
master.i.e. date, policy#, company etc. I have used the MAX to find the most
recent date in Jan~Dec but i can't get the associated data the populate
because the latest date could be anywhere in Jan~Dec columns.