Rod has attended:
Excel Intermediate course
Excel
How do I prevent formatting being lost when I copy one worksheet on to another?
RE: Excel - Paste Special
Dear Rod
Thank you for attending the Excel Intermediate and I hope you enjoyed the course and benefited from it.
If you are trying to copy data from one sheet to another and you just want the data to be copied and not the formatting so that the data being copied can use the formatting of the destination cells then please follow these steps:
Copy the cells from the source sheet
Click on the cell you want the data to be pasted in the destination sheet.
Right click on the sheet
Choose Paste Special