Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 22
Default AUTOMATIC TRANSFER OF DATA

What is the formula or code I would use if I want to automatically have
information form one worksheet to appear in another worksheet? It should
also automatically update the information also. I am using EXCEL 2003


EXAMPLE: I type CUT in worksheet 1 cell A3 and I want this same info to
show up in worksheet 4 cell C8

Thanks you so much for your help!
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 22,906
Default AUTOMATIC TRANSFER OF DATA

In sheet4 C8 enter =Sheet1!A3


Gord Dibben MS Excel MVP

On Tue, 31 Jul 2007 15:16:02 -0700, ERICA
wrote:

What is the formula or code I would use if I want to automatically have
information form one worksheet to appear in another worksheet? It should
also automatically update the information also. I am using EXCEL 2003


EXAMPLE: I type CUT in worksheet 1 cell A3 and I want this same info to
show up in worksheet 4 cell C8

Thanks you so much for your help!


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


Similar Threads
Thread Thread Starter Forum Replies Last Post
automatic data transfer bigonlif Excel Discussion (Misc queries) 5 September 21st 08 08:30 PM
Automatic transfer of data from one worksheet to another Lewis Shanks Excel Discussion (Misc queries) 1 January 11th 06 10:43 PM
vb code - Automatic transfer of data from one sheet to another herr_bench Excel Worksheet Functions 1 November 24th 05 12:15 AM
Daily Automatic Transfer of data from one ws to another ws Tracy Woolery Excel Programming 0 August 15th 04 09:42 PM
(A repost) Automatic transfer of data between 2 workbooks Hari Excel Programming 1 August 8th 04 08:05 PM


All times are GMT +1. The time now is 10:34 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"