Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Compiling to one sheet
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Compiling to one sheet
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Compiling to one sheet
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Compiling to one sheet | Excel Worksheet Functions | |||
Compiling | Setting up and Configuration of Excel | |||
Compiling Data | Excel Worksheet Functions | |||
Compiling data | Excel Discussion (Misc queries) | |||
What's the point of compiling? | New Users to Excel |