LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 12
Default Copying the data in and format of a cell to another cell

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

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Converting data in General Format cell to a number PE Excel Discussion (Misc queries) 3 October 26th 06 11:58 AM
Macro question Chris Excel Worksheet Functions 12 July 7th 06 01:23 AM
Cell format problem after copying jsullg Excel Worksheet Functions 4 June 25th 06 01:11 PM
Custom Format Cell nastech Excel Discussion (Misc queries) 13 April 28th 06 08:31 PM
Copying excel format from cell to cell Loopy Darren Excel Discussion (Misc queries) 2 April 12th 05 04:29 PM


All times are GMT +1. The time now is 08:05 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"