Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula to show entire record on another sheet
I'm planning an event and have an invitation list with several types of
invitations (i.e., complimentary, VIP, regular). This information (Name, address, type of invitation, etc.) is stored on Sheet 1. On Sheet 2, I want a list of just the complimentary invitations. Is there a formula that will automatically add the entire record (name, address, type of invitation, etc.) to Sheet 2 if it is a complimentary invitation? The records will be sorted in several ways during the planning process (in case that makes a difference). I also will add records until the day of the event (which is why I want the formula--to avoid entering the information multiple times). Thanks |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula to show entire record on another sheet
Pivot table is the easiest way to do.
"User" wrote: I'm planning an event and have an invitation list with several types of invitations (i.e., complimentary, VIP, regular). This information (Name, address, type of invitation, etc.) is stored on Sheet 1. On Sheet 2, I want a list of just the complimentary invitations. Is there a formula that will automatically add the entire record (name, address, type of invitation, etc.) to Sheet 2 if it is a complimentary invitation? The records will be sorted in several ways during the planning process (in case that makes a difference). I also will add records until the day of the event (which is why I want the formula--to avoid entering the information multiple times). Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Duplicate sheet, autonumber sheet, record data on another sheet | Excel Worksheet Functions | |||
Formula that will record the time and date when an entry is made on a sheet | Excel Worksheet Functions | |||
importing csv files- entire record goes into each column | Excel Discussion (Misc queries) | |||
Auto-readjust row height to show entire formula results | Excel Discussion (Misc queries) | |||
Always show new record | Excel Discussion (Misc queries) |