Pulling Information from different workbook pages

  • Thread starter Thread starter RedFive
  • Start date Start date
R

RedFive

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!
 
I have about 20 sheets in one workbook and I'm trying to pull 1 column from
each sheet and put that info into it's own sheet. Right now i'm trying to
import into access and build querries but I'm running into errors, not sure
if I've run out of columns or if it's some other kind of error.
 
RedFive said:
I have about 20 sheets in one workbook and I'm trying to pull 1 column from
each sheet and put that info into it's own sheet. Right now i'm trying to
import into access and build querries but I'm running into errors, not sure
if I've run out of columns or if it's some other kind of error.
Click to expand...

Are you trying to sum the data from the 20 sheets into a single sheet?

gls858
 
yes, just trying to take one column from each sheet (not always the same
column) and put them into a single sheet. Also put them in order in their
own column, i.e. column1, column2, column3, column4, column5. . .
 
RedFive said:
yes, just trying to take one column from each sheet (not always the same
column) and put them into a single sheet. Also put them in order in their
own column, i.e. column1, column2, column3, column4, column5. . .
Click to expand...

assuming you have values in A1 on sheets 1-20 and you want to sum these
cells on sheet 21 then on sheet 21 in A1 put this formula

=SUM(Sheet1:Sheet20!A1)

Is this what you are wanting?

gls858
 
no, not really, i don't want to sum, i just want to cut and paste really,
without having to cut and paste.
 
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.
 
Back
Top