Copy cell to another worksheet

  • Thread starter Thread starter Bob
  • Start date Start date
B

Bob

Hello

I am populating cells C5 thru C100 on my sheet Case Report. I woulld
like the same information to populate my Time sheet in the A1 thru A95
range automatically. Is this possible?

Thanks
Bob
 
This is possible,
but the cells what you selected must be continuous.
--
=====================================================
* ÔÚÎÒÇà´ºÄêÉÙµÄʱºò£¬ÓиöÅ®º¢Ô¸ÎªÎÒÈ¥ËÀ¡£ ¡¡¡¡ *
* ËýÒâÖ¾¼á¶¨µØ¶ÔÎÒ˵£¬ÄãÒªÊÇÔÙ²ø×ÅÎÒ£¬ÎÒ¾ÍÈ¥ËÀ£¡ *
* ÔÚÎÒÇîÀ§Áʵ¹µÄʱºò£¬ÓиöÅ®ÈËÔ¸ºÍÎÒ¹²¸°»ÆȪ£¡¡¡¡¡ *
* ËýÕ¶¶¤½ØÌúµÄ¶ÔÎÒ˵£¬ÄãÔÙ²»»¹Ç®£¬ÎҾͺÍÄãͬ¹éÓÚ¾¡£¡*
* *
* ÕŽ¨Æ½ *
=====================================================
 
Hi Bob!

In A1 of your Time Sheet use

='Case Report'!C5
Then copy down to A95

If you want the Time Sheet entries to be blank pending entries to the Case
Report sheet, use:

=IF('Case Report'!C5="","",'Case Report'!C5)

You'll find it easier to get the address correct if you point to the cells
when entering the formula.

--
--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
Back
Top