I
igbert
I have 2 Sheet; Sheet 1 and Sheet 2.
In Sheet 1, I have in Colum A for year, B for Type and so on. Under each
column I have the data.
Sheet1
A B C D
Year Type. Part No. Price
2007 033-02 1234-000 76,205
2007 570-05 4567-000 45,118
2008 033-02 1234-000 52,358
2008 570-05 4567-000 45,183
How could I populate the data from Sheet 1 to Sheet 2 into different areas
by typing the year only?
i.e.
In Sheet 2, when I type 2007 in A1, type 2008 in H1
I want all data for each year populate under the corresponding columns.
A B C H
I J
Type 2007 2008
Show 033-02 1234-000 76,205 033-02 1234-000 52,358
Show 570-05 4567-000 45,118 570-05 4567-000 45,183
Thanks
Igbert
In Sheet 1, I have in Colum A for year, B for Type and so on. Under each
column I have the data.
Sheet1
A B C D
Year Type. Part No. Price
2007 033-02 1234-000 76,205
2007 570-05 4567-000 45,118
2008 033-02 1234-000 52,358
2008 570-05 4567-000 45,183
How could I populate the data from Sheet 1 to Sheet 2 into different areas
by typing the year only?
i.e.
In Sheet 2, when I type 2007 in A1, type 2008 in H1
I want all data for each year populate under the corresponding columns.
A B C H
I J
Type 2007 2008
Show 033-02 1234-000 76,205 033-02 1234-000 52,358
Show 570-05 4567-000 45,118 570-05 4567-000 45,183
Thanks
Igbert