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