therock003
Board Regular
- Joined
- Jan 9, 2008
- Messages
- 183
I have made an excel workbook that is intended to be used as a lightweight CRM solution. I'll be brief with my setup and what i want
I got one tab functioning as an inventory table, where each row describes the inventory item's properties and then i got a second tab for a phonebook for suppliers.
The Second tab has a pretty basic structury with 3 columns. Name, Phone Type and Phone Number.
e.g
John The Supplier, Work Number, 555-555
Supplier Eric, Home Number, 555-556
Supplier Eric, Mobile Phone, 656-555
And i have consrquently created a pivot table so each name expands and collapses to reveal multiple numbers (in case ive stored work and mobile etc)
My request is that when i'm on the inventory table on the first tab, i need from there to be able to grab-redirect dont know to the number cell of the supplier.
So for example lets say inventory table entry is
pencil, red, available, Supplier Eric
I need to reach Supplier Erics contact information from the Pivotable on my Second Excel Tab in order to make a phone call.
I know you guys are going to say everything would be easier if you'd just use a database management system, but i mean cmon its a lightweight file, of 200 entries at best
I got one tab functioning as an inventory table, where each row describes the inventory item's properties and then i got a second tab for a phonebook for suppliers.
The Second tab has a pretty basic structury with 3 columns. Name, Phone Type and Phone Number.
e.g
John The Supplier, Work Number, 555-555
Supplier Eric, Home Number, 555-556
Supplier Eric, Mobile Phone, 656-555
And i have consrquently created a pivot table so each name expands and collapses to reveal multiple numbers (in case ive stored work and mobile etc)
My request is that when i'm on the inventory table on the first tab, i need from there to be able to grab-redirect dont know to the number cell of the supplier.
So for example lets say inventory table entry is
pencil, red, available, Supplier Eric
I need to reach Supplier Erics contact information from the Pivotable on my Second Excel Tab in order to make a phone call.
I know you guys are going to say everything would be easier if you'd just use a database management system, but i mean cmon its a lightweight file, of 200 entries at best