Hi, try this formula in A1 on Sheet2 then fill it across and down...

=INDIRECT("Sheet1!" & ADDRESS(ROW(),COLUMN()*2-1))

Any blank cells on Sheet 1 in this range of cells will appear on Sheet
2 as zeroes. If that is not to your liking then use this formula...

=IF(ISBLANK(INDIRECT("Sheet1!" &
ADDRESS(ROW(),COLUMN()*2-1))),"",INDIRECT("Sheet1!" &
ADDRESS(ROW(),COLUMN()*2-1)))

If Sheet 1 has a different name such as Silly Sheet Name then use...

=IF(ISBLANK(INDIRECT("'Silly Sheet Name'!" &
ADDRESS(ROW(),COLUMN()*2-1))),"",INDIRECT("'Silly Sheet Name'!" &
ADDRESS(ROW(),COLUMN()*2-1)))

OR...

=INDIRECT("'Silly Sheet Name'!"&ADDRESS(ROW(),COLUMN()*2-1))

Ken Johnson