New Posts For Thread: help needed from Excel expertshttps://community.betfair.com/general_betting/go/thread/view/94082/23524802/help-needed-from-excel-expertsLets say I put the following formula in A3 since I want A3 to read whatever is in A1 (=A1)If then A1 is cut and pasted elsewhere the formula in A3 no longer reads (=A1)Is there anyway to make A3 always read whatever is in A1 regardless if there is aYou probably need to get the macro to delete the cel(s) rather than entire row.https://community.betfair.com/general_betting/go/thread/view/94082/23524802/help-needed-from-excel-experts?post_id=420415970#420415970You probably need to get the macro to delete the cel(s) rather than entire row.Sun, 28 Feb 2010 10:43:04 -0600for spreadsheet integrity, you should never really be deleting rows/columns in excel.https://community.betfair.com/general_betting/go/thread/view/94082/23524802/help-needed-from-excel-experts?post_id=420415966#420415966for spreadsheet integrity, you should never really be deleting rows/columns in excel.Sun, 28 Feb 2010 10:36:03 -0600Rows ("19:19") . ClearContentsInstead of Rows ("19:19") . Delete Shift:=xlUphttps://community.betfair.com/general_betting/go/thread/view/94082/23524802/help-needed-from-excel-experts?post_id=420415962#420415962Rows ("19:19") . ClearContentsInstead of Rows ("19:19") . Delete Shift:=xlUpSun, 28 Feb 2010 10:33:30 -0600Excel is great as you say you can do just about anything with itI don't have excel 2003 so I am not sure where everything is located.Without seeing what you are sorting and on which sheets it is hard to giveanswers. Most of what you do would probablyhttps://community.betfair.com/general_betting/go/thread/view/94082/23524802/help-needed-from-excel-experts?post_id=420415958#420415958Excel is great as you say you can do just about anything with itI don't have excel 2003 so I am not sure where everything is located.Without seeing what you are sorting and on which sheets it is hard to giveanswers. Most of what you do would probablySun, 28 Feb 2010 10:24:29 -0600Unfortunately I am running a macro that helps me delete all rows where the 1st cell has a 0 value. I don't think it is possible to do this by clearing instead of deleting.https://community.betfair.com/general_betting/go/thread/view/94082/23524802/help-needed-from-excel-experts?post_id=420415954#420415954Unfortunately I am running a macro that helps me delete all rows where the 1st cell has a 0 value. I don't think it is possible to do this by clearing instead of deleting.Sun, 28 Feb 2010 10:13:18 -0600EXCEL 2003https://community.betfair.com/general_betting/go/thread/view/94082/23524802/help-needed-from-excel-experts?post_id=420415950#420415950EXCEL 2003Sun, 28 Feb 2010 10:10:36 -0600Are you using excel 2007?https://community.betfair.com/general_betting/go/thread/view/94082/23524802/help-needed-from-excel-experts?post_id=420415946#420415946Are you using excel 2007?Sun, 28 Feb 2010 09:48:41 -0600If you have a blank row after sorting and clearing that row between rows of data justdo another sort to put the blank row to the bottom.https://community.betfair.com/general_betting/go/thread/view/94082/23524802/help-needed-from-excel-experts?post_id=420415938#420415938If you have a blank row after sorting and clearing that row between rows of data justdo another sort to put the blank row to the bottom.Sun, 28 Feb 2010 09:45:04 -0600Instead of deleting a cell or row use clear. That leaves the cells where they areif you delete a cell it moves other cells with the references no longer valid.You can still sort. Did you try ~=OFFSET(Sheet1!A1,9,0,1,1)https://community.betfair.com/general_betting/go/thread/view/94082/23524802/help-needed-from-excel-experts?post_id=420415934#420415934Instead of deleting a cell or row use clear. That leaves the cells where they areif you delete a cell it moves other cells with the references no longer valid.You can still sort. Did you try ~=OFFSET(Sheet1!A1,9,0,1,1)Sun, 28 Feb 2010 09:36:25 -0600Thanks Compound. that worked perfectly until I wanted to delete cells after I had sorted them. After deleting I started getting the REF# result in the cells. Is there anyway around this, so that I can both sort and delete?https://community.betfair.com/general_betting/go/thread/view/94082/23524802/help-needed-from-excel-experts?post_id=420415930#420415930Thanks Compound. that worked perfectly until I wanted to delete cells after I had sorted them. After deleting I started getting the REF# result in the cells. Is there anyway around this, so that I can both sort and delete?Sun, 28 Feb 2010 09:29:10 -0600