ok...so the attachment didn't go through. lest see if I can explain in words.

the sheets all have the same headers:
A1 - Property ID
A2 - Construction year
A3 - Mechanical Renovation Date
A4 - Electrical Renovation Date
A5 - Plumbing Renovation Date

The "Import" sheet starting on Row "B" I need to be able to combine the data from "Data1" and "Data2".

Data1:
A B C D E F
Property ID Construction Date Mechanical Electrical Plumbing
2 14265 1956
3 14266 1980 1999
4 14267 1620 1990 1990 1990
5 14269 1890

Data2 is vertually identical but the dates are different:
A B C D E F
Property ID Construction Date Mechanical Electrical Plumbing
2 14265 1950
3 14266 1978 1999 1998 1997
4 14268 1990
5 14270 2000

I need to be able to combine these property ID's while keeping the most recent years in the C:F columns.

Any idea how to do this?? is it a Macro button? is it a sheet filled with formulas??

Thanks for the help.
John

does anyone have any help to offer??

"Ahern79" wrote:

> ok...so the attachment didn't go through. lest see if I can explain in
> words.
>
> the sheets all have the same headers:
> A1 - Property ID
> B1 - Construction year
> C1 - Mechanical Renovation Date
> D1 - Electrical Renovation Date
> E1 - Plumbing Renovation Date
>
> The "Import" sheet starting on Row "2" I need to be able to combine the
> data from "Data1" and "Data2".
>
> Data1:
> A B C D
> E
> Property ID Construction Date Mechanical Electrical
> Plumbing
> 2 14265 1956
> 3 14266 1980 1999
> 4 14267 1620 1990
> 1990 1990
> 5 14269 1890
>
> Data2 is vertually identical but the dates are different:
> A B C D
> E
> Property ID Construction Date Mechanical Electrical
> Plumbing
> 2 14265 1950
> 3 14266 1978 1999
> 1998 1997
> 4 14268 1990
> 5 14270 2000
>
> I need to be able to combine these property ID's while keeping the most
> recent years in the B:E columns.
>
> Any idea how to do this?? is it a Macro button? is it a sheet filled with
> formulas??
>
> Thanks for the help.
> John
>

this may allow you to do what you want to do:
http://www.rondebruin.nl/summary.htm


Regards,
Ryan---
--
RyGuy


"ahern79" wrote:

> does anyone have any help to offer??
>
> "Ahern79" wrote:
>
> > ok...so the attachment didn't go through. lest see if I can explain in
> > words.
> >
> > the sheets all have the same headers:
> > A1 - Property ID
> > B1 - Construction year
> > C1 - Mechanical Renovation Date
> > D1 - Electrical Renovation Date
> > E1 - Plumbing Renovation Date
> >
> > The "Import" sheet starting on Row "2" I need to be able to combine the
> > data from "Data1" and "Data2".
> >
> > Data1:
> > A B C D
> > E
> > Property ID Construction Date Mechanical Electrical
> > Plumbing
> > 2 14265 1956
> > 3 14266 1980 1999
> > 4 14267 1620 1990
> > 1990 1990
> > 5 14269 1890
> >
> > Data2 is vertually identical but the dates are different:
> > A B C D
> > E
> > Property ID Construction Date Mechanical Electrical
> > Plumbing
> > 2 14265 1950
> > 3 14266 1978 1999
> > 1998 1997
> > 4 14268 1990
> > 5 14270 2000
> >
> > I need to be able to combine these property ID's while keeping the most
> > recent years in the B:E columns.
> >
> > Any idea how to do this?? is it a Macro button? is it a sheet filled with
> > formulas??
> >
> > Thanks for the help.
> > John
> >