Copying cells into one sheet

R

Roxy

Is it possible to copy information from two different
worksheets (same workbook) into one worksheet that have
different column widths? If you do a regular cut & paste
it coverts the table of info to correspond with the
column widths in the destination worksheet. Would one to
an Insert to Object? Thanks!
 
D

Dave Peterson

You might be able to use merge cells to give the look of different column
widths. But merged cells are not always nice to work with.

If you're just looking for a "picture" of the data--not the data itself, you
could select your range and do Edit|Copy.

Then go to that new worksheet and ShiftEdit|Paste Picture Link. (The link means
the picture will change when the data does!)

Do it for each range.

It might be sufficient??????
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top