+ Reply to Thread
Results 1 to 5 of 5

VBA - Cut rows with cells that contain values, then cut and paste to a new sheet

  1. #1
    Forum Contributor
    Join Date
    04-03-2014
    Location
    Berlin
    MS-Off Ver
    Excel 2010
    Posts
    160

    VBA - Cut rows with cells that contain values, then cut and paste to a new sheet

    Hey everybody,

    I am trying to put together a code that should look up the sintagm "Schwellwert" in column F - sheet "Input" and whenever this is thr case, the whole row containing it should be cut and pasted to the sheet "Assign" (pls see the attachment).
    Finally, the resulting empty rows in sheet "Input" should be deleted.

    Your Support is highly appreciated, thanks!
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    03-28-2012
    Location
    TBA
    MS-Off Ver
    Office 365
    Posts
    12,454

    Re: VBA - Cut rows with cells that contain values, then cut and paste to a new sheet

    Try the attached.
    Attached Files Attached Files

  3. #3
    Forum Guru
    Join Date
    07-25-2011
    Location
    Florida
    MS-Off Ver
    Excel 2003
    Posts
    9,643

    Re: VBA - Cut rows with cells that contain values, then cut and paste to a new sheet

    Please Login or Register  to view this content.
    Surround your VBA code with CODE tags e.g.;
    [CODE]your VBA code here[/CODE]
    The # button in the forum editor will apply CODE tags around your selected text.

  4. #4
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,482

    Re: VBA - Cut rows with cells that contain values, then cut and paste to a new sheet

    You can filter for the text then work from there.

    Please Login or Register  to view this content.

  5. #5
    Forum Contributor
    Join Date
    04-03-2014
    Location
    Berlin
    MS-Off Ver
    Excel 2010
    Posts
    160

    Re: VBA - Cut rows with cells that contain values, then cut and paste to a new sheet

    Wow, all three solutions work perfectly!
    Thanks a lot!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 2
    Last Post: 03-18-2015, 05:31 AM
  2. Copy diff cells of a sheet & paste in a NEW row below previously filld rows of other sheet
    By shubhashishdubey in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-27-2014, 12:36 AM
  3. Copy Paste the Missing Values in a Specified Cells and Insert the Rows into a Report
    By judeprem in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 06-30-2013, 01:46 PM
  4. Replies: 1
    Last Post: 04-11-2013, 01:02 PM
  5. [SOLVED] Paste Values from one work sheet to another, but in a row that blank between (rows 5 -105)
    By nenadmail in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-13-2012, 04:23 AM
  6. Scan sheet for unprotected cells and paste values
    By finny388 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-16-2011, 10:49 AM
  7. find values between cells and paste in rows of another sheet
    By manmeet in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-01-2010, 01:57 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