Comparing Excell Spreadsheets
 

Hi all,

Have a question I was wondering if someone could help me with. The
basic setup is I have two different spreadsheets.

The data is organized by columns. For example it the first column has
"Account Number" then below it has the listing of numbers.

Second is "Location" then below it a list of locations, etc.

The next spreadsheet is organized in a similar fashion. The problem is
the second spreadsheet has added columns with information I need on
the first spreadsheet but only on the accounts that are there.

The accounts on that second spreadsheet that don't appear on the first
I can ignore completely as I'm not adding them to the first one.

Whew, hope that makes sense.

What I was wondering is if there was a way to run a macro or put it in
Access or something (preferrablly through excel) to compare the two
sheets and only copy over the columns that are missing to the first
sheet for those specific accounts.

It doesnt matter where it puts the columns they can be at the end or
whatever.

Thanks for any help. I've looked up some similar things here, and
tried to modify a few of the macro's I saw, but none of them quite did
what I needed.

Thanks again!

Comparing Excell Spreadsheets
 

If you don't have a lot of data, you could color the second spreadsheet text
in red, copy the text to the first spreadsheet, sort it, and do a visual
compare.

Carole O

" wrote:

Hi all,

Have a question I was wondering if someone could help me with. The
basic setup is I have two different spreadsheets.

The data is organized by columns. For example it the first column has
"Account Number" then below it has the listing of numbers.

Second is "Location" then below it a list of locations, etc.

The next spreadsheet is organized in a similar fashion. The problem is
the second spreadsheet has added columns with information I need on
the first spreadsheet but only on the accounts that are there.

The accounts on that second spreadsheet that don't appear on the first
I can ignore completely as I'm not adding them to the first one.

Whew, hope that makes sense.

What I was wondering is if there was a way to run a macro or put it in
Access or something (preferrablly through excel) to compare the two
sheets and only copy over the columns that are missing to the first
sheet for those specific accounts.

It doesnt matter where it puts the columns they can be at the end or
whatever.

Thanks for any help. I've looked up some similar things here, and
tried to modify a few of the macro's I saw, but none of them quite did
what I needed.

Thanks again!