Sorting/Filtering Tables Across Sheets

czhang96

New Member
Joined
Sep 15, 2017
Messages
3
I have a workbook with multiple sheets, but am only concerned with the first two; Product Inputs and Outputs. Product Inputs includes information such as item identification numbers, dimensions, weights, etc. Outputs then takes those numbers and calculates profit, overhead, and quantity we want to purchase and also contains references from Product Inputs so the data can be properly analyzed. Many companies that we purchase products from offer a flat discount plus an additional discount on top of it. It is very rare that these two discounts are compounded (a 20% flat discount and a 5% additional discount equals 25% total discount), and instead are factored into the price in two steps (20% of x and 5% of the result). I currently have the flat discount as an absolute reference in a separate sheet, so the problem variable is the additional discount, which is located on the Outputs sheet. I have been experimenting with how to incorporate this additional discount into the final wholesale price of the product, but all of my attempts have the same result. Most of the cells in the Output page are formulas or references (except additional discount), so I can never properly sort/filter the Output page with the additional discount in the proper place. Putting the additional discount on the Input Page was an option, but we often like to play with the discount to evaluate potential negotiation opportunities, so it is much more sensible to have the additional discount on the Output sheet. I realize this is a somewhat complicated problem and may not make sense for those not involved in the business, but any input would be greatly appreciated.
Thanks,
Chris
 

Excel Facts

Bring active cell back into view
Start at A1 and select to A9999 while writing a formula, you can't see A1 anymore. Press Ctrl+Backspace to bring active cell into view.
I think I understand the discount computations, but I don't understand what problem you are trying to solve. Why aren't you able to filter/sort the Product Inputs/Outputs sheet? Are the formulas spatially dependent?
 
Upvote 0

Forum statistics

Threads
1,223,885
Messages
6,175,182
Members
452,615
Latest member
bogeys2birdies

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top