New Posts For Thread: Excel Questionhttps://community.betfair.com/general_betting/go/thread/view/94082/23535474/excel-questionIm rearranging a spreadsheet.Is there a way to find out which cells rely on another cell?What I'd like to do is click on a cell, and have all other cells that use it highlighted. An alternative would be a "move" command that allows me to cut/paste aOk, this would be a good time for me to start using macros. I've never done it before but always known I would need to in the end so I'll look closer on Monday (when the sport dies down a bit) and go through it stage by stage with google.Thanks againhttps://community.betfair.com/general_betting/go/thread/view/94082/23535474/excel-question?post_id=420928042#420928042Ok, this would be a good time for me to start using macros. I've never done it before but always known I would need to in the end so I'll look closer on Monday (when the sport dies down a bit) and go through it stage by stage with google.Thanks againSat, 27 Mar 2010 08:11:01 -0500Lori maybe this is what you want a simple macro. This one does Precedents to doDependents substitute Precedents in line 5 to Dependents.This, when run will put all cells referenced by selected cell in column 10 starting atrow 1 ($J$1)Sub PrecedentCelhttps://community.betfair.com/general_betting/go/thread/view/94082/23535474/excel-question?post_id=420928030#420928030Lori maybe this is what you want a simple macro. This one does Precedents to doDependents substitute Precedents in line 5 to Dependents.This, when run will put all cells referenced by selected cell in column 10 starting atrow 1 ($J$1)Sub PrecedentCelSat, 27 Mar 2010 07:29:22 -0500Hadn't spotted that either CM, although it's not what I need for this one, I'm going to have good fun with that I can tell :) Cheers.https://community.betfair.com/general_betting/go/thread/view/94082/23535474/excel-question?post_id=420928026#420928026Hadn't spotted that either CM, although it's not what I need for this one, I'm going to have good fun with that I can tell :) Cheers.Sat, 27 Mar 2010 07:16:50 -0500Lori not sure if you have realized ~Trace dependents when clicked once shows arrows to direct dependentswhen clicked more than once shows dependents on the dependentsClick till it beeps and will show all dependencies.Same with precedents.cheershttps://community.betfair.com/general_betting/go/thread/view/94082/23535474/excel-question?post_id=420927998#420927998Lori not sure if you have realized ~Trace dependents when clicked once shows arrows to direct dependentswhen clicked more than once shows dependents on the dependentsClick till it beeps and will show all dependencies.Same with precedents.cheersFri, 26 Mar 2010 19:50:18 -0500maybe coney could write a rap about them :)https://community.betfair.com/general_betting/go/thread/view/94082/23535474/excel-question?post_id=420927978#420927978maybe coney could write a rap about them :)Fri, 26 Mar 2010 14:09:38 -0500The trace dependents function thing is actually so amazing I may have to get Danny Morrison to describe it for me. All the methods in this thread helped me a lot , but the trace arrows are the nuts.https://community.betfair.com/general_betting/go/thread/view/94082/23535474/excel-question?post_id=420927974#420927974The trace dependents function thing is actually so amazing I may have to get Danny Morrison to describe it for me. All the methods in this thread helped me a lot , but the trace arrows are the nuts.Fri, 26 Mar 2010 14:04:54 -0500lori had to go for a smoke after thishttps://community.betfair.com/general_betting/go/thread/view/94082/23535474/excel-question?post_id=420927966#420927966lori had to go for a smoke after thisFri, 26 Mar 2010 14:02:10 -0500That's also awesome too billy.Excuse my apparent hyperbole in this thread, I'm genuinely really happy to have got some decent advice and I've run out of different words to use :)https://community.betfair.com/general_betting/go/thread/view/94082/23535474/excel-question?post_id=420927918#420927918That's also awesome too billy.Excuse my apparent hyperbole in this thread, I'm genuinely really happy to have got some decent advice and I've run out of different words to use :)Fri, 26 Mar 2010 12:35:42 -0500or use the formulas/auditing toolbar and Trace dependents.(depends on version of excel). auditing toolbar might be an add-in in earlier excel versionshttps://community.betfair.com/general_betting/go/thread/view/94082/23535474/excel-question?post_id=420927914#420927914or use the formulas/auditing toolbar and Trace dependents.(depends on version of excel). auditing toolbar might be an add-in in earlier excel versionsFri, 26 Mar 2010 07:40:14 -0500haha, excellent. Sometimes the obvious isn't obvious.That will do just fine, thanks again :)https://community.betfair.com/general_betting/go/thread/view/94082/23535474/excel-question?post_id=420927878#420927878haha, excellent. Sometimes the obvious isn't obvious.That will do just fine, thanks again :)Fri, 26 Mar 2010 06:44:05 -0500