How to inputed data on one sheet to another automatically
From: Frank Kabel (frank.kabel_at_freenet.de)
Date: 06/11/04
- Next message: Norman Harker: "Re: spellnumber"
- Previous message: mikey: "spellnumber"
- In reply to: ndavies: "How to inputed data on one *** to another automatically"
- Next in thread: Anders Silven: "Re: How to inputed data on one *** to another automatically"
- Messages sorted by: [ date ] [ thread ]
Date: Fri, 11 Jun 2004 05:07:48 -0700
Hi
try using a formula like
='sheet1'!A1
on your other sheets
>-----Originalnachricht-----
>I'm trying to create a workbook that will allow me to
enter data on the
>first *** and it will then append the data to a second
and third
>*** automatically.
>
>
>Example:
>I enter "NDavies" into A1 on *** 1
>A1 on sheet2 automatically updates with "NDavies"
>A1 on sheet3 automatically updates with "NDavies"
>
>When it comes to enter something new in A1 on sheet1,
same function
>above goes into action, accept it should be on the next
available line
>which will be A2 on sheet2 and sheet3 as A1 is already
used by previous
>data entry.
>
>Can this be done?
>
>I would appreciate any help with this.
>
>NDavies
>
>
>---
>Message posted from http://www.ExcelForum.com/
>
>.
>
- Next message: Norman Harker: "Re: spellnumber"
- Previous message: mikey: "spellnumber"
- In reply to: ndavies: "How to inputed data on one *** to another automatically"
- Next in thread: Anders Silven: "Re: How to inputed data on one *** to another automatically"
- Messages sorted by: [ date ] [ thread ]
