Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
making a list
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! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do you find the list option in excel on office xp | Excel Worksheet Functions | |||
Making a dynamic list?! | Excel Discussion (Misc queries) | |||
Making list of items to truck monthly usage | Excel Discussion (Misc queries) | |||
making one material list from mulitple vendor material lists | Excel Worksheet Functions | |||
making a non-validation list | Excel Worksheet Functions |