New Posts For Thread: Excel helphttps://community.betfair.com/general_betting/go/thread/view/94082/25420113/excel-helpI'm wanting to set up a macro to auto sort a block of cells.the problem arises because the column i'm wanting to sort from takes it's value from another cellfor instance A152 takes it's value from the following =A2, this returnsI would say that your problem is one of relative reference not absolute reference.If cell A152 takes it value from A2 change the formula =A2 to =$A$2 which is an absolute reference. Change all cells that are in the sorted range that refer to cells ouhttps://community.betfair.com/general_betting/go/thread/view/94082/25420113/excel-help?post_id=458067733#458067733I would say that your problem is one of relative reference not absolute reference.If cell A152 takes it value from A2 change the formula =A2 to =$A$2 which is an absolute reference. Change all cells that are in the sorted range that refer to cells ouTue, 20 Jul 2010 07:15:37 -0500PS: might have misinterpreted your question. Off for another coffee...https://community.betfair.com/general_betting/go/thread/view/94082/25420113/excel-help?post_id=458058957#458058957PS: might have misinterpreted your question. Off for another coffee...Tue, 20 Jul 2010 05:32:11 -0500Once the numbers are sorted, do they remain that way?If yes, then before SORTINGa) COPY THE COLUMNb) KEEP THE COLUMN HILITEDc) PASTE SPECIAL / VALUESd) then SORThttps://community.betfair.com/general_betting/go/thread/view/94082/25420113/excel-help?post_id=458058873#458058873Once the numbers are sorted, do they remain that way?If yes, then before SORTINGa) COPY THE COLUMNb) KEEP THE COLUMN HILITEDc) PASTE SPECIAL / VALUESd) then SORTTue, 20 Jul 2010 05:31:06 -0500I'm wanting to set up a macro to auto sort a block of cells.the problem arises because the column i'm wanting to sort from takes it's value from another cellfor instance A152 takes it's value from the following =A2, this returnshttps://community.betfair.com/general_betting/go/thread/view/94082/25420113/excel-help?post_id=458057573#458057573I'm wanting to set up a macro to auto sort a block of cells.the problem arises because the column i'm wanting to sort from takes it's value from another cellfor instance A152 takes it's value from the following =A2, this returnsTue, 20 Jul 2010 05:11:16 -0500