| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Display data in series
I have a sheet containing data as following:
Date Code Product Transaction on Qty 21/2 12 Ink Purchase 20/2 30 28/2 11 Ballpen Sales 27/2 25 2/3 12 Ink Sales 1/3 20 5/3 11 Ballpen Return 4/3 12 6/3 11 Ballpen Sales 5/3 9 13/3 12 Ink Sales 11/3 10 I then wish to have a result in other sheet as following : When the code 12 is entered : Code : 12 Product: Ink 21/2 Purchase 20/2 30 2/3 Sales 1/3 20 13/3 Sales 11/3 10 when the code 11 is entered, the results relating to Ballpen is listed. How to set ? I wish to have the table list in the other sheet and not using filter in the same data sheet. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Display data in series
Use AutoFilter to display only those rows with a given code. Then copy the
visible ros to another sheet. -- Gary''s Student - gsnu200841 "yclhk" wrote: I have a sheet containing data as following: Date Code Product Transaction on Qty 21/2 12 Ink Purchase 20/2 30 28/2 11 Ballpen Sales 27/2 25 2/3 12 Ink Sales 1/3 20 5/3 11 Ballpen Return 4/3 12 6/3 11 Ballpen Sales 5/3 9 13/3 12 Ink Sales 11/3 10 I then wish to have a result in other sheet as following : When the code 12 is entered : Code : 12 Product: Ink 21/2 Purchase 20/2 30 2/3 Sales 1/3 20 13/3 Sales 11/3 10 when the code 11 is entered, the results relating to Ballpen is listed. How to set ? I wish to have the table list in the other sheet and not using filter in the same data sheet. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Display data in series
But, I wish to set a page that everyone can have the listing by simply
entering the product code. "Gary''s Student" wrote: Use AutoFilter to display only those rows with a given code. Then copy the visible ros to another sheet. -- Gary''s Student - gsnu200841 "yclhk" wrote: I have a sheet containing data as following: Date Code Product Transaction on Qty 21/2 12 Ink Purchase 20/2 30 28/2 11 Ballpen Sales 27/2 25 2/3 12 Ink Sales 1/3 20 5/3 11 Ballpen Return 4/3 12 6/3 11 Ballpen Sales 5/3 9 13/3 12 Ink Sales 11/3 10 I then wish to have a result in other sheet as following : When the code 12 is entered : Code : 12 Product: Ink 21/2 Purchase 20/2 30 2/3 Sales 1/3 20 13/3 Sales 11/3 10 when the code 11 is entered, the results relating to Ballpen is listed. How to set ? I wish to have the table list in the other sheet and not using filter in the same data sheet. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Display data in series
In that case, check the technique described he
http://office.microsoft.com/en-us/ex...260381033.aspx -- Gary''s Student - gsnu200841 "yclhk" wrote: But, I wish to set a page that everyone can have the listing by simply entering the product code. "Gary''s Student" wrote: Use AutoFilter to display only those rows with a given code. Then copy the visible ros to another sheet. -- Gary''s Student - gsnu200841 "yclhk" wrote: I have a sheet containing data as following: Date Code Product Transaction on Qty 21/2 12 Ink Purchase 20/2 30 28/2 11 Ballpen Sales 27/2 25 2/3 12 Ink Sales 1/3 20 5/3 11 Ballpen Return 4/3 12 6/3 11 Ballpen Sales 5/3 9 13/3 12 Ink Sales 11/3 10 I then wish to have a result in other sheet as following : When the code 12 is entered : Code : 12 Product: Ink 21/2 Purchase 20/2 30 2/3 Sales 1/3 20 13/3 Sales 11/3 10 when the code 11 is entered, the results relating to Ballpen is listed. How to set ? I wish to have the table list in the other sheet and not using filter in the same data sheet. |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Display data in series
Thanks for your help, it works. However, while I fill the formula in the
column of cells for 6 rows, it works with the cells having values but the empty cells return with "#NUM!" like the followings : Code : 12 Product: Ink 21/2 Purchase 20/2 30 2/3 Sales 1/3 20 13/3 Sales 11/3 10 #NUM! #NUM! #NUM! #NUM! #NUM! #NUM! #NUM! #NUM! #NUM! #NUM! #NUM! #NUM! #NUM! #NUM! #NUM! #NUM! How to fix it ?, Thanks again, "Gary''s Student" wrote: In that case, check the technique described he http://office.microsoft.com/en-us/ex...260381033.aspx -- Gary''s Student - gsnu200841 "yclhk" wrote: But, I wish to set a page that everyone can have the listing by simply entering the product code. "Gary''s Student" wrote: Use AutoFilter to display only those rows with a given code. Then copy the visible ros to another sheet. -- Gary''s Student - gsnu200841 "yclhk" wrote: I have a sheet containing data as following: Date Code Product Transaction on Qty 21/2 12 Ink Purchase 20/2 30 28/2 11 Ballpen Sales 27/2 25 2/3 12 Ink Sales 1/3 20 5/3 11 Ballpen Return 4/3 12 6/3 11 Ballpen Sales 5/3 9 13/3 12 Ink Sales 11/3 10 I then wish to have a result in other sheet as following : When the code 12 is entered : Code : 12 Product: Ink 21/2 Purchase 20/2 30 2/3 Sales 1/3 20 13/3 Sales 11/3 10 when the code 11 is entered, the results relating to Ballpen is listed. How to set ? I wish to have the table list in the other sheet and not using filter in the same data sheet. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do I display 2 data series with different starting dates | Charts and Charting in Excel | |||
| Graph with 2 X axis - data series display limit? | Charts and Charting in Excel | |||
| How do I display the sum of 2 data series on a column chart? | Charts and Charting in Excel | |||
| prevent display of data series dropping to graph x axis for null d | Charts and Charting in Excel | |||
| chart data series -- plot a table as a single series | Charts and Charting in Excel | |||
Linear Mode
