making a list

E

Elvis

I need to extract the data from the same cell in multiple worksheets and
create a list... for example, worksheet 1; cell C1 = 1234, worksheet 2; cell
C1 = 5678, worksheet 3; cell C1 = 1290. and i need all this information
listed on a new worksheet. The same applies for specific other cells. I
need all this info. in order to create a database for work. Can someone
please, please help me!
 
S

Scott

Lets say I wanted to put the information from Sheet2 Cell B1 in any cell on
Sheet 1 - This is what I would type: =Sheet2!B1

You can also just type the = sign on any cell on sheet 1 then go and click
 
Top