Entering Data into worksheets Simultaneously
 

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.

Entering Data into worksheets Simultaneously
 

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.

Entering Data into worksheets Simultaneously
 

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.

Entering Data into worksheets Simultaneously
 

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
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.

Entering Data into worksheets Simultaneously
 

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
...
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

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.

Entering Data into worksheets Simultaneously
 

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
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.

Entering Data into worksheets Simultaneously
 

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
...
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

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.

Entering Data into worksheets Simultaneously
 

Can you make this simpler for me?
What do you mean "copy down"?
Once i put the formula in the right cell, how do i get Excel to execute the
formula and actually copy the data from sheet 1 to sheet 2?
If i've renamed the 2 sheets to something like Entry Form and Entrant List,
do i have to put those actual names in the formula?

THANKS for your help.

"Dermot" 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.

Entering Data into worksheets Simultaneously
 

Copy down means click on the little black lump at the right-hand bottom corner
of the cell in which you entered the formula.

The black lump is known as the "fill handle"

Drag the fill handle down the column as far as you wish.

The formula will increment the A1 to A2 and A3 etc.

Yes, you have to change the Sheet1 to 'Entry Form'

The formula will be executed when you enter data in the source sheet.


Gord Dibben MS Excel MVP

On Wed, 16 Jul 2008 00:01:45 -0700, LindaSP
wrote:

Can you make this simpler for me?
What do you mean "copy down"?
Once i put the formula in the right cell, how do i get Excel to execute the
formula and actually copy the data from sheet 1 to sheet 2?
If i've renamed the 2 sheets to something like Entry Form and Entrant List,
do i have to put those actual names in the formula?

THANKS for your help.

"Dermot" 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.