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 by "=$A1".
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@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 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 rightclick, Paste Special. in the Paste
Special dialog box, tick the transpose option (near the bottom). you can use
the new list as a reference for the copy-across you want to do.
Hope this helps.
Regards - Dave.
Date: Thu, 2 Jul 2009 09:46:31 +0530
Subject: $$Excel-Macros$$ Help on copying formula.....
From: ca.ashut...@gmail.com
To: excel-macros@googlegroups.com
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
See the Web's breaking stories, chosen by people like you. Check out
Yahoo! Buzz. http://in.buzz.yahoo.com/
--~--~---------~--~----~------------~-------~--~----~
-------------------------------------------------------------------------------------
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
-------------------------------------------------------------------------------------
-~----------~----~----~----~------~----~------~--~---
