I have a workbook (MS Office Excel 2003 SP2) that contains two
worksheets.

In worksheet 1, I have data in column B that I want to appear in
worksheet 2 column A. As this is a worksheet in which the users will
enter data, I want the cursor to automatically skip to column B on
worksheet 2 when that worksheet is active.

For the first requirement (assuming the worksheet names are WK 1 and
WK 2), I entered the following IF in WK 2 , A2 (A1 has a heading):

=IF('WK 1'!B2="","",'WK 1'!B2)

This did indeed copy the data in WK 1 B2 into WK 2 A2 but it also
replaced the function, thus I can't copy it to the rest of the column
A cells. Can't remember if I've ever seen this happen before and I
certainly don't know how to correct it.

In addition, I have no idea how to make the cursor skip over a column.
I would guess it has something to do with protection, but the HELP
function isn't helping!

Thanks for any advice anyone can give me.

Regards,
////
(o o)
-oOO--(_)--OOo-


** Norm's Greetings on US TV Show "Cheers" **

SAM: "What'll you have Normie?"
NORM: "Well, I'm in a gambling mood Sammy. I'll take a glass of whatever
comes out of that tap."
SAM: "Looks like beer, Norm."
NORM: "Call me Mister Lucky."
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

Remove nospam to email me.

Steve