Results 1 to 4 of 4

Copy range to another sheet starting from where certain text ends

Threaded View

  1. 12-23-2015, 10:18 PM #1
    bgonen
    bgonen is offline
    Registered User
    Join Date
    07-08-2010
    Location
    atlanta
    MS-Off Ver
    Excel 2003
    Posts
    26

    Copy range to another sheet starting from where certain text ends

    in the attached file I am trying to copy a range in the MONITOR file : A6 thru column F to last row

    then copy/paste values this dynamic range to the DATA sheet starting from "K" column one row below the text : ACTUAL is reflected (which on column "J")

    the ACTUAL is also dynamic; sometimes it can end in J30 and a week after ACTUAL can end in J200

    So for example if ACTUAL is on J30 I want to copy the range from MONITOR sheet to be copied to DATA starting at K31
    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. [SOLVED] text box data in a user form copy to a range in sheet 3
    By 9599lorenzo in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-17-2015, 09:22 AM
  2. [SOLVED] How do I copy and paste all the text starting with REF-?
    By Buzz57 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-03-2014, 07:42 PM
  3. [SOLVED] Setting a range that ends where data ends?
    By Mgassma in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-02-2013, 09:46 AM
  4. Copy rows to different sheet starting at a specific row
    By Mumps1 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 06-19-2013, 03:24 PM
  5. [SOLVED] Copy Data to New Sheet, Starting in a Specific Row
    By RTOMikey in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 03-23-2013, 09:35 PM
  6. Macro to search for text then copy data from that row starting in different column
    By balston2 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-09-2013, 10:43 AM
  7. Find Text, Select range below, copy, paste to new work sheet
    By kim5012 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-13-2011, 07:10 PM

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