+ Reply to Thread
Results 1 to 8 of 8

VBA copy and paste row based on value, looped

  1. #1
    Registered User
    Join Date
    07-30-2014
    Location
    London
    MS-Off Ver
    2010
    Posts
    4

    VBA copy and paste row based on value, looped

    Hi,

    Apologies, new to VBA, I have spent nearly the entire day pulling my hair out because of this coding.

    I am trying to code so that it will look for "ERROR" in the whole workbook, in all sheets this is located in column G, then copy the rows where it is found into a worksheet titled.. 'ERROR'. Ignoring all rows where the text isn't found.



    I had some moderate sucess writing an incredibly long formula, but I am sure there must be some VBA.

    Man

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

    Re: VBA copy and paste row based on value, looped

    JBeresford,
    Welcome to the forum!
    Please attach a sample. Please remove all confidential info from the sample.

  3. #3
    Registered User
    Join Date
    07-30-2014
    Location
    London
    MS-Off Ver
    2010
    Posts
    4

    Re: VBA copy and paste row based on value, looped

    Hi,

    Many thanks, hopefully attached?

    Jack
    Attached Files Attached Files

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

    Re: VBA copy and paste row based on value, looped

    Hi Jack,
    Try the attached.
    Attached Files Attached Files

  5. #5
    Registered User
    Join Date
    07-30-2014
    Location
    London
    MS-Off Ver
    2010
    Posts
    4

    Re: VBA copy and paste row based on value, looped

    Hi,

    Can't see an attachment?

    Many thanks for your help!

    Jack

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

    Re: VBA copy and paste row based on value, looped

    Please try it now.

  7. #7
    Registered User
    Join Date
    07-30-2014
    Location
    London
    MS-Off Ver
    2010
    Posts
    4

    Re: VBA copy and paste row based on value, looped

    Thank you so much!

  8. #8
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2403 Win 11 Home 64 Bit
    Posts
    23,811

    Re: VBA copy and paste row based on value, looped

    Try this:

    Please Login or Register  to view this content.
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

+ 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: 0
    Last Post: 10-29-2013, 09:38 AM
  2. Copy and Paste Rows based on Criteria onto another sheet and sort based on oldest item
    By Kushal8684 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-25-2013, 05:37 AM
  3. Need VBA to copy data from looped sheets into summary sheet
    By The Drone in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 06-09-2012, 09:49 PM
  4. Copy and paste based on a column
    By Mahitha in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 02-13-2011, 04:17 PM
  5. Copy row based on date and then paste into a new worksheet based on section number
    By calmlaunch in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-25-2011, 11:40 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1