In your destination worksheet, click in the cell where you want data to be
copied. Click the "=" sign at top of your Excel application, or just press
the "=" on your keybord. Then click the source cell containing the data to
copy, then ENTER. You have just inserted a formula ! There will be nothing
displayed in the destination cell if there is nothing in the source cell.
Check the help sections in your Excel application about formulas.

"Kent" wrote:

Hello,

Is there away to automatically copy data from one worksheet
to another? Or Have certain fields of data be copied when
a certain cell is populated with data?

Thank You
Kent Hansen