Sheet2
A1 =IF(Sheet1!A1="","",Sheet1!A1)
Select A1 and drag all the way down to A200

"AngelaD" wrote:

It worked, but how can I get it to populate an entire column? For example, if
I want to add some one in A200, and I want that same exact info in another
sheet updated in A200 (worksheet 2) how can I make that happen?

"T. Valko" wrote:

If you want the entry made in Sheet1 cell A1 to also appear in Sheet2 cell
A20, enter this formula in Sheet2 cell A20:

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

Biff

"AngelaD" wrote in message
...
My boss wants me to create a form in either Excel or Access. He first
wanted
Excel because most people have excel on their computer. But I said Access
because I thought it was easier. Anyway, he wants me to create a form.
There
are multiple forms for different purposes but sometimes require redundant
information. How can you populate fields in one worksheet and have it
updated
also in another worksheet (within the same workbook)? Would this be easier
to
do in Access?
Help is much appreciated!
Angela