+ Reply to Thread
Results 1 to 3 of 3

Find text Copy Paste to new tab

  1. #1
    Forum Contributor
    Join Date
    04-23-2007
    Location
    Texas
    Posts
    417

    Find text Copy Paste to new tab

    I am wanting to find all the rows with matching text "Already exists" and move it to next blank cell in sheet2 column A. I'm trying to do this with this code, but I'm not getting the pastespecial correct.

    Please Login or Register  to view this content.
    Last edited by Tortus; 01-05-2016 at 02:11 PM. Reason: Found a fix
    If we all use our Minds our Heads and our Brains NO TELLING what we could come up with!!

  2. #2
    Forum Expert
    Join Date
    08-28-2014
    Location
    Texas, USA
    MS-Off Ver
    2016
    Posts
    1,796

    Re: Find Copy Paste

    Haven't tried using your code, but you do see you're misspelling paste?

    xlpatesall
    Please Login or Register  to view this content.
    I'm interested in starting a career working with VBA, if anyone knows of any opportunities!

  3. #3
    Forum Contributor
    Join Date
    04-23-2007
    Location
    Texas
    Posts
    417

    Re: Find Copy Paste

    I was able to get this to work. Here is the code.

    Please Login or Register  to view this content.

+ 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. Vba - find next empty column, insert column, copy paste values & copy paste formulas
    By DoodlesMama in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-20-2012, 12:43 PM
  2. [SOLVED] Macro to Find, copy, paste, find, copy, paste, find, copy, paste, u get the picture....
    By westsoldman in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 11-12-2012, 01:12 AM
  3. [SOLVED] VB find, copy and paste
    By Andysmith1983 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 10-26-2012, 11:41 AM
  4. VBA: How to Find, Copy & Paste
    By Tara2205 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-13-2012, 02:58 AM
  5. Copy\Find\Copy\Paste Multiple Workbooks
    By JMcClane in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-05-2010, 10:23 AM
  6. code to find, copy and paste until find new, then repeat
    By siddharthariver in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-12-2010, 04:02 PM
  7. Find, Copy, and Paste
    By NSTurk725 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-21-2009, 01:47 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