Prev: Calling a sub on another worksheet
Next: date handling problem with International issues
From: skoalnreds on 25 May 2010 20:47
Hi -

Using Excel 2007: I'd like to do this with VBA as doing it with
VLOOKUP( ) would be quite tedious and slow:

I have two worksheets ("May" and "June") with identical layouts,
consisting of 575 columns of data (all formatted as text.) The first
column on both sheets is a unique identifier. What I would like to do
is this:

1. For all rows on "June" that are not on "May" (based on the unique
identifier), I want those entire rows on "June" copied to a new tab in
the workbook called "New".

2. For all unique identifiers on "June" that do exist on "May":
compare the values in each column (all 574 remaining columns after the
unique identifier). If ALL column values are exactly the same, copy
that entire row to a new tab called "No Changes". Otherwise, on a
new tab called "Changes", put the unique identifier in Column A, the
name of each column with an unequal value (from Row 1 of "June") in
Column B, the "May" value in Column C and the "June" value in column
D. Each change should appear in a separate row.

Any ideas on how to accomplish this? Thank you very much...
 | 
Pages: 1
Prev: Calling a sub on another worksheet
Next: date handling problem with International issues