|I wish I could attach my spreadsheet....|
There are websites available where files can be stored. You would then post a link so we could download it.
Your answers help, but are also a bit confusing.
On the 6th tab I'm trying to create the drop down menu will be in cell D5 (when selected would filter by Department), E5 (to filter by market) and H5 (to filter by owner).
Are you asking that the data be copied from each sheet based on a single selection (fairly easy) or based on the combination of the 3 items selected by the 3 drop downs? (could be very complicated)
I want the summary/filter tab to pull up only data related to what the user selects from the drop-down menu at the top of the worksheet.
But there are 3 drop downs, aren't there? (this probably relates to my first question)
Formulars are in columns K, M, O, Q, S, U, W and Y in all 4 of the tabs with data. I want to retain these formulas.
When the formulas are copied, will they work in the new location?
For example, if a formula on Sheet2 reads =A1, it will return the value from Sheet2!A1.
If that formula is copied to Sheet6, it's going to return the value from Sheet6!A1.
Is that going to be a problem?
A subtotal row at the bottom would be ideal (though not a game changer)
Subtotaling what? Every column?
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.