Is there a way I can enter a name of a product on sheet 1 in a combo box and it will give me the entire history. Sought of like a pivot table but not. It will be a workbook with multiple Monthly Sheets; in these sheets it will contain year of product, if the product was installed and name of account and technician who installed it. - Please see sample-
Last edited by thursday140; 11-18-2014 at 12:10 PM.
Three OPTIONS:
Option(1)
Place all your data on one sheet and then use the sheets filters to view only the records you want to
Option(2)
Utilize VBA code . If you go this route then post your request in the VBA forum.
Option(3)
Pivot table
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks