Formatting Cell from one sheet to another

T

texansgal

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!
 
S

shail

Hi,

say you are entering data at sheet1 and sheet2 must be filled
automatically. To do this you can link the sheet2 with sheet1 using
"=sheet!" followed by the cell number.

Say in the sheet2 at cell number A1, enter the link (formula)
"=sheet1!A1". Then copy & paste all over the sheet till where you need
it. This way sheet2 will be linked with sheet1.

I wish someone could have a better answer. But this too will work.

Thanks,
Shail
 
T

Thufir Howat

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.
 
S

shail

Yes, that is a better option.

Shail

Thufir said:
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.
Click to expand...
 
I

iturnrocks

Sheet 1
_____A______B__
1__vendor1__34
2__vendor2__23
3__vendor3__35

Sheet 2
________A___________B_____
1__=Sheet1!A1___ =Sheet1!B1
2__=Sheet1!A2___ =Sheet1!B2
3__=Sheet1!A3___ =Sheet1!B
 
T

texansgal

Thanks for all of the help, y'all.

Now, I have renamed my sheet, so do I actually put the sheet name or still
1, 2, 3, etc.?
 
T

texansgal

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