Hey Ashothosh,
Please make use of absolute cell reference.
http://www.techonthenet.com/excel/questions/referencing.php
Regards,
Rajesh Kunder
On Thu, Jul 2, 2009 at 9:46 AM, ASHUTOSH AGARWAL <ca.ashut...@gmail.com>wrote:
> Hi All,
>
> Genrally in spreadheet, if you copy a formule in other rows, formula is
> changed according to row number. e.g. we have a cell with formula ""=A1" and
> now we copy this formula across columns to the right. Naturally, this
> results in the Formula reference changing to =B1, =C1, =D1 etc.
>
> However, this is not the result I want. I want that if I copy this formula
> across columns to the right, it should show as =A2, =A3, =A4 and so on.
>
> Can anyone help in this.
> Many Thanks,
> Ashutosh
> >
>
--~--~---------~--~----~------------~-------~--~----~
-------------------------------------------------------------------------------------
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com
-------------------------------------------------------------------------------------
-~----------~----~----~----~------~----~------~--~---
