If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
compare worksheets in same workbook
is it possible to compare 2 or more worksheets in the same workbook or do you
have to copy the worksheets to other workbooks in order to compare them? |
#2
|
|||
|
|||
Hi
do you want to compare the complete worksheets or only a specific column? -- Regards Frank Kabel Frankfurt, Germany Peter Manak wrote: is it possible to compare 2 or more worksheets in the same workbook or do you have to copy the worksheets to other workbooks in order to compare them? |
#3
|
|||
|
|||
I am comparing about 10 to 15 columns - the rest are all blank.
What is the difference? In Excel, when you have 2 Excel files open you can select window and then arrange. The 2 Excel files are lined up. To compare 2 workshhets in the same file, you can copy the original to another file then compare the two worksheets (now in different files) using the arrange function in the window tab. However, they have to be in different files to compare them that way. You can't compare them in the same file because you can only open one worksheet at a time in an Excel file. I answered my own question, didn't I. They really do have to be in separate files to compare them. But you can copy or move a worksheet from one Excel file to another. It would be the same if you just copy the entire file and delete worksheets you don't need. Or uou can copy worksheet from several filews into one file. "Frank Kabel" wrote: Hi do you want to compare the complete worksheets or only a specific column? -- Regards Frank Kabel Frankfurt, Germany Peter Manak wrote: is it possible to compare 2 or more worksheets in the same workbook or do you have to copy the worksheets to other workbooks in order to compare them? |
#4
|
|||
|
|||
Peter -
The sheets being compared side by side can be in the same workbook. Choose New Window from the Window menu. This will open a second window just like the first. One is names Book.xls:1, the other Book.xls:2. Now you can switch one window the the other sheet, compare sheets, then close one window (use the X in the top right corner, because File-Close will close all windows for the active workbook). This is also the answer to a FAQ: "Why do my windows have :1 and :2 after the file name?" - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ Peter Manak wrote: I am comparing about 10 to 15 columns - the rest are all blank. What is the difference? In Excel, when you have 2 Excel files open you can select window and then arrange. The 2 Excel files are lined up. To compare 2 workshhets in the same file, you can copy the original to another file then compare the two worksheets (now in different files) using the arrange function in the window tab. However, they have to be in different files to compare them that way. You can't compare them in the same file because you can only open one worksheet at a time in an Excel file. I answered my own question, didn't I. They really do have to be in separate files to compare them. But you can copy or move a worksheet from one Excel file to another. It would be the same if you just copy the entire file and delete worksheets you don't need. Or uou can copy worksheet from several filews into one file. "Frank Kabel" wrote: Hi do you want to compare the complete worksheets or only a specific column? -- Regards Frank Kabel Frankfurt, Germany Peter Manak wrote: is it possible to compare 2 or more worksheets in the same workbook or do you have to copy the worksheets to other workbooks in order to compare them? |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
converting lot of microsoft worksheets to separate workbook | n.venkatasubramanian | General Discussion | 1 | July 28th, 2004 04:31 PM |
compare to array in another workbook and record results | Carole | Worksheet Functions | 8 | March 30th, 2004 08:31 PM |
Copy a column into many worksheets in a workbook. | Lisa | Worksheet Functions | 1 | December 9th, 2003 08:13 PM |