I have inherited a workbook that reports which in-house tax codes apply to which online orders in our database, and I have discovered a formula is broken. My attached has two tabs - in "Tax Codes to Order #s", the user pastes data in cols. A-C that sorts in the pivot in cols. E-F. Cell B6 of "Order List" copies whichever tax code number is input in cell B3. I then need all orders and invoice amounts to populate in the "Order List" tab from the "Tax Codes" tab if the associated tax code is input into B3.
Currently, the first "Order List" order line (DE6) recognizes if the tax code has an associated order and pulls the first entry. However, below this are offset formulas that are not configured to stop pulling from the "Tax Codes" sheet when the tax code changes (for example, in the attached, the default code setting is 46464 and pulls 9 orders - referencing "Tax Codes", only the first four order rows associate to 46464).
A macro ultimately runs against the "Order List" page and publishes it based on each code number, so the layout of this page (most of which has been removed in the attached) should not be changed (i.e. I can't simply have a pivot that the user can sort on this page instead of formulas).
Any help would be appreciated!
Bookmarks