Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Excel database
I have an existing contact database in an excel file with information such as
names, addresses, phone numbers, etc; organized in rows. In addition, there is a column that identifies them by category. I would like to create additional tabs within the worksheet that organize the contacts by these categories. I would also like to be able to add the contact info to the main database sheet and have it automatically rollout to the appropriate category sheets. any advice??? -- Tony Kantor |
#2
|
|||
|
|||
Could you go into 'view' and add a 'custom view'? you could then copy and
paste that particular view to save or just print it. The print option has all I have opted for at this point. I have been able to create individual 'views' which will show just the information I needed for 'hard copy' purposes. "tonykantor" <(do not wrote in message ... I have an existing contact database in an excel file with information such as names, addresses, phone numbers, etc; organized in rows. In addition, there is a column that identifies them by category. I would like to create additional tabs within the worksheet that organize the contacts by these categories. I would also like to be able to add the contact info to the main database sheet and have it automatically rollout to the appropriate category sheets. any advice??? -- Tony Kantor |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
SQL Server UPDATE Database from Excel Table | Links and Linking in Excel | |||
Excel Database | Excel Discussion (Misc queries) | |||
Excel as a database | Excel Discussion (Misc queries) | |||
Keeping date format of a field inserted from an excel database | Excel Worksheet Functions | |||
Query a Access database that has a module from Excel | Excel Discussion (Misc queries) |