+ Reply to Thread
Results 1 to 2 of 2

Finding unmatching cells and pasting values into another spreadsheet

  1. #1
    Registered User
    Join Date
    10-04-2013
    Location
    London, England
    MS-Off Ver
    Excel 2007
    Posts
    12

    Finding unmatching cells and pasting values into another spreadsheet

    Hi

    I'm quite new to vba and am having some trouble completing a macro. I'm trying to compare two cells to see if both cell values match. If they don't then I want the entire row to be copied into another spreadsheet to be be investigated. The code below keeps returning a error message "Object Variable not defined"

    Formula: copy to clipboard
    Please Login or Register  to view this content.



    If anyone has any suggestions on how to make this better (I am quite new to this!) it would be extremeley appreciated

    Thanks

  2. #2
    Registered User
    Join Date
    10-04-2013
    Location
    London, England
    MS-Off Ver
    Excel 2007
    Posts
    12

    Re: Finding unmatching cells and pasting values into another spreadsheet

    Forgot to mention that the cells which need to be compared are "I5"(Pers) and "J5"(Pos)

+ 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. [SOLVED] Macro for Finding Sheet Names, then Copying/Pasting Values
    By Joel.Nemec in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 07-09-2012, 01:28 PM
  2. Finding values and pasting in a different workbook
    By mmoussa in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-29-2011, 09:23 PM
  3. Finding Dates in Text Files and pasting into spreadsheet
    By undergraduate in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 05-02-2010, 11:21 PM
  4. Replies: 10
    Last Post: 02-09-2010, 05:04 AM
  5. Replies: 6
    Last Post: 11-18-2006, 08:42 PM

Tags for this Thread

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