| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Pulling Information from different workbook pages
Glad to help
"RedFive" wrote: Thank you so much Ron, that is exactly what I needed! -- RedFive "Ron@Buy" wrote: Click on cell in 'another page' where you want list to start - enter an = sign, then using mouse click on tab of sheet from where you want data from, then click on cell - press Enter. If you then look at cell on 'another page' you will see the data with a formula entered. Copy this formula (drag!) in the same direction (across, down or both) as data appears on your source sheet. Repeat this for all your other sheets. Hope this helps. "RedFive" wrote: I have two very large pages in one spreadsheet and I need to pull information from one column from both pages and place them into another page. Can anybody help me! -- RedFive |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Need help pulling percentages from all work pages | Excel Worksheet Functions | |||
| Pulling cell information from one workbook to another | Excel Worksheet Functions | |||
| Pulling information from one worksheet into another | Excel Worksheet Functions | |||
| Pulling information from a list | Excel Worksheet Functions | |||
| Pulling all information right of this "(" | Excel Discussion (Misc queries) | |||
Hybrid Mode
