An easier way to do this would be to use a PivotTable, I believe. You could
setup the year as a "page field"(or column) and the other headings as row
fields.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"igbert" wrote:

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