View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
scott scott is offline
external usenet poster
 
Posts: 577
Default Copying Formatting from one Worksheet to another within different

I have two worksheets within 2 different workbooks that need to have the same
formatting. I tried both using the Format Painter and highlighting the
entire workbook and then painting the format to the entire "other" workbook.
Also I tried doing a copy worksheet and sent it to the other workbook and
tried overwriting the data. Still to no avail.

I have also tried manually setting the column widths manually on the 2nd
worksheet to match the widths of the 1st workbook. I set column "a" to 11.33
however it changes it to 11.38. I have no idea why it is changing, and would
greatly appreciate some guidance.

Thank you in advance for any assistance you can provide.
--
Scott