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

How to find 2nd largest value in a column?
MAX finds the largest value. =LARGE(A:A,2) will find the second largest. =SMALL(A:A,3) will find the third smallest
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,227
Messages
6,170,853
Members
452,361
Latest member
d3ad3y3

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