1. Computer problem? Tech Support Guy is completely free -- paid for by advertisers and donations. Click here to join today! If you're new to Tech Support Guy, we highly recommend that you visit our Guide for New Members.

how to compare two sheets

Discussion in 'Software Development' started by sharadpandey, Jun 22, 2011.

Thread Status:
Not open for further replies.
  1. sharadpandey

    sharadpandey Thread Starter

    Joined:
    Jun 22, 2011
    Messages:
    1
    hi,
    i have a problem in writing macro for comparing two sheets in a workbook in such a way
    if first row of first sheet match with any row of second sheet then copy that row on another sheet and then if second row of first sheet match with any row of second sheet then copy it to third sheet
    this process must continue till all the row compared one by one of first sheet with second sheet
    means i just need to compare 1st row of first sheet with all the rows of second sheet then 2nd row with all then 3hird row and so on
    please help me to slove this problem i have attached the excel file that have two sheets i want to compare rows of sheet 700days with sheet Nifty BB-1 Long 250 days 60min
     
  2. Tiger88

    Tiger88

    Joined:
    Jun 15, 2011
    Messages:
    4
    Please attach the file.
     
As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 733,556 other people just like you!

Thread Status:
Not open for further replies.

Short URL to this thread: https://techguy.org/1003489

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice