Dear Pete,
Do i need to copy this formula to all the cells of the sheet?
Regards,
vivekmane

"Pete_UK" wrote:

Add this formula to A1 of Sheet2:

=IF(Sheet1!A1="","",Sheet1!A1)

Copy the formula across the row for as many columns as you want to
cover, then copy all these formulae down as many rows as you need.

Hope this helps.

Pete

On Oct 23, 8:01 am, VIVEKMANE
wrote:
I have to link complete sheet to another sheet

e.g. if i do the changes in one sheet, the changes should reflect in other
sheet.
How do i do???????????