The following may work:
In cell [A1] write:
=Sheet2!A1
and copy formula to a range of cells, say A1:P100.
Another way is to use the following macro:
Sub test3()
Sheet2.Cells.Copy Sheet1.Cells
End Sub
Regards,
KL
"Skint4sure" wrote in message
...
I all
I have got a quiz on an excel spreadsheet but dont know all the answers
but
figuren they are on sheet 2 of the workbook BUT that sheet is hidden.
How can I unhide sheet 2 OR find the answers?
thanks
|