Thread: How to pull in 2 different rows and compare them
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
yalex[_4_] yalex[_4_] is offline
external usenet poster
  
Posts: 1
Default How to pull in 2 different rows and compare them
What I am trying to do is automatically compare totals in column F fro
two different excel sheets according to their account ID. What I nee
is to be able to pull both row F into the 3rd sheet and have th
account ID match side-by-side along with its corresponding total. Th
reason is because sometimes Sheet 1 has an account that does not exis
in Sheet 2. The look I am trying to accomplish is manually displaye
below:

Account ID 1 Account ID 2
100 100
101 101
102
103 103
104 104

Thanks in advance for any assistance.

yale

--
Message posted from http://www.ExcelForum.com

Reply With QuoteReply With Quote