Index/Match

[snapperRT]

I am currently working on creating a copy of an original worksheet, but I am using index and match formulas to pull the #s instead of a duplicate/copy. The reason that I think I need/want to do this way is so I can have graphs pulled from the figures of the index/match worksheet so they can change when I update the original worksheet (the index/match worksheet will have filters for graphing purposes, the original worksheet cannot have filters). Is this the best way to do this or is there another way that maybe I am not thinking of? Thanks

 

[Deek6t8]

Why don't you just create a query into the original worksheet and load it into the sheet you need it in, That way you can refresh it any time the other worksheet changes. You could do that either within the same workbook or a different one altogether.