Sorting macro on dynamic column of different sheets

M

missy.cissell

Hi!
In my form a column is populated by an indirect
formula that pulls data from different worksheets based on dynamic
info (if A=0, then WorksheetA, if A=1 WorksheetB, etc).
I have then setup a macro to sort on this column.
When i created the macro the indirect pulled from WorksheetA.
However, when the Indirect formula pulls from WorksheetB the data is
displayed properly (formula resulting what i expect), but when i hit
the button to run the macro it still sorts based on WorksheetA.

Is it possible for the macro to understand the sorting based on
different worksheets?

the column that Im sorting on has this formula
=IF(W11>0,(SUMIF(INDIRECT(""&$T$5&""&""&$AY$5&""),$H11,INDIRECT(""&$T
$5&""&""&$AY$4&""))),0)
If something isnt 0,
sumif, dynamically pulling the sheetname and column to pull from.


please help!!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top