View Single Post
  #10   Report Post  
Posted to microsoft.public.excel.newusers
Ron@Buy Ron@Buy is offline
external usenet poster
 
Posts: 345
Default 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