Copying cells into one sheet

  • Thread starter Thread starter Roxy
  • Start date Start date
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!
 
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??????
 
Back
Top