Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Compare and Merge command grayed out.
I have two nonshared workbooks that need to be merged Wk bk 3 into wb 1 after
comparing Here's content from them: Workbook 1 FIRM_NO FLEET_NO UNIT_NO Renewed PLATE_NO AXLES VEH_MAKE 7206 1 526311C Y P00438585 2 FRTL 7206 1 90478A Y P00417552 3 INTH 7206 1 525777A Y P00467280 5 WHGM Workbook 2 FIRM_NO FLEET_NO UNIT_NO PLATE_NO VEH_MAKE 7206 1 739 P00023374 KW 7206 1 756 P00022115 KEN 7206 1 2545 P00023385 INTL |
#2
|
|||
|
|||
In order to use the Compare and Merge Workbooks feature see Excel Help: "Make
sure the copies of the shared workbook that you want to merge are all stored in the same folder. To do this, you must give each copy a different name." Although it's name suggests otherwise, the feature is not used to simply combine the content of two separate & distinct workbook files. One must start as a copy (Save As) of a file designated as Shared even if nobody else uses it. Hope this is useful |:) "Roberta" wrote: I have two nonshared workbooks that need to be merged Wk bk 3 into wb 1 after comparing Here's content from them: Workbook 1 FIRM_NO FLEET_NO UNIT_NO Renewed PLATE_NO AXLES VEH_MAKE 7206 1 526311C Y P00438585 2 FRTL 7206 1 90478A Y P00417552 3 INTH 7206 1 525777A Y P00467280 5 WHGM Workbook 2 FIRM_NO FLEET_NO UNIT_NO PLATE_NO VEH_MAKE 7206 1 739 P00023374 KW 7206 1 756 P00022115 KEN 7206 1 2545 P00023385 INTL |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Tools/Compare and Merge Workbooks - Excel 2003 Pro | Excel Worksheet Functions | |||
how can i merge 2 workbooks using a formula? | Excel Worksheet Functions | |||
compare and merge workbooks | Excel Worksheet Functions |