Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
What is the best way to organize a data in order to PRINT specific
My workbook has a lot of different information in text and numbers.
Ex : A1 to A 50 are last names B1 to B 50 are first names C1 to c 50 colors D1 to D 50 fruits. Going on from A to M down to 50 in every worksheet (30). They repeat a lot and I want to be able to do this : Pick an item in a cell ( ex. grape, in fruit column) and PRINT all the ROWS with grapes on it in one page( including first and last name, colors... for that row). Can this be done with pivot table? I'm not much related to it. If there is no other function or formula , then my last choice will be a MACRO if somebody has one. Thanks. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Need organize numbered order | New Users to Excel | |||
How do I organize Excel rows in alpha order? | Excel Discussion (Misc queries) | |||
print files & subfiles fo we can organize them | Excel Worksheet Functions | |||
How do I organize entries in order by date each rqst was rcvd? | New Users to Excel | |||
How do I rank chart data so it appears in a specific order? | Charts and Charting in Excel |