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