Thread: Excel Macro: Matching and calculating 2 worksheets
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
mayanair[_4_] mayanair[_4_] is offline
external usenet poster
  
Posts: 1
Default Excel Macro: Matching and calculating 2 worksheets

Hi there,

I have not touched VB for a looooong time and hope someone could
refresh me on the codings.

I have 2 worksheets in Excel that looks like below:

Sheet 1
A.............B.............C
Name.......ID............Number of Status=Yes
John........1111
Julie........2222
Mary.......3333

Sheet 2
ID.............Status
1111..........Yes
2222..........No
1111..........Yes
3333..........No
1111..........No
2222..........Yes
Reply With QuoteReply With Quote