Results 1 to 12 of 12

Macro - Create / Copy / Paste Formula every 5 rows for varying range

Threaded View

  1. #1
    Registered User
    Join Date
    01-13-2004
    Posts
    17

    Macro - Create / Copy / Paste Formula every 5 rows for varying range

    We have a file that exports to excel badly. We have the need to create a formula to copy A6 & B6 to K3 & L3, THEN copy this formula down K & L through the length of data on the current sheet.

    The 2 problems are;

    1. There are 5 blank rows between each formula

    2. There is a varying length of data at each run - we can use column C to indicate length

    Any advice would be greatly appreciated.

    Thanks,

    Jill
    Attached Images Attached Images

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Macro required for copy a range, create a new txt file and paste it
    By gm2612 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 12-28-2013, 07:25 AM
  2. Create a Macro to perform a custom sort on varying number of rows
    By Shirley Munro in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-29-2013, 07:09 PM
  3. Copy and paste list with varying length to specific columns/rows
    By bruizer31 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-05-2013, 08:32 PM
  4. create macro to copy paste many rows at once
    By asaya in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-29-2008, 03:47 PM
  5. [SOLVED] I need formula help or create a macro to copy and paste value only
    By Rebecca in forum Excel General
    Replies: 4
    Last Post: 04-08-2006, 08:25 AM

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