2 cells on multiple pages onto 1 page
 

How can I get cell A2 and F40 from multiple pages onto one page in two columns?
--
Kelly

2 cells on multiple pages onto 1 page
 

See my reply in your other thread

--

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


"Kelly" wrote in message ...
How can I get cell A2 and F40 from multiple pages onto one page in two columns?
--
Kelly

2 cells on multiple pages onto 1 page
 

Do you mean in sheet1

=Sheet2!A2

=Sheet3!F40

If this post helps click Yes
---------------
Jacob Skaria


"Kelly" wrote:

How can I get cell A2 and F40 from multiple pages onto one page in two columns?
--
Kelly

2 cells on multiple pages onto 1 page
 

Or, in case there's many pages:

=INDIRECT("Sheet"&row(A1)&"!$A$2")

and paste down in first column, then

=INDIRECT("Sheet"&row(A1)&"!$F$40")

in the second

"Jacob Skaria" wrote:

Do you mean in sheet1

=Sheet2!A2

=Sheet3!F40

If this post helps click Yes
---------------
Jacob Skaria


"Kelly" wrote:

How can I get cell A2 and F40 from multiple pages onto one page in two columns?
--
Kelly

2 cells on multiple pages onto 1 page
 

Hey Jacob, thanks for the reply. I have a 400+ page spreadsheet. On every
page cell A2 is the part # and I use the F column to keep a running total of
that part #in and out of the warehouse. So, cell F40 on each page is a safe
place for me to go to pull my current inventory of each part on each page.
What I want to create is a single though very long page that shows in the
first column each part # and the second colmn would be our current stock of
that part.
--
Kelly


"Jacob Skaria" wrote:

Do you mean in sheet1

=Sheet2!A2

=Sheet3!F40

If this post helps click Yes
---------------
Jacob Skaria


"Kelly" wrote:

How can I get cell A2 and F40 from multiple pages onto one page in two columns?
--
Kelly

2 cells on multiple pages onto 1 page
 

I have a total of 400+ pages. From every page I want cell A2 and F40. On
each page A2 shows my part # and F40 is a safe cell to give me my current
inventory. The F column on each of the 400+ pages is a running total of
inventory in and out of the warehouse, so line 40 is far enough down to
capture my current qty.
--
Kelly


"Sean Timmons" wrote:

Or, in case there's many pages:

=INDIRECT("Sheet"&row(A1)&"!$A$2")

and paste down in first column, then

=INDIRECT("Sheet"&row(A1)&"!$F$40")

in the second

"Jacob Skaria" wrote:

Do you mean in sheet1

=Sheet2!A2

=Sheet3!F40

If this post helps click Yes
---------------
Jacob Skaria


"Kelly" wrote:

How can I get cell A2 and F40 from multiple pages onto one page in two columns?
--
Kelly

2 cells on multiple pages onto 1 page
 

If the sheets are named as Sheet1,Sheet2,...Sheet400 then

in Col A cell A1
=INDIRECT("'Sheet" & ROW(A1) &"'!A2")

in colB cell B1
=INDIRECT("'Sheet" & ROW(A1) &"'!F40")

Copy the formulas down as required...which will pull the information from
the sheets

If this post helps click Yes
---------------
Jacob Skaria


"Kelly" wrote:

Hey Jacob, thanks for the reply. I have a 400+ page spreadsheet. On every
page cell A2 is the part # and I use the F column to keep a running total of
that part #in and out of the warehouse. So, cell F40 on each page is a safe
place for me to go to pull my current inventory of each part on each page.
What I want to create is a single though very long page that shows in the
first column each part # and the second colmn would be our current stock of
that part.
--
Kelly


"Jacob Skaria" wrote:

Do you mean in sheet1

=Sheet2!A2

=Sheet3!F40

If this post helps click Yes
---------------
Jacob Skaria


"Kelly" wrote:

How can I get cell A2 and F40 from multiple pages onto one page in two columns?
--
Kelly

2 cells on multiple pages onto 1 page
 

Please display a little patience when waiting for replies.

You have now posted three times in less than 2 hours.


Gord Dibben MS Excel MVP

On Wed, 21 Oct 2009 09:42:02 -0700, Kelly
wrote:

How can I get cell A2 and F40 from multiple pages onto one page in two columns?

2 cells on multiple pages onto 1 page
 

then use my formulas from below. you may want to start with ROW(A2) if you're
putting your totals on sheet1.

