Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sorting macro on dynamic column of different sheets
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(W110,(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!! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Dynamic Column in Pivot Table Macro | Excel Programming | |||
Macro code to autosum a dynamic length column | Excel Discussion (Misc queries) | |||
Dynamic column insert (macro) | Excel Discussion (Misc queries) | |||
dynamic sort macro across 3 linked sheets | Excel Discussion (Misc queries) | |||
Linking sheets when sorting row and column data | Excel Worksheet Functions |