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! |
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! |
All times are GMT +1. The time now is 11:42 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com