Compare to sheets for data.

[mariamhalday]

Hi Guys ,

Once again I would like to thank you guys for having this forum . Its really a great help to learners like us. Well today I am here with a problem which I will be explaining in details below .

I have workbook with three sheets. Sheet 1,Sheet2 & Sheet3. In sheet1 there are 3 columns with data . Sheet2 also has three columns with data. What I want to achieve here is compare Sheet 2 with sheet 1 ,search each row by row to see if that row data appears in sheet1. If the row does not appear in sheet1 then copy that complete row to sheet 3 .

An help will be very much appreciated . Thanks in advance.

 

[hiker95]

mariamhalday,

1. What version of Excel and Windows are you using?

2. Are you using a PC or a Mac?


Can you post screenshots of the actual raw data worksheets, Sheet1, and, Sheet2?

And, can you post a screenshot of the worksheet results in worksheet Sheet3 (manually formatted by you) for the results that you are looking for?

To post your data, you can download and install one of the following two programs:
1. MrExcel HTMLMaker20101230
https://onedrive.live.com/?cid=8cffdec0ce27e813&sc=documents&id=8CFFDEC0CE27E813!189

Installation instructions here:
http://www.mrexcel.com/forum/board-announcements/515787-forum-posting-guidelines.html#post2545970

2. Excel Jeanie
Download


If you are not able to give us screenshots:
You can upload your workbook to Box Net,
sensitive data changed
mark the workbook for sharing
and provide us with a link to your workbook.