| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
how can i merge 2 workbooks using a formula?
Excel 97 - i need to merge 2 fairly large workbooks, however i cannot use
"compare and merge" because my workbooks are not direct copies of each other. There may be a formula to do this, but I'm not sure. Please help!!! |
|
#2
|
|||
|
|||
|
Hi
you need top provide some more information HOW your files look like: - e.g post some sample data - describe the expected result, - etc. -- Regards Frank Kabel Frankfurt, Germany "John F" <John schrieb im Newsbeitrag ... Excel 97 - i need to merge 2 fairly large workbooks, however i cannot use "compare and merge" because my workbooks are not direct copies of each other. There may be a formula to do this, but I'm not sure. Please help!!! |
|
#3
|
|||
|
|||
|
Thank you! I have 2 workbooks that are both about 5000 lines, both
containing roughly the same column headers and information. The first workbook has a few 1000 rows of incorrect data, the second workbook has several columns of incorrect data. Rather than go through both workbooks line by line, is there a way to merge the correct data over the incorrect data from each workbook??? "Frank Kabel" wrote: Hi you need top provide some more information HOW your files look like: - e.g post some sample data - describe the expected result, - etc. -- Regards Frank Kabel Frankfurt, Germany "John F" <John schrieb im Newsbeitrag ... Excel 97 - i need to merge 2 fairly large workbooks, however i cannot use "compare and merge" because my workbooks are not direct copies of each other. There may be a formula to do this, but I'm not sure. Please help!!! |
|
#5
|
|||
|
|||
|
Can I post both worksheets and let you look at them? For that matter, I'm
not sure how to post attachments. Thank you for your continuing help!! "Frank Kabel" wrote: Hi and how do you know which is correct and which is incorrect data? -- Regards Frank Kabel Frankfurt, Germany "John Fazio" <John schrieb im Newsbeitrag ... Thank you! I have 2 workbooks that are both about 5000 lines, both containing roughly the same column headers and information. The first workbook has a few 1000 rows of incorrect data, the second workbook has several columns of incorrect data. Rather than go through both workbooks line by line, is there a way to merge the correct data over the incorrect data from each workbook??? "Frank Kabel" wrote: Hi you need top provide some more information HOW your files look like: - e.g post some sample data - describe the expected result, - etc. -- Regards Frank Kabel Frankfurt, Germany "John F" <John schrieb im Newsbeitrag ... Excel 97 - i need to merge 2 fairly large workbooks, however i cannot use "compare and merge" because my workbooks are not direct copies of each other. There may be a formula to do this, but I'm not sure. Please help!!! |
|
#6
|
|||
|
|||
|
Hi
you can mail me both sheets. DON'T attach a file to the newsgroup directly! -- Regards Frank Kabel Frankfurt, Germany "John Fazio" schrieb im Newsbeitrag ... Can I post both worksheets and let you look at them? For that matter, I'm not sure how to post attachments. Thank you for your continuing help!! "Frank Kabel" wrote: Hi and how do you know which is correct and which is incorrect data? -- Regards Frank Kabel Frankfurt, Germany "John Fazio" <John schrieb im Newsbeitrag ... Thank you! I have 2 workbooks that are both about 5000 lines, both containing roughly the same column headers and information. The first workbook has a few 1000 rows of incorrect data, the second workbook has several columns of incorrect data. Rather than go through both workbooks line by line, is there a way to merge the correct data over the incorrect data from each workbook??? "Frank Kabel" wrote: Hi you need top provide some more information HOW your files look like: - e.g post some sample data - describe the expected result, - etc. -- Regards Frank Kabel Frankfurt, Germany "John F" <John schrieb im Newsbeitrag ... Excel 97 - i need to merge 2 fairly large workbooks, however i cannot use "compare and merge" because my workbooks are not direct copies of each other. There may be a formula to do this, but I'm not sure. Please help!!! |
|
#7
|
|||
|
|||
|
Thanks for the heads up -- emailing to you now.
"Frank Kabel" wrote: Hi you can mail me both sheets. DON'T attach a file to the newsgroup directly! -- Regards Frank Kabel Frankfurt, Germany "John Fazio" schrieb im Newsbeitrag ... Can I post both worksheets and let you look at them? For that matter, I'm not sure how to post attachments. Thank you for your continuing help!! "Frank Kabel" wrote: Hi and how do you know which is correct and which is incorrect data? -- Regards Frank Kabel Frankfurt, Germany "John Fazio" <John schrieb im Newsbeitrag ... Thank you! I have 2 workbooks that are both about 5000 lines, both containing roughly the same column headers and information. The first workbook has a few 1000 rows of incorrect data, the second workbook has several columns of incorrect data. Rather than go through both workbooks line by line, is there a way to merge the correct data over the incorrect data from each workbook??? "Frank Kabel" wrote: Hi you need top provide some more information HOW your files look like: - e.g post some sample data - describe the expected result, - etc. -- Regards Frank Kabel Frankfurt, Germany "John F" <John schrieb im Newsbeitrag ... Excel 97 - i need to merge 2 fairly large workbooks, however i cannot use "compare and merge" because my workbooks are not direct copies of each other. There may be a formula to do this, but I'm not sure. Please help!!! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| revert formula insertion to old method | Setting up and Configuration of Excel | |||
| Workbooks...I'll try this again... | Excel Discussion (Misc queries) | |||
| compare and merge workbooks | Excel Worksheet Functions | |||
| Cell doesn't show formula result - it shows formula (CTRL + ' doe. | Excel Worksheet Functions | |||
| can I merge two different workbooks, with the same format, just d. | Excel Worksheet Functions | |||
Linear Mode
