View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Neil M
 
Posts: n/a
Default Copying information and calculations from one sheet to another she

this can be done but there is a road block that I have run into. You need to
make sure that the cells are all the same size. Otherwise you get an error
message saying it cant paste the data.
I usually get the cells all the same height and width first, then simply
copy and paste the data onto the new sheet. You may need to verify that all
or any formulas and/or formatting doesn't get mixed up and reference the
first sheet.
Also, any font sizes or formatting may not transfer.