Entering Data into worksheets Simultaneously

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
In Sheet2 put (in desired column):

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

and copy down as far as required

HTH
 
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
 
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
 
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.
 
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
 
Back
Top