Hi All, Thanks a lot for the help....
Ashutosh ---------- Forwarded message ---------- From: Petr Hořejš <p.hor...@linkabezpeci.cz> Date: 2009/7/2 Subject: $$Excel-Macros$$ Re: Help on copying formula..... To: MS EXCEL AND VBA MACROS <excel-macros@googlegroups.com> 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 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 -- CA Ashutosh K. Agarwal Mobile:+919810882074 --~--~---------~--~----~------------~-------~--~----~ ---------------------------------------------------------------------------------- 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 <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 5,000 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~----------~----~----~----~------~----~------~--~---
