i have made 3 worksheets with some common data headers. what i want is that
while i enter data in sheet 1 in field HOUSE NO for eg i put 673, i want this
673 to be pasted automatically in sheet 2 in the field HOUSE NO.
as Sheet 1 and sheet 2 both have HOUSE NO options in their respective sheet.
so can this be done please help for 2 or more that 2 sheets.

Thank You
Adnan Jahangir