Copy Worksheet 2 into Worksheet 1??

[Ken F]

I have created an Excel workbook document with many worksheets.......I would
like to have the entire contents of worksheet 2 added to the bottom of
worksheet 1............if I copy or cut the contents of Worksheet 2 and
paste it onto the bottom of worksheet 1, the pasted data falls into the cell
formats that are defined on worksheet 1............Is there some way I can
either embed or link something to something else to get this done, or, is a
feature available to create a "breakoff point" in the worksheet that allows
anything below it to have its own cell formatting separately from the first
part of the worksheet?

Mucho TIA

Ken

 

[Trevor Shuttleworth]

Ken

I'm not sure how you achieve that result. If you select and copy the data
from one sheet, then select the target sheet, position the cursor at the
next available cell, and paste the data it will all be copied across
including text, formulae, formatting and so on. However, column widths will
remain as per the original sheet formatting. Is that the problem ?

Regards

Trevor

 

[Ken F]

Yes.........that is my problem

Any ideas?

Ken

I'm not sure how you achieve that result. If you select and copy the data
from one sheet, then select the target sheet, position the cursor at the
next available cell, and paste the data it will all be copied across
including text, formulae, formatting and so on. However, column widths will
remain as per the original sheet formatting. Is that the problem ?

Regards

Trevor


is

 

[Trevor Shuttleworth]

Ken

only to select all the cells ... the originals plus the newly transferred
data and then select Format | Columns | Autofit Selection. Column width is
for the entire column so you can't have one width at the top and another at
the bottom.

Regards

Trevor

 

[Ken F]

Thanks Trevor...........apreciate your info...

Doesnt achieve my goal though.....isn't there some way to simply place a new
workbook in an existing worksheet? I could simply make my worksheet 2 a
workbook, then somehow insert it into worksheet 1?

 

[Ket.Kana]

Ken,

You could try the following: Highlight and copy the cells on Sheet 2.
Click onto sheet 1. Press and hold the shift key and click on the edit
menu. You should have an option to paste picture as link.
This will allow the contents of sheet 2 to appear in sheet 1 as a linked
picture. If data changes on sheet 2 it will be reflected in sheet 1.

Not an ideal solution but maybe a workaround.

Ket

 

[Ken F]

Thanks Ket..............................your right....it's not ideal, but now I can overlay worksheet 2 so it aligns over cells of worksheet 1..........I will then simply do a data validation on the cells, and the user will be able to tab right into the box and it will appear as though the data is correctly placed.....................next is to see how it prints !

Thanks for the help.

Ken,

You could try the following: Highlight and copy the cells on Sheet 2. Click onto sheet 1. Press and hold the shift key and click on the edit menu. You should have an option to paste picture as link.
This will allow the contents of sheet 2 to appear in sheet 1 as a linked picture. If data changes on sheet 2 it will be reflected in sheet 1.

Not an ideal solution but maybe a workaround.

Ket

 

[Guest]

yes! thanks for this input. I wanted to tell you that I've spent 3 hours yesterday to use insert object (which displays the first worksheets used range on the hosting sheet...), but had a few problems... so great, this is exactly what I was looking for. What a strange thing to click on a menu while shifting the keyboard...!