Go Back   TechArena Community > Software > Windows Software
Become a Member!
Forgot your username/password?
Tags Active Topics RSS Search Mark Forums Read

Reply
 
Thread Tools Search this Thread
  #1  
Old 13-06-2009
Member
 
Join Date: May 2009
Posts: 3
Comparing Columns on different sheets

Good day

I have a macro that I am working on that compares two different sheets. Compare all values in "Boli" to "Port" and vice versa, then post the differences in the "Compare" sheet.

I can get them to compare and post on a different sheet but I want to highlight exactly what is different. I have four columns of information and some times just one column is different. Attached is my wookbook and how I would like the results to look like.

Any help would be greatly appreciated.
Reply With Quote
  #2  
Old 13-06-2009
Member
 
Join Date: May 2009
Posts: 1,611
Re: Comparing Columns on different sheets

You can find the differences between both the worksheets with the help of Vlookup. Anyways, i have enter the function formula in the copy of your workbook and attached it with the results or differences along with this post.On the 'Boli' sheet you will see some "#N/A" on the F column, those are not on the Port sheet, and vice versa.


Just go through this and let me know is this what you were looking for or something else..
Reply With Quote
  #3  
Old 16-06-2009
Member
 
Join Date: Jun 2009
Location: Houston, TX
Posts: 1
Re: Comparing Columns on different sheets

Maq,

What if we wanted to compare all cells to each other on both sheets. Container:Container; Booking:Booking; etc. Is the VLOOKUP function still usable with this or would we have to look at something completely different?

Basically, we want the macro to tell the end-user what is missing or what is incorrect between the two parties(container number off by one digit, container size not matching, etc). That's really the whole point of the macro; to compare differences between the two reports.

Please let me know if you need any other information.

Thanks.
Reply With Quote
  #4  
Old 16-06-2009
Member
 
Join Date: May 2009
Posts: 3
Re: Comparing Columns on different sheets

Actually, what we are needing is that one column on the Boli sheet is compared to its corresponding column on the Port sheet; one at a time. Example Cell A4 on Boli is compared to all values in column A of the Port sheet and so on down the A column on the Boli sheet. Then if that value isn't found, it place that information on the Compare sheet under the corresponding section.

Is this something that can be done?
Reply With Quote
Reply

  TechArena Community > Software > Windows Software
Tags: ,



Thread Tools Search this Thread
Search this Thread:

Advanced Search


Similar Threads for: "Comparing Columns on different sheets"
Thread Thread Starter Forum Replies Last Post
Comparing excel substrings columns Shikamaru Nara Windows Software 4 07-04-2011 10:57 AM
CSS - How to enter style sheets in document? Dexter85 Software Development 4 23-12-2010 06:34 AM
Comparing columns and returning value Esmel Software Development 5 25-08-2010 10:54 PM
CSS (Cascading Style Sheets) Validator Rebella Software Development 2 15-04-2009 10:02 AM
Comparison of 2 sheets in MS Excel Xeusion Windows Software 3 21-08-2008 05:36 PM


All times are GMT +5.5. The time now is 06:13 PM.