Entering Data into worksheets Simultaneously

[Dermot]

I have looked up several books but can find no reference to this question:-

Is it possible to enter say a column of client names in Sheet1 column "A"
and simultaneously they are automatically entered into Sheet 2! column A or
any column I choose to use? This would save me having to update both sheets
with the same information. I have used this as a simple example but their are
other occasions when I would like to enter data into sheet1 only but have it
automatically transfered to any other sheet within the workbook.

Any suggestions would be much appreciated, many thanks in advance.

[Toppers]

In Sheet2 put (in desired column):

=IF(Sheet1!A1<>"",Sheet1!A1,"")

and copy down as far as required

HTH

"Dermot" wrote:

> I have looked up several books but can find no reference to this question:-
>
> Is it possible to enter say a column of client names in Sheet1 column "A"
> and simultaneously they are automatically entered into Sheet 2! column A or
> any column I choose to use? This would save me having to update both sheets
> with the same information. I have used this as a simple example but their are
> other occasions when I would like to enter data into sheet1 only but have it
> automatically transfered to any other sheet within the workbook.
>
> Any suggestions would be much appreciated, many thanks in advance.

[Dermot]

Thanks Toppers for your reply,

That works great, cheers.

=IF(Sheet1!A1<>"",Sheet1!A1,"")
How do you interpret this statement so I can understand just wats going
on.......

IF sheet1 Cell A! is not less than or greater than (????) "", Sheet1 Cell A1

I know what I have written isn't quite correct please advise.
Kind Regards
Dermot

"Toppers" wrote:

> In Sheet2 put (in desired column):
>
> =IF(Sheet1!A1<>"",Sheet1!A1,"")
>
> and copy down as far as required
>
> HTH
>
> "Dermot" wrote:
>
> > I have looked up several books but can find no reference to this question:-
> >
> > Is it possible to enter say a column of client names in Sheet1 column "A"
> > and simultaneously they are automatically entered into Sheet 2! column A or
> > any column I choose to use? This would save me having to update both sheets
> > with the same information. I have used this as a simple example but their are
> > other occasions when I would like to enter data into sheet1 only but have it
> > automatically transfered to any other sheet within the workbook.
> >
> > Any suggestions would be much appreciated, many thanks in advance.

[Gord Dibben]

Dermot

<>"" means not empty

"" means look blank

Toppers formula...............=IF(Sheet1!A1<>"",Sheet1!A1,"")
says....................

If Sheet1!A1 is not empty, return what is in Sheet1!A1 otherwise let this cell
look blank.

If you just enter =Sheet1!A1 and A1 has nothing entered, you will get a 0
showing and you don't want a column of 0's


Gord Dibben MS Excel MVP

On Sun, 30 Jul 2006 05:12:01 -0700, Dermot <[email protected]>
wrote:

>Thanks Toppers for your reply,
>
>That works great, cheers.
>
>=IF(Sheet1!A1<>"",Sheet1!A1,"")
>How do you interpret this statement so I can understand just wats going
>on.......
>
>IF sheet1 Cell A! is not less than or greater than (????) "", Sheet1 Cell A1
>
>I know what I have written isn't quite correct please advise.
>Kind Regards
>Dermot
>
>"Toppers" wrote:
>
>> In Sheet2 put (in desired column):
>>
>> =IF(Sheet1!A1<>"",Sheet1!A1,"")
>>
>> and copy down as far as required
>>
>> HTH
>>
>> "Dermot" wrote:
>>
>> > I have looked up several books but can find no reference to this question:-
>> >
>> > Is it possible to enter say a column of client names in Sheet1 column "A"
>> > and simultaneously they are automatically entered into Sheet 2! column A or
>> > any column I choose to use? This would save me having to update both sheets
>> > with the same information. I have used this as a simple example but their are
>> > other occasions when I would like to enter data into sheet1 only but have it
>> > automatically transfered to any other sheet within the workbook.
>> >
>> > Any suggestions would be much appreciated, many thanks in advance.

[Ragdyer]

I always translated <> as "not equal to", or "does not equal".
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Gord Dibben" <gorddibbATshawDOTca> wrote in message
news:[email protected]...
> Dermot
>
> <>"" means not empty
>
> "" means look blank
>
> Toppers formula...............=IF(Sheet1!A1<>"",Sheet1!A1,"")
> says....................
>
> If Sheet1!A1 is not empty, return what is in Sheet1!A1 otherwise let this
cell
> look blank.
>
> If you just enter =Sheet1!A1 and A1 has nothing entered, you will get a 0
> showing and you don't want a column of 0's
>
>
> Gord Dibben MS Excel MVP
>
> On Sun, 30 Jul 2006 05:12:01 -0700, Dermot
<[email protected]>
> wrote:
>
> >Thanks Toppers for your reply,
> >
> >That works great, cheers.
> >
> >=IF(Sheet1!A1<>"",Sheet1!A1,"")
> >How do you interpret this statement so I can understand just wats going
> >on.......
> >
> >IF sheet1 Cell A! is not less than or greater than (????) "", Sheet1 Cell
A1
> >
> >I know what I have written isn't quite correct please advise.
> >Kind Regards
> >Dermot
> >
> >"Toppers" wrote:
> >
> >> In Sheet2 put (in desired column):
> >>
> >> =IF(Sheet1!A1<>"",Sheet1!A1,"")
> >>
> >> and copy down as far as required
> >>
> >> HTH
> >>
> >> "Dermot" wrote:
> >>
> >> > I have looked up several books but can find no reference to this
question:-
> >> >
> >> > Is it possible to enter say a column of client names in Sheet1 column
"A"
> >> > and simultaneously they are automatically entered into Sheet 2!
column A or
> >> > any column I choose to use? This would save me having to update both
sheets
> >> > with the same information. I have used this as a simple example but
their are
> >> > other occasions when I would like to enter data into sheet1 only but
have it
> >> > automatically transfered to any other sheet within the workbook.
> >> >
> >> > Any suggestions would be much appreciated, many thanks in advance.
>

