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...

There are commercial alternatives.
--
Jim Cone
Portland, Oregon USA
( http://tinyurl.com/XLCompanion )





"skoalnreds" <(E-Mail Removed)>
wrote in message news:7322da1d-63e7-4e37-a810-(E-Mail Removed)...
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...

On May 26, 6:13*am, "Jim Cone" <james.cone...@comcast.netXXX> wrote:
> There are commercial alternatives.
> --
> Jim Cone
> Portland, Oregon *USA
> (http://tinyurl.com/XLCompanion)
>
> "skoalnreds" <skoalnr...@gmail.com>
> wrote in messagenews:7322da1d-63e7-4e37-a810-(E-Mail Removed)...
> 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...

Wow, I never thought of that. Thanks!