Results 1 to 6 of 6

Copy all rows down to row containing text and copy onto last row of next sheet.

Threaded View

leahb909 Copy all rows down to row... 09-21-2018, 09:38 AM
Mumps1 Re: Copy all rows down to row... 09-21-2018, 10:40 AM
leahb909 Re: Copy all rows down to row... 09-21-2018, 10:44 AM
Mumps1 Re: Copy all rows down to row... 09-21-2018, 10:56 AM
leahb909 Re: Copy all rows down to row... 09-21-2018, 11:12 AM
Mumps1 Re: Copy all rows down to row... 09-21-2018, 12:13 PM
  1. 09-21-2018, 09:38 AM #1
    leahb909 is offline
    Registered User
    Join Date
    09-06-2018
    Location
    England
    MS-Off Ver
    Office 365
    Posts
    24

    Copy all rows down to row containing text and copy onto last row of next sheet.

    Hi

    I'm looking for a way to highlight all the rows down to (including the title row) the row that contains "Overall Total:" in column B, but only highlight columns A:W, as opposed to the entire row.

    I then want to be able to copy these rows and paste them onto the bottom row of sheet 2.

    The sample attached is simplified, the true data will have many rows AFTER the overall total column that I don't want to copy.

    I'd appreciate any help. Thank you in advance.
    Attached Files Attached Files
    Last edited by leahb909; 09-21-2018 at 09:42 AM.
    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. How to copy rows in one sheet if it contains text which is present on another sheet column
    By satskutty in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 02-06-2018, 02:36 AM
  2. [SOLVED] Macro to filter sheet 1 - 10 with a unique text value and copy all the rows in sheet 11
    By Shayk in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 09-18-2017, 07:13 PM
  3. [SOLVED] Copy rows to another sheet base on text in cells
    By Winston in forum Excel - New Users/Basics
    Replies: 7
    Last Post: 05-22-2016, 05:17 PM
  4. [SOLVED] Copy rows to another sheet depending on text color
    By JorisDDS in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-20-2013, 05:05 AM
  5. [SOLVED] Copy rows in sheet if certain cell contains text
    By CallumS in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 11-14-2013, 05:34 AM
  6. [SOLVED] Macro to Copy rows to a new sheet that contain certain text
    By megdawom in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-11-2012, 02:11 PM
  7. [SOLVED] copy rows that contain certain text to a new sheet including the h
    By mike in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 12-05-2005, 10:35 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1