Currently using an excel spread sheet to create a database of parts and their parts numbers, as well as the contact information of who to contact to order the part.
I have a pivet table set up and in column A i have all the parts going down, and then the plus/minus buttons are clicked to reveal the contacts/phone/email to get ahold of it, again this is all in column A via the compact form report layout.
Next i am trying to find a way to insert addition information such as order frequency etc, in column BCDEF. I want them to be attached to the pivot table so that i can easily update and insert information.
If i were to insert the frequencies next to the table but not in it, when opening the plus/minus' in column A this then throws the rest of the document out of wack and isnt aligned correctly.
How would i go about inserting this information in a column connected to the pivot table and its corresponding parts without changing out of the compact view because of printing aspects and clarity.
Solved by F. C. in 12 mins