+ Reply to Thread
Results 1 to 5 of 5

Formula or macro which can

  1. #1
    Registered User
    Join Date
    09-27-2012
    Location
    India
    MS-Off Ver
    Excel 2010
    Posts
    10

    Formula or macro which can

    Hello All,
    I have 10 rows of calculation and its simple first cell A1 which is provided by default From here cell A2 should be multiplied by 2 of A1 and cell A3 by 3 of A1 and A10 to be multiplied by 10 of A1. I wrote a function =A1*2 in cell A2 but problem here is when I click on the cell I see the formula and not the number (which is required for me as I will be copying and pasting this to other sheet) , so what I do is write the formula else where and copy and paste as value. This takes alot of time , is there a simpler solution for example where I can write formula in A2 and Drag the formula all the way down.

    thanks
    Raj

  2. #2
    Forum Expert
    Join Date
    08-02-2013
    Location
    Québec
    MS-Off Ver
    Excel 2003, 2007, 2013
    Posts
    1,411

    Re: Formula or macro which can

    Hi Rajraj,

    Try this formula in A2 and copy down:
    Please Login or Register  to view this content.
    GC Excel

    If this post helps, then click the star icon (*) in the bottom left-hand corner of my post to Add reputation.

  3. #3
    Forum Expert
    Join Date
    03-23-2004
    Location
    London, England
    MS-Off Ver
    Excel 2019
    Posts
    7,040

    Re: Formula or macro which can

    Enter a value in A1

    in A2
    =A$1*ROW()
    copy down the column as far as A10
    Regards
    Special-K

    Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.

  4. #4
    Forum Expert
    Join Date
    09-11-2014
    Location
    Washington, DC
    MS-Off Ver
    2016
    Posts
    1,905

    Re: Formula or macro which can

    In case your data ends up moving elsewhere (other than starting on row 2), another method:

    Please Login or Register  to view this content.
    Copy/drag down to fill.
    Last edited by mcmahobt; 10-09-2015 at 12:42 PM.
    Spread the love, add to the Rep

    "None of us are as smart as all of us."

  5. #5
    Forum Guru Tony Valko's Avatar
    Join Date
    12-31-2011
    Location
    Pittsburgh
    MS-Off Ver
    2002, 2007:2013
    Posts
    18,890

    Re: Formula or macro which can

    Try this...

    Entered in A2 and copied down as needed:

    =A$1*ROWS(A$1:A2)
    Biff
    Microsoft MVP Excel
    Keep It Simple Stupid

    Let's Go Pens. We Want The Cup.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 0
    Last Post: 02-25-2015, 04:16 PM
  2. VBA Macro: Plugging an Array-Formula into a Cell and Dragging Formula Down Columns
    By Brianandstewie in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-20-2013, 02:57 PM
  3. Replies: 1
    Last Post: 01-27-2013, 11:05 AM
  4. Macro: Applying formula to multiple cells in excel (formula editing)
    By city in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 06-27-2012, 06:41 AM
  5. Formula/macro - Apply certain formula as per duplicate cells in column L
    By rain4u in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-10-2011, 12:28 AM
  6. Formula expected end of statement error, typing formula into cell as part of VBA macro
    By DavidGMullins@gmail.com in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-20-2006, 03:05 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1