Thank you for the help... the ONLY problem with this way is that I have the
info on Sheet 2 (Contacts) in a different Column than on Sheet 1(Vendors).
This way is copying in the exact same column.

"Thufir Howat" wrote:

If the information is in the exact same cells on each sheet, you can
just highlight both sheets (using the <CTRL + click method) and then
type the information on one of the sheets. The information should be
entered into each sheet.

Say I select Sheets 1, 2 and 3. If I type "Hello" into cell A1 with
all 3 sheets selected, the word "Hello" is entered into A1 of all 3
sheets.

texansgal wrote:
Can anyone help me with the formula to have one sheet copy certain cells as I
type them in?

For example: I want 2 sheets with the EXACT same Vendors. I want some info
on one sheet and different info on another. As I am typing in each cell in
that column, I want the other page to be putting in that same info in a
colum.

Is this possible?

Thanks!