how do I merge two excel sheets from one excel workbook
 

Hi

I have one excel workbook which has two forms created in different sheets.

They have different column and row formats.

Is they a way I can make that two forms in different sheets, one form in one
sheet.(I mean one form underneath the other)

Thanks in advance

how do I merge two excel sheets from one excel workbook
 

Not easily if you want different column widths for each part of the one
sheet.

You could take a picture of the second sheet using the Camera Tool and paste
that under the area on the first sheet.

Set all cells under the picture to white background so's the gridlines won't
show through.


Gord Dibben MS Excel MVP

On Wed, 10 Dec 2008 13:06:03 -0800, Ash
wrote:

Hi

I have one excel workbook which has two forms created in different sheets.

They have different column and row formats.

Is they a way I can make that two forms in different sheets, one form in one
sheet.(I mean one form underneath the other)

Thanks in advance

how do I merge two excel sheets from one excel workbook
 

But the camera tool does not work when I select the sheet and press the
camera icon to take a pic.

Please advice

Thanks


"Gord Dibben" wrote:

Not easily if you want different column widths for each part of the one
sheet.

You could take a picture of the second sheet using the Camera Tool and paste
that under the area on the first sheet.

Set all cells under the picture to white background so's the gridlines won't
show through.


Gord Dibben MS Excel MVP

On Wed, 10 Dec 2008 13:06:03 -0800, Ash
wrote:

Hi

I have one excel workbook which has two forms created in different sheets.

They have different column and row formats.

Is they a way I can make that two forms in different sheets, one form in one
sheet.(I mean one form underneath the other)

Thanks in advance

how do I merge two excel sheets from one excel workbook
 

Select the range you want to take a picture of.

Say A1:M32

Click on Camera tool and you will get a + sign appear.

Click anywhere on the sheet and a picture of the selected range will appear.

Copy or Cut that picture......switch to other sheet and EditPaste
SpecialPicture(Enhanced Metafile)

Or just select a range and SHIFT + EditCopy PictureAs shown on
screenFormatPictureOK

EditPaste.........only one choice.......enhanced metafile.


Gord


On Wed, 10 Dec 2008 16:41:01 -0800, Ash
wrote:


But the camera tool does not work when I select the sheet and press the
camera icon to take a pic.

Please advice

Thanks


"Gord Dibben" wrote:

Not easily if you want different column widths for each part of the one
sheet.

You could take a picture of the second sheet using the Camera Tool and paste
that under the area on the first sheet.

Set all cells under the picture to white background so's the gridlines won't
show through.


Gord Dibben MS Excel MVP

On Wed, 10 Dec 2008 13:06:03 -0800, Ash
wrote:

Hi

I have one excel workbook which has two forms created in different sheets.

They have different column and row formats.

Is they a way I can make that two forms in different sheets, one form in one
sheet.(I mean one form underneath the other)

Thanks in advance

how do I merge two excel sheets from one excel workbook
 

I can do that great but won't i be able to fill the form online????

Please advice

"Gord Dibben" wrote:

Select the range you want to take a picture of.

Say A1:M32

Click on Camera tool and you will get a + sign appear.

Click anywhere on the sheet and a picture of the selected range will appear.

Copy or Cut that picture......switch to other sheet and EditPaste
SpecialPicture(Enhanced Metafile)

Or just select a range and SHIFT + EditCopy PictureAs shown on
screenFormatPictureOK

EditPaste.........only one choice.......enhanced metafile.


Gord


On Wed, 10 Dec 2008 16:41:01 -0800, Ash
wrote:


But the camera tool does not work when I select the sheet and press the
camera icon to take a pic.

Please advice

Thanks


"Gord Dibben" wrote:

Not easily if you want different column widths for each part of the one
sheet.

You could take a picture of the second sheet using the Camera Tool and paste
that under the area on the first sheet.

Set all cells under the picture to white background so's the gridlines won't
show through.


Gord Dibben MS Excel MVP

On Wed, 10 Dec 2008 13:06:03 -0800, Ash
wrote:

Hi

I have one excel workbook which has two forms created in different sheets.

They have different column and row formats.

Is they a way I can make that two forms in different sheets, one form in one
sheet.(I mean one form underneath the other)

Thanks in advance

how do I merge two excel sheets from one excel workbook
 

I said it wouldn't be easy<g

Column widths and row heights are properties of the entire column and row.

Having different column widths for top and bottom half of a sheet is not
possible.............that's why I posted the "make a picture" method but
that obviously won't work in your situation.

To have an editable sheet without a picture would require merging cells in
the lower or upper half to get the appearance of differing column widths.

I hesitate to recommend merged cells but is probably your only option.

Merged cells can give rise to a number of problems with sorting, filtering,
copying, pasting and other functions.


Gord


On Wed, 10 Dec 2008 19:19:01 -0800, Ash
wrote:

I can do that great but won't i be able to fill the form online????

Please advice

"Gord Dibben" wrote:

Select the range you want to take a picture of.

Say A1:M32

Click on Camera tool and you will get a + sign appear.

Click anywhere on the sheet and a picture of the selected range will appear.

Copy or Cut that picture......switch to other sheet and EditPaste
SpecialPicture(Enhanced Metafile)

Or just select a range and SHIFT + EditCopy PictureAs shown on
screenFormatPictureOK

EditPaste.........only one choice.......enhanced metafile.


Gord


On Wed, 10 Dec 2008 16:41:01 -0800, Ash
wrote:


But the camera tool does not work when I select the sheet and press the
camera icon to take a pic.

Please advice

Thanks


"Gord Dibben" wrote:

Not easily if you want different column widths for each part of the one
sheet.

You could take a picture of the second sheet using the Camera Tool and paste
that under the area on the first sheet.

Set all cells under the picture to white background so's the gridlines won't
show through.


Gord Dibben MS Excel MVP

On Wed, 10 Dec 2008 13:06:03 -0800, Ash
wrote:

Hi

I have one excel workbook which has two forms created in different sheets.

They have different column and row formats.

Is they a way I can make that two forms in different sheets, one form in one
sheet.(I mean one form underneath the other)

Thanks in advance