Fill text to two sheets on entry

[SureshSuresh]

Hi!
Can any body help me?
I have one table in my sheet1 and another table in sheet2, some fields in both of those tables are same. I dont want to retype same fields into two sheets, just i want to insert same value in sheet2 when i am typing in sheet1. How can i do this? If its possible, give me reply with an example!
Thanks in advance!

[mdmackillop]

Hi Suresh,
I've moved this to a new post.

Select both sheet tabs using Shift or Control. Text entered in one sheet will appear on the other. Deletions etc. will also affect both sheets. Be a bit wary with this; it's easy to mess up!

[Aussiebear]

MD, this works only if the sheet layout is exactly the same?

Ted

[mdmackillop]

It works CORRECTLY only if the sheet layout is exactly the same. I've found use for this method in changing multiple sheet layouts and formatting, adding headings etc. I've never used it for data entry.