populating a master worksheet with variables in other worksheets

[Guest]

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.

 

[Dave Thomas]

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

 

[Harlan Grove]

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.

IOW, your master worksheet should pull in data from the latest monthly
worksheet that contains data? Or do you mean if you make an entry in any of
the monthly worksheets in any order, so not necessarily always in the
current or latest month? If the latter, it'd require macros, so I'll assume
the former. I'll also assume your monthly worksheets are named Jan, Feb,
Mar, etc.

If you have a cell (I'll assume it's D5) in each worksheet that contains the
entry date, then the name of the latest worksheet would be given by

=TEXT(MAX(Janec!D5),"mmm")

If you define the name LatestMonth referring to that formula or to a cell
containing that formula, you could access any cell in the latest month's
worksheet using INDIRECT. For example, to get cell X99 for the latest month
use

=INDIRECT("'"&LatestMonth&"'!"&CELL("Address",X99))

This form, using CELL(..) rather than hardcoding allows you to fill or copy
and paste such cells if the layout of the master worksheet is the same (net
of offset) as your monthly worksheets. If not, hardcoding the address in
each formula may work better, e.g.,

=INDIRECT("'"&LatestMonth&"'!X99")

 

[Guest]

Thank you David
how do it get it to you?

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

 

[Dave Thomas]

You e-mail me the workbook as an attachement to (e-mail address removed)

 

[Guest]

i have emailed you the sheet with comments

You e-mail me the workbook as an attachement to (e-mail address removed)