Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Populate Data Into Different Areas
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Populate Data Into Different Areas
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pulling data from other wb based on data to populate dropdown list | Excel Discussion (Misc queries) | |||
Populate a spreadsheet from a data set | Excel Worksheet Functions | |||
Populate Data In Rows | Excel Discussion (Misc queries) | |||
Merge Excel data into specific form areas in a Word Doc | Excel Discussion (Misc queries) | |||
Defining specific areas for users to enter data | Excel Discussion (Misc queries) |