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

Details?

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"RedFive" wrote in message
...
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

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


"Don Guillett" wrote:

Details?

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"RedFive" wrote in message
...
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

Maybe
http://www.rondebruin.nl/copy2.htm

See this macro
Copy a range/column after the last column with data

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"RedFive" wrote in message ...
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


"Don Guillett" wrote:

Details?

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"RedFive" wrote in message
...
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

RedFive wrote:
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.

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


"gls858" wrote:

RedFive wrote:
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.

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

gls858

RedFive wrote:
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. . .

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.
--
RedFive


"gls858" wrote:

RedFive wrote:
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. . .

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

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

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

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