Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do I compare 2 spreadsheets of data? | Excel Worksheet Functions | |||
How do I compare data between spreadsheets? | Excel Worksheet Functions | |||
Compare data on two spreadsheets. | Excel Discussion (Misc queries) | |||
compare data from several spreadsheets | Excel Discussion (Misc queries) | |||
How do I compare data in two different spreadsheets i.e. (column . | Excel Discussion (Misc queries) |