Hi,

I am fairly new to VBA Programming. For my work i need to compare two
worksheets in same workbook. Worksheet A contains current months data and
work sheet B contains last months data. each month we have certain company's
that does not appear on last months worksheet and this month their products
increases in value and if there is an increase in some company's product
value we get that company's name and all the other info on our current months
worksheet.

What i need to do is:

Worksheet A:
Column is empty, column 2 contains the names of the company, Column three, 4,
5,6,7, conatin some other irrelevant data which i need on the file. Column 8
contains all the product names that have increase in value.

Worksheet B.
is layed out in same format.

I need to compare column 2 (company's name) from current month to last month.
if there is some company's name that appears on this months sheet, but does
not appear on last months sheet, in column 9 under heading "NEW" it should
say "Y" in current months worksheet. but if company appears on both
worksheets irrelevant to what row number they are in it should say "N" in
current months worksheet.

Any kind of VBA Coding help will be greatly appreciated.