Results 1 to 3 of 3

Incrementing Rows in Excel

Threaded View

  1. #1
    Registered User
    Join Date
    11-26-2008
    Location
    Canada
    Posts
    2

    Smile Incrementing Rows in Excel

    Needs some help with a formula....

    I currently have a Text Value in a cell....Let's say A1 has a text Value of "Joe"
    In row 201 I want it to equal the value of A1
    So
    A201 = A1
    Now I need to be able to copy a formula to every 3rd line below A201 which would be equal to A2.....

    So you would end up with:
    A201 = A1
    A204 =A2
    I would like to be able to copy a formula down as it is very time consuming....I know I could use VBA to have it equal...the cell..but wondering if there may be something i could add outside of using VBA.....
    Your help is appreciated.
    Last edited by bfancy; 11-26-2008 at 11:14 AM. Reason: need to modify Header

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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