| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
comparing two separate spreadsheets
I am using excel 2003
I have two separate spreadsheet tables that has mostly the same data though there is some different data. Is there a way that i can sort the data onto one spreadsheet using similar indentifiers and separate the data that is not in the other table? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
comparing two separate spreadsheets
If they are large tables, or if this is something you must do repeatedly, you
might be interested in Jim Cone's fine commercial Add-in called XLCompanion. It's available at: http://www.realezsites.com/bus/primitivesoftware/ Vaya con Dios, Chuck, CABGx3 "KLock" wrote: I am using excel 2003 I have two separate spreadsheet tables that has mostly the same data though there is some different data. Is there a way that i can sort the data onto one spreadsheet using similar indentifiers and separate the data that is not in the other table? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
comparing two separate spreadsheets
is there a way to combine and/or sort the data without having to download. i
can't download anything on my computer. "CLR" wrote: If they are large tables, or if this is something you must do repeatedly, you might be interested in Jim Cone's fine commercial Add-in called XLCompanion. It's available at: http://www.realezsites.com/bus/primitivesoftware/ Vaya con Dios, Chuck, CABGx3 "KLock" wrote: I am using excel 2003 I have two separate spreadsheet tables that has mostly the same data though there is some different data. Is there a way that i can sort the data onto one spreadsheet using similar indentifiers and separate the data that is not in the other table? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
comparing two separate spreadsheets
We need a description of the data..........sheet names, cell ranges on each, and which is dominant sheet......... Vaya con Dios, Chuck, CABGx3 "KLock" wrote: is there a way to combine and/or sort the data without having to download. i can't download anything on my computer. "CLR" wrote: If they are large tables, or if this is something you must do repeatedly, you might be interested in Jim Cone's fine commercial Add-in called XLCompanion. It's available at: http://www.realezsites.com/bus/primitivesoftware/ Vaya con Dios, Chuck, CABGx3 "KLock" wrote: I am using excel 2003 I have two separate spreadsheet tables that has mostly the same data though there is some different data. Is there a way that i can sort the data onto one spreadsheet using similar indentifiers and separate the data that is not in the other table? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| comparing two spreadsheets | Excel Discussion (Misc queries) | |||
| Comparing two columns in two separate files | New Users to Excel | |||
| Comparing Two Spreadsheets | Excel Discussion (Misc queries) | |||
| need help comparing data in 2 separate worksheets | Excel Worksheet Functions | |||
| Comparing Spreadsheets | Excel Worksheet Functions | |||
Hybrid Mode
