M
missy.cissell
Hi!
Any help is much appreciated!!
I have a form that has a sales column that populates by an indirect
formula that pulls data from different worksheets based on dynamic
info (if A=0, then this worksheet, etc). I have then setup a macro to
sort on this column-when i setup 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.
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)
First checking that there is a sales plan
sumif, dynamically pulling the sheetname and column to pull from.
Any ideas on what Im doing wrong?
thanks soo much in advance-Ive given myself a headache!
Any help is much appreciated!!
I have a form that has a sales column that populates by an indirect
formula that pulls data from different worksheets based on dynamic
info (if A=0, then this worksheet, etc). I have then setup a macro to
sort on this column-when i setup 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.
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)
First checking that there is a sales plan
sumif, dynamically pulling the sheetname and column to pull from.
Any ideas on what Im doing wrong?
thanks soo much in advance-Ive given myself a headache!