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