Sharing data between worksheets

johnwassel Posts 1 Registration date Friday September 20, 2013 Status Member Last seen September 20, 2013 - Sep 20, 2013 at 03:12 PM
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?