Or, do your sheets have different names?

"Kelly" wrote:

I have a total of 400+ pages. From every page I want cell A2 and F40. On
each page A2 shows my part # and F40 is a safe cell to give me my current
inventory. The F column on each of the 400+ pages is a running total of
inventory in and out of the warehouse, so line 40 is far enough down to
capture my current qty.
--
Kelly


"Sean Timmons" wrote:

Or, in case there's many pages:

=INDIRECT("Sheet"&row(A1)&"!$A$2")

and paste down in first column, then

=INDIRECT("Sheet"&row(A1)&"!$F$40")

in the second

"Jacob Skaria" wrote:

Do you mean in sheet1

=Sheet2!A2

=Sheet3!F40

If this post helps click Yes
---------------
Jacob Skaria


"Kelly" wrote:

How can I get cell A2 and F40 from multiple pages onto one page in two columns?
--
Kelly

2 cells on multiple pages onto 1 page
 

to finish my thought from above, if you have tab names other than sheet2,
sheet3, etc. then, you'll probably need VB code.

"Kelly" wrote:

I have a total of 400+ pages. From every page I want cell A2 and F40. On
each page A2 shows my part # and F40 is a safe cell to give me my current
inventory. The F column on each of the 400+ pages is a running total of
inventory in and out of the warehouse, so line 40 is far enough down to
capture my current qty.
--
Kelly


"Sean Timmons" wrote:

Or, in case there's many pages:

=INDIRECT("Sheet"&row(A1)&"!$A$2")

and paste down in first column, then

=INDIRECT("Sheet"&row(A1)&"!$F$40")

in the second

"Jacob Skaria" wrote:

Do you mean in sheet1

=Sheet2!A2

=Sheet3!F40

If this post helps click Yes
---------------
Jacob Skaria


"Kelly" wrote:

How can I get cell A2 and F40 from multiple pages onto one page in two columns?
--
Kelly

2 cells on multiple pages onto 1 page
 

I posted code for that



--

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


"Sean Timmons" wrote in message ...
to finish my thought from above, if you have tab names other than sheet2,
sheet3, etc. then, you'll probably need VB code.

"Kelly" wrote:

I have a total of 400+ pages. From every page I want cell A2 and F40. On
each page A2 shows my part # and F40 is a safe cell to give me my current
inventory. The F column on each of the 400+ pages is a running total of
inventory in and out of the warehouse, so line 40 is far enough down to
capture my current qty.
--
Kelly


"Sean Timmons" wrote:

Or, in case there's many pages:

=INDIRECT("Sheet"&row(A1)&"!$A$2")

and paste down in first column, then

=INDIRECT("Sheet"&row(A1)&"!$F$40")

in the second

"Jacob Skaria" wrote:

Do you mean in sheet1

=Sheet2!A2

=Sheet3!F40

If this post helps click Yes
---------------
Jacob Skaria


"Kelly" wrote:

How can I get cell A2 and F40 from multiple pages onto one page in two columns?
--
Kelly

2 cells on multiple pages onto 1 page
 

Sorry for my ignorance. I'm close to understanding your response. Do I need
to copy the formula for on each of the 400+ pages?
--
Kelly


"Jacob Skaria" wrote:

If the sheets are named as Sheet1,Sheet2,...Sheet400 then

in Col A cell A1
=INDIRECT("'Sheet" & ROW(A1) &"'!A2")

in colB cell B1
=INDIRECT("'Sheet" & ROW(A1) &"'!F40")

Copy the formulas down as required...which will pull the information from
the sheets

If this post helps click Yes
---------------
Jacob Skaria


"Kelly" wrote:

Hey Jacob, thanks for the reply. I have a 400+ page spreadsheet. On every
page cell A2 is the part # and I use the F column to keep a running total of
that part #in and out of the warehouse. So, cell F40 on each page is a safe
place for me to go to pull my current inventory of each part on each page.
What I want to create is a single though very long page that shows in the
first column each part # and the second colmn would be our current stock of
that part.
--
Kelly


"Jacob Skaria" wrote:

Do you mean in sheet1

=Sheet2!A2

=Sheet3!F40

If this post helps click Yes
---------------
Jacob Skaria


"Kelly" wrote:

How can I get cell A2 and F40 from multiple pages onto one page in two columns?
--
Kelly

2 cells on multiple pages onto 1 page
 

