Compare and import data using two spreadsheets
 

My dilemma involves having two spreadsheets of data. One spreadsheet (A) is
formatted while the other is in a more general format (B). I would like
formulas that compare data in B to the formatted data in A. When a match is
found I need to import data from a column with updated pricing in B and
overwrite the pricing that is currently in A. Also, any record that is in B
but not in A should also be imported. It's simple for me to arrange the
columns in the proper order to match A, but it's tedious to copy/paste the
pricing in B to overwrite the A pricing since the rows in B can't be ordered
in a simple manner to match A.

By comparing article numbers it should import the new pricing to the correct
rows, while also adding those article numbers that don't already exist in A.
Formatting is no big deal at that point since it's simple enough to fix all
of that, but I mainly just need the updated data in the right places.

I apologize for being so long-winded. I'm not very proficient in Excel to
say the least though I know what I need to happen. The following are my
column headings in spreadsheet A:

LINE SIZE A B C D PRICE

Any help in this matter will be greatly appreciated.

Compare and import data using two spreadsheets
 

Major,

I think you're going to need a macro to do this. I can probably help you
with that if you're okay with having a macro on your spreadsheet. If you do
want to go this route I need a little more info as to what exactly has to
match. I'm assuming that when you say "import" you mean copy from (B) into
(A).

On the other hand, maybe someone else will come up with a more clever
solution. Let me know.

"Major7th" wrote:

My dilemma involves having two spreadsheets of data. One spreadsheet (A) is
formatted while the other is in a more general format (B). I would like
formulas that compare data in B to the formatted data in A. When a match is
found I need to import data from a column with updated pricing in B and
overwrite the pricing that is currently in A. Also, any record that is in B
but not in A should also be imported. It's simple for me to arrange the
columns in the proper order to match A, but it's tedious to copy/paste the
pricing in B to overwrite the A pricing since the rows in B can't be ordered
in a simple manner to match A.

By comparing article numbers it should import the new pricing to the correct
rows, while also adding those article numbers that don't already exist in A.
Formatting is no big deal at that point since it's simple enough to fix all
of that, but I mainly just need the updated data in the right places.

I apologize for being so long-winded. I'm not very proficient in Excel to
say the least though I know what I need to happen. The following are my
column headings in spreadsheet A:

LINE SIZE A B C D PRICE

Any help in this matter will be greatly appreciated.