I would need to see the workbook. Without seeing how the data is laid out, I
can't help you.

"Foxwave" wrote in message
...
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.