RE: $$Excel-Macros$$ Column Reference to change when we move to next row

2013-11-29 Thread Amit Desai (MERU)
ot;), in D2 it should be =if(sheet1!D2>0,"YES","NO"). Regards, Amit Desai From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Ravinder Sent: 28 November 2013 10:55 To: excel-macros@googlegroups.com Cc: Soum Subject: RE: $$Excel-Macros$$ Co

RE: $$Excel-Macros$$ Column Reference to change when we move to next row

2013-11-27 Thread Ravinder
Pfa examples file From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Amit Desai (MERU) Sent: Thursday, November 28, 2013 10:49 AM To: excel-macros@googlegroups.com Subject: RE: $$Excel-Macros$$ Column Reference to change when we move to next row Can

RE: $$Excel-Macros$$ Column Reference to change when we move to next row

2013-11-27 Thread Amit Desai (MERU)
Can someone please help? From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Amit Desai (MERU) Sent: 27 November 2013 16:14 To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Column Reference to change when we move to next row Hi Group, I have a

$$Excel-Macros$$ Column Reference to change when we move to next row

2013-11-27 Thread Amit Desai (MERU)
Hi Group, I have a formula in which I have reference of column "A". when I go down I want to change the formula to refer column "B". is there any way to do this? As of now I need to change the same manully. Regards, Amit Desai - MIS Manager M: +91 9867232534 [cid:image001.jpg@01CEEB8B.B90C5DE0