Results 1 to 7 of 7

CRTL+D macro (very large amount of rows needed)

Threaded View

  1. #1
    Registered User
    Join Date
    09-24-2009
    Location
    Adelaide, Australia
    MS-Off Ver
    Excel 2003
    Posts
    9

    CRTL+D macro (very large amount of rows needed)

    Hello guys,

    See the attached excel file,

    I've done the first 200 or so rows by hand, (well when I say by hand, I really mean by CTRL+D). Anyways, I need to generate the same recursive forumlas for 230400 rows!!!

    - I have formulas in the cell columns A,B,C,D & E (look from row 18 downwards)
    - Can ignore last two columns, as I will be importing data from a separate file

    so i'll need something like this for the remaining rows:

    for cell rows 201 to 230400;
       for cell columns A to E;
          do formula calculation; 
             next column
       next row
    n.b. Each column (A to E) has different formulas,

    Thanks in advance!
    Attached Files Attached Files

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