I think you're choices will be to do it manually or do it via a macro.

phil2006 wrote:

I have a reference in my workbook which copies from cells in sheet2 to
cells in sheet1. Is there anyway (preferably without a macro!) that
will also copy the formats of the cell without doing it manually every
time. I.e it just copies the cell exactly each time.

Thanks

--
phil2006
------------------------------------------------------------------------
phil2006's Profile: http://www.excelforum.com/member.php...o&userid=35092
View this thread: http://www.excelforum.com/showthread...hreadid=566559

--

Dave Peterson