Copying the data in and format of a cell to another cell

  • Thread starter Thread starter cyberdude
  • Start date Start date
C

cyberdude

Hi,

How can I copy the data in and format of a cell on a sheet into a cell
on another sheet provided that the 2 sheets are in the same workbook?

Please note that I need to copy not only the data in a cell but also
the cell's format, for example, the size of the cell and colour of the
text inside the cell into another cell.

Thank you.

David
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

COPYING CONDITIONAL FORMATTING WHEN COPYING CELLS OVER 2
Excel Copy cells from one worksheet to another workseet - increment row & do again 0
protect cell format 1
How to Keep Excel Sheet Formatting On a CSV Sheet with vba 1
Conditional formatting in Excel 2010 2
Excel Highlighting duplicates 0
Copy data from unlocked cells 3
Sharing workbooks limitations - Merged Cells 12

Back
Top