+ Reply to Thread
Results 1 to 7 of 7

Looking for the values in another sheet

  1. #1
    Registered User
    Join Date
    07-09-2013
    Location
    Poland
    MS-Off Ver
    excel 2007
    Posts
    85

    Looking for the values in another sheet

    Hello,
    i have a complicated issue but i will try to explain it clearly.

    In attached workbook in sheet1 there are rows with few of them being the same.
    I want macro to check if value from column A in sheet1 (1,2,3..) exists in sheet 2. If it does then do nothing but if not put the value with the rest of the row to the sheet2(as you can see in attached workbook - i want row with number 4 pasted to sheet2 and so on and so on with a lot of rows). ANd of course i dont want to have duplicated rows in sheet2.

    Thanks
    Attached Files Attached Files
    Last edited by mumsys; 07-20-2013 at 02:46 AM.

  2. #2
    Forum Expert JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492

    Re: Looking for the values in another sheet

    This should do it:

    Please Login or Register  to view this content.
    _________________
    Microsoft MVP 2010 - Excel
    Visit: Jerry Beaucaire's Excel Files & Macros

    If you've been given good help, use the icon below to give reputation feedback, it is appreciated.
    Always put your code between code tags. [CODE] your code here [/CODE]

    ?None of us is as good as all of us? - Ray Kroc
    ?Actually, I *am* a rocket scientist.? - JB (little ones count!)

  3. #3
    Registered User
    Join Date
    07-09-2013
    Location
    Poland
    MS-Off Ver
    excel 2007
    Posts
    85

    Re: Looking for the values in another sheet

    Thank you, works perfectly. Really appreciation for the work!

    One little thing, and if it's too much work don't bother, but if i want to copy the entire row but maybe besides column 2 and 6. Is it complicated?
    Last edited by mumsys; 07-20-2013 at 02:50 AM.

  4. #4
    Forum Expert JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492

    Re: Looking for the values in another sheet

    Uhm, what?

  5. #5
    Registered User
    Join Date
    07-09-2013
    Location
    Poland
    MS-Off Ver
    excel 2007
    Posts
    85

    Re: Looking for the values in another sheet

    hmmm, inside the operation of copying the rows i want to delete a few columns because they are not important.
    With a recorder i deleted two of them but it took really long, so im wondering is there a better way.

  6. #6
    Forum Expert JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492

    Re: Looking for the values in another sheet

    OK, your sample wb didn't show that. So which columns ARE being copied?

  7. #7
    Registered User
    Join Date
    07-09-2013
    Location
    Poland
    MS-Off Ver
    excel 2007
    Posts
    85

    Re: Looking for the values in another sheet

    Column A,B,D,E,F,G,I,J So Column C and H(type 1 and type 6) are NOT being copied.

+ 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. macro to copy values on one sheet based on the values of another sheet.
    By buntalan80 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-25-2013, 09:09 AM
  2. Replies: 4
    Last Post: 06-03-2009, 04:59 PM
  3. Replies: 1
    Last Post: 10-05-2005, 08:05 AM
  4. Replies: 1
    Last Post: 10-05-2005, 08:05 AM
  5. Replies: 1
    Last Post: 10-05-2005, 06:05 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