working with filters

i apologize, i couldnt come up w/ a more descriptive explanation for the subject line.


im working w/ about 400 lines of excel here. each line belongs to a class within a fund, and each fund belongs to a fund category (corporate, openend, mutual fund etc). each line also has a dollar value and tax percentage. at the bottom there's a total.

now under the main calculations and totals, i'd like a mirror image of all these showing up. instead of the above values though id want to calculate them at a new tax rate and subtract the tax that was allocated to them earlier. so far thats easy enough.

here's where things get complicated - when i filter to show only a certain type of category (eg mutual fund) i want the mirror image below to change as well. but that's not happening. how do i do this?

what i've done so far is at line 450 i said A450 = A2 and dragged it across. this works fine when my filters arent engaged and everything is showing. but of course when i only filter for mutual funds, which starts at row 200, line 450 is still showing corporate funds. can anyone advise?

i just showed this to my boss and she said to use everything on the same line. so i guess this is not really relevant anymore. however id still be curious how to do this so i'll respond back here after work hours thanks!