#1   Report Post  
Kent
 
Posts: n/a
Default Kent Hansen

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
  #2   Report Post  
Anik
 
Posts: n/a
Default

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

Reply
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



All times are GMT +1. The time now is 05:21 AM.

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

About Us

"It's about Microsoft Excel"