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!