[Dermot]

Thanks for the explanation Gord
Kind Regards
Dermot

"Gord Dibben" wrote:

> Dermot
>
> <>"" means not empty
>
> "" means look blank
>
> Toppers formula...............=IF(Sheet1!A1<>"",Sheet1!A1,"")
> says....................
>
> If Sheet1!A1 is not empty, return what is in Sheet1!A1 otherwise let this cell
> look blank.
>
> If you just enter =Sheet1!A1 and A1 has nothing entered, you will get a 0
> showing and you don't want a column of 0's
>
>
> Gord Dibben MS Excel MVP
>
> On Sun, 30 Jul 2006 05:12:01 -0700, Dermot <[email protected]>
> wrote:
>
> >Thanks Toppers for your reply,
> >
> >That works great, cheers.
> >
> >=IF(Sheet1!A1<>"",Sheet1!A1,"")
> >How do you interpret this statement so I can understand just wats going
> >on.......
> >
> >IF sheet1 Cell A! is not less than or greater than (????) "", Sheet1 Cell A1
> >
> >I know what I have written isn't quite correct please advise.
> >Kind Regards
> >Dermot
> >
> >"Toppers" wrote:
> >
> >> In Sheet2 put (in desired column):
> >>
> >> =IF(Sheet1!A1<>"",Sheet1!A1,"")
> >>
> >> and copy down as far as required
> >>
> >> HTH
> >>
> >> "Dermot" wrote:
> >>
> >> > I have looked up several books but can find no reference to this question:-
> >> >
> >> > Is it possible to enter say a column of client names in Sheet1 column "A"
> >> > and simultaneously they are automatically entered into Sheet 2! column A or
> >> > any column I choose to use? This would save me having to update both sheets
> >> > with the same information. I have used this as a simple example but their are
> >> > other occasions when I would like to enter data into sheet1 only but have it
> >> > automatically transfered to any other sheet within the workbook.
> >> >
> >> > Any suggestions would be much appreciated, many thanks in advance.
>
>

[Dermot]

Ragdyer
Thanks too for posting
Cheers
Dermot

"Ragdyer" wrote:

> I always translated <> as "not equal to", or "does not equal".
> --
> Regards,
>
> RD
>
> ---------------------------------------------------------------------------
> Please keep all correspondence within the NewsGroup, so all may benefit !
> ---------------------------------------------------------------------------
> "Gord Dibben" <gorddibbATshawDOTca> wrote in message
> news:[email protected]...
> > Dermot
> >
> > <>"" means not empty
> >
> > "" means look blank
> >
> > Toppers formula...............=IF(Sheet1!A1<>"",Sheet1!A1,"")
> > says....................
> >
> > If Sheet1!A1 is not empty, return what is in Sheet1!A1 otherwise let this
> cell
> > look blank.
> >
> > If you just enter =Sheet1!A1 and A1 has nothing entered, you will get a 0
> > showing and you don't want a column of 0's
> >
> >
> > Gord Dibben MS Excel MVP
> >
> > On Sun, 30 Jul 2006 05:12:01 -0700, Dermot
> <[email protected]>
> > wrote:
> >
> > >Thanks Toppers for your reply,
> > >
> > >That works great, cheers.
> > >
> > >=IF(Sheet1!A1<>"",Sheet1!A1,"")
> > >How do you interpret this statement so I can understand just wats going
> > >on.......
> > >
> > >IF sheet1 Cell A! is not less than or greater than (????) "", Sheet1 Cell
> A1
> > >
> > >I know what I have written isn't quite correct please advise.
> > >Kind Regards
> > >Dermot
> > >
> > >"Toppers" wrote:
> > >
> > >> In Sheet2 put (in desired column):
> > >>
> > >> =IF(Sheet1!A1<>"",Sheet1!A1,"")
> > >>
> > >> and copy down as far as required
> > >>
> > >> HTH
> > >>
> > >> "Dermot" wrote:
> > >>
> > >> > I have looked up several books but can find no reference to this
> question:-
> > >> >
> > >> > Is it possible to enter say a column of client names in Sheet1 column
> "A"
> > >> > and simultaneously they are automatically entered into Sheet 2!
> column A or
> > >> > any column I choose to use? This would save me having to update both
> sheets
> > >> > with the same information. I have used this as a simple example but
> their are
> > >> > other occasions when I would like to enter data into sheet1 only but
> have it
> > >> > automatically transfered to any other sheet within the workbook.
> > >> >
> > >> > Any suggestions would be much appreciated, many thanks in advance.
> >
>
>