View Single Post
  #1   Report Post  
KL
 
Posts: n/a
Default

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