Hi all, There is another way to do this using the INDIRECT function. Have a look at the attached sheet. Select B2, then copy across. Column A will appear in Row 1 You may have to change the formula slightly to suit your data. Regards - Dave.
Date: Thu, 2 Jul 2009 12:24:24 +0530
From: 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 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
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
Yahoo! recommends that you upgrade to the new and safer Internet
Explorer 8
_________________________________________________________________
Looking for a new car this winter? Let us help with car news, reviews and more
http://a.ninemsn.com.au/b.aspx?URL=http%3A%2F%2Fsecure%2Dau%2Eimrworldwide%2Ecom%2Fcgi%2Dbin%2Fa%2Fci%5F450304%2Fet%5F2%2Fcg%5F801459%2Fpi%5F1004813%2Fai%5F859641&_t=762955845&_r=tig_OCT07&_m=EXT
--~--~---------~--~----~------------~-------~--~----~
-------------------------------------------------------------------------------------
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
-------------------------------------------------------------------------------------
-~----------~----~----~----~------~----~------~--~---
Indirect.xls
Description: MS-Excel spreadsheet
