"Winnie" wrote:
How to show the result(sheet 1) on sheet2 and sheet3

Perhaps you mean simple link formulas ..

In any starting cell in either Sheet2 or Sheet3 ..
Put say in, B2: =Sheet1!A1
then copy B2 across and fill down to return correspondingly from Sheet1
as may be required

Alternatively, for a neat clean look in the Sheets 2 or 3,
i.e. to avoid extraneous zeros display for any linked empty cells in Sheet1,
we could use instead in B2: =IF(Sheet1!A1="","",Sheet1!A1)
and copy across / fill down as before
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---