copying worksheets

  • Thread starter Thread starter lesthefizz
  • Start date Start date
L

lesthefizz

When I copy a data input form from one worksheet to
another, the cell size doesn't copy as well so I have re
re;format all the cell sizes to get the same formatting.

Been doing this for years, can't believe I haven't asked
for help before.
 
Hi

When you want to copy the whole sheet, then the best way to do this is to
right-click onto sheet's tab, select 'Move or copy...', when you want to
copy into new or another workbook, then make a prior selection in 'To book:'
field, check 'Create a copy' box, and press OK.

When you want to copy a selection, then immediately after pasting data into
new destination select PasteSpecial.Formats (to copy borders, cell/font
colors, font styling etc.), and then PasteSpecial.ColumnWidth. NB! Don't
select any cell meantime - copied data must remain selected until you are
over with it.
 
brilliant, it's easy when you know how isn't it? many
thanks for taking the time to reply.
-----Original Message-----
Hi

When you want to copy the whole sheet, then the best way to do this is to
right-click onto sheet's tab, select 'Move or copy...', when you want to
copy into new or another workbook, then make a prior selection in 'To book:'
field, check 'Create a copy' box, and press OK.

When you want to copy a selection, then immediately after pasting data into
new destination select PasteSpecial.Formats (to copy borders, cell/font
colors, font styling etc.), and then
Click to expand...
PasteSpecial.ColumnWidth. NB! Don't
 
Back
Top