Sharing data between worksheets

Closed
Report
Posts
1
Registration date
Friday September 20, 2013
Status
Member
Last seen
September 20, 2013
-
I would like to share data between worksheets. I have data on one sheet that is labeled as 1 - 100 with descriptions and other information. I would like to be able to just type in a number say 20 on sheet number two and the information from the first description sheet is automatically transferred to that second sheet. Can it be done?