Populate Data Into Different Areas
Hi Luke,
The areas I want the data to populate in Sheet 2 form part of the worksheet
with data already populated in many other cells. I could not use a pivot
table in this case.
Igbert
"Luke M" wrote:
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
|