Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
combining two worksheets into one
Hi, Is it possible to combine two work sheets into one?
ex: I have first.xls, second.xls firsr.xls has columns aa,bb,cc second.xls has columns aa,bb,cc,dd Both sheets has different data. I want to see them in a single sheet at once side by side and should be able to compare. appreciate your help. Thanks |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
combining two worksheets into one
You say worksheets and then talk about two workbooks. If you copy one set
of columns and paste them next to the other set of columns, does that give you want you want? Is it two worksheets in the same workbook? If not, what are the sheet names in each book and do you want the combined information in a third workbook, an additional sheet in one of the workbooks -- try to be more specific. If you need the data adjusted to match rows, what column has the data to be matched? i.e. what is the unique identifier that you can match on. Will there always be a complete set on each sheet - if not, what is the situation? First is complete, second is partial, first and second overlap, but each may have unique items, etc? -- Regards, Tom Ogilvy "KK" wrote in message ups.com... Hi, Is it possible to combine two work sheets into one? ex: I have first.xls, second.xls firsr.xls has columns aa,bb,cc second.xls has columns aa,bb,cc,dd Both sheets has different data. I want to see them in a single sheet at once side by side and should be able to compare. appreciate your help. Thanks |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
combining two worksheets into one
Tom, I need to view both the worksheets at a time. side by side with
split kind of division between the two worksheets. (Its not comparision). Its a kind of having reference to second work sheets in a first worksheet. hope this is more specific. Thanks. Tom Ogilvy wrote: You say worksheets and then talk about two workbooks. If you copy one set of columns and paste them next to the other set of columns, does that give you want you want? Is it two worksheets in the same workbook? If not, what are the sheet names in each book and do you want the combined information in a third workbook, an additional sheet in one of the workbooks -- try to be more specific. If you need the data adjusted to match rows, what column has the data to be matched? i.e. what is the unique identifier that you can match on. Will there always be a complete set on each sheet - if not, what is the situation? First is complete, second is partial, first and second overlap, but each may have unique items, etc? -- Regards, Tom Ogilvy "KK" wrote in message ups.com... Hi, Is it possible to combine two work sheets into one? ex: I have first.xls, second.xls firsr.xls has columns aa,bb,cc second.xls has columns aa,bb,cc,dd Both sheets has different data. I want to see them in a single sheet at once side by side and should be able to compare. appreciate your help. Thanks |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
combining two worksheets into one
Look at window = Compare side by Side in the menu.
If they are worksheets in the same workbook, before doing that, do Window=New. then in each window make one of the sheets active. Then do Window = Compare side by side -- Regards, Tom Ogilvy "KK" wrote in message oups.com... Tom, I need to view both the worksheets at a time. side by side with split kind of division between the two worksheets. (Its not comparision). Its a kind of having reference to second work sheets in a first worksheet. hope this is more specific. Thanks. Tom Ogilvy wrote: You say worksheets and then talk about two workbooks. If you copy one set of columns and paste them next to the other set of columns, does that give you want you want? Is it two worksheets in the same workbook? If not, what are the sheet names in each book and do you want the combined information in a third workbook, an additional sheet in one of the workbooks -- try to be more specific. If you need the data adjusted to match rows, what column has the data to be matched? i.e. what is the unique identifier that you can match on. Will there always be a complete set on each sheet - if not, what is the situation? First is complete, second is partial, first and second overlap, but each may have unique items, etc? -- Regards, Tom Ogilvy "KK" wrote in message ups.com... Hi, Is it possible to combine two work sheets into one? ex: I have first.xls, second.xls firsr.xls has columns aa,bb,cc second.xls has columns aa,bb,cc,dd Both sheets has different data. I want to see them in a single sheet at once side by side and should be able to compare. appreciate your help. Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Combining worksheets | Excel Discussion (Misc queries) | |||
combining worksheets | Excel Discussion (Misc queries) | |||
combining worksheets | Excel Worksheet Functions | |||
Combining worksheets | New Users to Excel | |||
Combining worksheets | Excel Worksheet Functions |