Thread: making a list
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
scott scott is offline
external usenet poster
 
Posts: 577
Default making a list

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
on sheet 2 cell B1 and get the same results.



"Elvis" wrote:

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!