Hi All,
Thanks a lot for the help
Ashutosh
-- Forwarded message --
From: Petr Hořejš
Date: 2009/7/2
Subject: $$Excel-Macros$$ Re: Help on copying formula.
To: MS EXCEL AND VBA MACROS
Hello,
You can use formula =transpose()
Good to see help, because you use other
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 wrote:
> Hi All,
>
> Genrally in spreadheet, if you copy a formule in other rows, formula is
>
Dear Dave,
Thanx its working nicely.
Best Regards,
Sanjay
--- On Thu, 2/7/09, Dave Bonallack wrote:
From: Dave Bonallack
Subject: $$Excel-Macros$$ Re: Help on copying formula.
To: "excel-macros@googlegroups.com"
Date: Thursday, 2 July, 2009, 5:13 PM
#yi
: 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
ject: $$Excel-Macros$$ Re: Help on copying formula.
To: "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 Ashutosh,
Absolute refrencing won't he
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 r
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 wrote:
> Hi All,
>
> Genrally in spreadheet, if you copy a formule in other rows, formula is
> changed according to row number. e.g. we
Hi,
You can use =$A1 and drag it across columns
Cheers
Prashanth
On Thu, Jul 2, 2009 at 9:46 AM, ASHUTOSH AGARWAL 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
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 wrote:
> Hi All,
>
> Genrally in spreadheet, if you copy a formule in other row