No need. Copy the formula to a cell in your summary sheet. Drag/Copy down so
that the formula will return the cell A2 value of Sheet2,Sheet3 and so on...

If this post helps click Yes
---------------
Jacob Skaria


"Kelly" wrote:

Sorry for my ignorance. I'm close to understanding your response. Do I need
to copy the formula for on each of the 400+ pages?
--
Kelly


"Jacob Skaria" wrote:

If the sheets are named as Sheet1,Sheet2,...Sheet400 then

in Col A cell A1
=INDIRECT("'Sheet" & ROW(A1) &"'!A2")

in colB cell B1
=INDIRECT("'Sheet" & ROW(A1) &"'!F40")

Copy the formulas down as required...which will pull the information from
the sheets

If this post helps click Yes
---------------
Jacob Skaria


"Kelly" wrote:

Hey Jacob, thanks for the reply. I have a 400+ page spreadsheet. On every
page cell A2 is the part # and I use the F column to keep a running total of
that part #in and out of the warehouse. So, cell F40 on each page is a safe
place for me to go to pull my current inventory of each part on each page.
What I want to create is a single though very long page that shows in the
first column each part # and the second colmn would be our current stock of
that part.
--
Kelly


"Jacob Skaria" wrote:

Do you mean in sheet1

=Sheet2!A2

=Sheet3!F40

If this post helps click Yes
---------------
Jacob Skaria


"Kelly" wrote:

How can I get cell A2 and F40 from multiple pages onto one page in two columns?
--
Kelly

2 cells on multiple pages onto 1 page
 

Yes, each tab is the part # 'PV7001BD060TXOT'. The sheet name is the same as
cell A2 on each page.
--
Kelly


"Sean Timmons" wrote:

to finish my thought from above, if you have tab names other than sheet2,
sheet3, etc. then, you'll probably need VB code.

"Kelly" wrote:

I have a total of 400+ pages. From every page I want cell A2 and F40. On
each page A2 shows my part # and F40 is a safe cell to give me my current
inventory. The F column on each of the 400+ pages is a running total of
inventory in and out of the warehouse, so line 40 is far enough down to
capture my current qty.
--
Kelly


"Sean Timmons" wrote:

Or, in case there's many pages:

=INDIRECT("Sheet"&row(A1)&"!$A$2")

and paste down in first column, then

=INDIRECT("Sheet"&row(A1)&"!$F$40")

in the second

"Jacob Skaria" wrote:

Do you mean in sheet1

=Sheet2!A2

=Sheet3!F40

If this post helps click Yes
---------------
Jacob Skaria


"Kelly" wrote:

How can I get cell A2 and F40 from multiple pages onto one page in two columns?
--
Kelly

2 cells on multiple pages onto 1 page
 

No problem Gord. This is my first time into this type of community and I
thought my first couple 'Subjects' and descriptions needed improvement.

Thanks,
--
Kelly


"Gord Dibben" wrote:

Please display a little patience when waiting for replies.

You have now posted three times in less than 2 hours.


Gord Dibben MS Excel MVP

On Wed, 21 Oct 2009 09:42:02 -0700, Kelly
wrote:

How can I get cell A2 and F40 from multiple pages onto one page in two columns?

.

2 cells on multiple pages onto 1 page
 

OK

When you want to edit your post, just reply to your own first post and
add/delete information.

That way it stays in one thread so you don't get multiple threads going with
duplicate answers by multiple posters.


Gord

On Wed, 21 Oct 2009 12:23:02 -0700, Kelly
wrote:

No problem Gord. This is my first time into this type of community and I
thought my first couple 'Subjects' and descriptions needed improvement.

Thanks,

2 cells on multiple pages onto 1 page
 

Just to help with that sort of thing, it is always best to reply to your
initial post with any corrections.

Most of us will read any subject, since they can often be misleading.

This is preferrable to having a future helper attempt to resolve this issue
in one of your other posts.

Everyone was new at this at some point, so don't take it too hard. :-)

"Kelly" wrote:

No problem Gord. This is my first time into this type of community and I
thought my first couple 'Subjects' and descriptions needed improvement.

Thanks,
--
Kelly


"Gord Dibben" wrote:

Please display a little patience when waiting for replies.

You have now posted three times in less than 2 hours.


Gord Dibben MS Excel MVP

On Wed, 21 Oct 2009 09:42:02 -0700, Kelly
wrote:

How can I get cell A2 and F40 from multiple pages onto one page in two columns?

.