Closed Thread
Results 1 to 2 of 2

newbie: Copying a formula that repeats every 10 cells

  1. #1
    Registered User
    Join Date
    07-02-2013
    Location
    swansea, wales
    MS-Off Ver
    Excel 2002
    Posts
    2

    Red face newbie: Copying a formula that repeats every 10 cells

    Sorry - I've gone braindead trying to resolve thsi - so forgive me if I dont express myself very well ..
    I have a formula that repeats every 10 cells, that I want to copy into the next 1000 cells, but I dont want the cell reference to increase by 10 each time I copy the block, I want it to increase by 1 - Not Clear ? let me demonstrate :-

    cell a1 contains the formula ' =(Sheet3!$a1) '
    cell a2 contains the formula ' =(Sheet3!$b1) '
    cell a3 contains the formula ' =(Sheet3!$c1) ' and so on down to
    cell a10 contains the formula ' =(Sheet3!$j1)

    I want to copy these 10 cells and paste into the next 1000+ cells,
    What I get is
    cell a11 contains the formula ' =(Sheet3!$a11) '
    cell a12 contains the formula ' =(Sheet3!$b11) ' and so on.

    What I want is
    cell a11 contains the formula ' =(Sheet3!$a2) '
    cell a12 contains the formula ' =(Sheet3!$b2) ' and so on down to
    cell a20 contains the formula ' =(Sheet3!$j2) ' and then

    cell a21 contains the formula ' =(Sheet3!$a3) '
    cell a22 contains the formula ' =(Sheet3!$b3) ' and so on down to
    cell a30 contains the formula ' =(Sheet3!$j3) ' and so on until I get to about cell a1000

    How do I do That ?
    Its probably easy - but Ive gone simple trying to figure it out.

  2. #2
    Forum Moderator vlady's Avatar
    Join Date
    09-22-2011
    Location
    Philippines - OLSHCO -Guimba-Nueva Ecija
    MS-Off Ver
    2021
    Posts
    4,361

    Re: newbie: Copying a formula that repeats every 10 cells

    Dupl.

    Thread Closed.
    I think people forget the word "THANK YOU!!!!" Do you still know it???

    There is a little star ( ADD REPUTATION ) below those person who helped you. Click it to say your "PRIVATE APPRECIATION TO THEIR EFFORT ON THEIR CONTRIBUTIONS "

    Regards,
    Vladimir

Closed Thread

Thread Information

Users Browsing this Thread

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

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