Hi Ashutosh,
Absolute refrencing won't help you here.
If you have control of the spread-sheet, and you can easily re-structure it,
change the vertical list to a horizontal one.
If you can't do that, select the refrence list, then copy. find an unused pert
of the sheet. Click in a cell, then
davebonall...@hotmail.com
Subject: $$Excel-Macros$$ Re: Help on copying formula.
To: excel-macros@googlegroups.com excel-macros@googlegroups.com
Date: Thursday, 2 July, 2009, 12:13 PM
#yiv711815090 .hmmessage P
{
margin:0px;padding:0px;}
#yiv711815090 {
font-size:10pt;font-family:Verdana;}
Hi
: sanjaysoni2...@yahoo.co.in
Subject: $$Excel-Macros$$ Re: Help on copying formula.
To: ca.ashut...@gmail.com
CC: excel-macros@googlegroups.com
Dear Ashutosh,
I understood you problem it can be solved by making the coloum fixed by dollar
sign and then copy that formula.
For eg :- =A1 fix the coloum
Dear Dave,
Thanx its working nicely.
Best Regards,
Sanjay
--- On Thu, 2/7/09, Dave Bonallack davebonall...@hotmail.com wrote:
From: Dave Bonallack davebonall...@hotmail.com
Subject: $$Excel-Macros$$ Re: Help on copying formula.
To: excel-macros@googlegroups.com excel-macros
Hello,
You can use formula =transpose()
Good to see help, because you use other steps. Don’t forget use F2 and
ctr+shift+enter :)
I hope it can be what you want.
.
On Jul 2, 6:16 am, ASHUTOSH AGARWAL ca.ashut...@gmail.com wrote:
Hi All,
Genrally in spreadheet, if you copy a formule in other
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.comwrote:
Hi All,
Genrally in spreadheet, if you copy a
Hi,
You can use =$A1 and drag it across columns
Cheers
Prashanth
On Thu, Jul 2, 2009 at 9:46 AM, ASHUTOSH AGARWAL ca.ashut...@gmail.comwrote:
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
Hi Ashutosh,
Use the same formula as =$A1 instead of =A1.
U will get the desire results.
Rgds,
Mahender Bisht
On Thu, Jul 2, 2009 at 9:46 AM, ASHUTOSH AGARWAL ca.ashut...@gmail.comwrote:
Hi All,
Genrally in spreadheet, if you copy a formule in other rows, formula is
changed according to
