Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I need to do something relatively simple, and quickly--
I have two workbooks open. Both with similar sets of values - part numbers and prices, but in different columns. What I want to do is have Excel take those columns in each workbook, and the associated price next to them, and paste them into a new workbook or worksheet with the difference in price beside those columns. They are not in the same listed order in each original worksheet. Example: Workbook 1: Workbook 2: PART1 $50 PART365: $50.99 PART3 $30 PART053: $123.30 New workbook (generated by Excel?) PARTSfromW1 Price PartsfromW2 Price DIFFERENCE PART1 $45.95 PART1 $65.02 -$19.07 Can anyone help me with this? Thanks, Gabe |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do I compare similar data in two separate workbooks? | Excel Discussion (Misc queries) | |||
How do I compare similar data in two separate workbooks? | Excel Discussion (Misc queries) | |||
Generating Footers for Multiple sheets in Workbook | Excel Programming | |||
Import/Copy some data from one workbook to a similar workbook | Excel Programming | |||
Security - Protecting Macro while generating workbook thru VB 6.0 | Excel Programming |