Re: $$Excel-Macros$$ Variable Formula Reference

2010-02-20 Thread Deepak Rai
Hi, Another easier way of Cell Referencing is that Place "=" sign then click the source cell in any sheet to set a reference of this source cell. Thanks, On Sat, Feb 20, 2010 at 1:56 PM, Christopher Luka < christopher.l...@gmail.com> wrote: > If I'm not mistaken, what you're looking for is a *f

Re: $$Excel-Macros$$ Variable Formula Reference

2010-02-20 Thread Christopher Luka
If I'm not mistaken, what you're looking for is a *formula* that will dynamically grab the value from Sheet1!A2 for Sheet2, Sheet1!A3 for Sheet3, Sheet1!A4 for Sheet4, etc. If so, then the attached file should work for you. Note that this formula VERY MUCH depends on the fact that the worksheet n

Re: $$Excel-Macros$$ Variable Formula Reference

2010-02-19 Thread ankur
hi u can use $ sign in ur formula like $a$2 or $a2 or a$2 this will help u if not plz attach ur file Have A Nice Time & Enjoy Life Regards: CMA Ankur Pandey (Someone Different) I'm not the best but i'm not like the rest~~ On Thu, Feb 18, 2010 at 1:30 AM, Branden Durst wrote: > Okay, so I am