Results 1 to 13 of 13

Copy a range, but skip 1st and every 6th row, paste value to end of series

Threaded View

  1. 09-17-2015, 06:35 AM #10
    rjnc
    rjnc is offline
    Registered User
    Join Date
    10-11-2012
    Location
    london
    MS-Off Ver
    Excel 2007
    Posts
    45

    Re: Copy a range, but skip 1st and every 6th row, paste value to end of series

    Quote Originally Posted by JOHN H. DAVIS View Post
    I can't view screenshots. Can you provide a sample showing what you're getting, and then one showing what you require.
    No problem, please find the two files attached, one shows the current output based on the code supplied (file - Master File), the second is the ideal output (file - Master File Ideal). As mentioned column A needs to be dynamic (max of column + 1). This was referenced in my original code. Thanks!
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Cut and copy VBA - If range has value cut and paste to another cell - if Null Skip
    By Tom_Watson123 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-28-2015, 11:13 AM
  2. [SOLVED] select & copy some range and past it to another sheet with sum
    By pedjvak in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 08-01-2012, 12:24 AM
  3. [SOLVED] Macro for COPY and PAST RANGE of data to ANOTHER workbook
    By Atoms in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-16-2012, 02:45 AM
  4. [SOLVED] macro to Copy paste range skip zero values
    By Ralem in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 05-25-2012, 04:03 PM
  5. Copy data from a certain range and past multiple times.
    By Butehawk in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 04-30-2010, 09:15 PM
  6. Copy last formula in column and past into range
    By mtbe in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-27-2009, 09:00 PM
  7. hlookup to skip past first found 'lookup_value'
    By Ben Morton in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-23-2008, 08:57 AM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1