2 cells on multiple pages onto 1 page

[Kelly]

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

 

[Ron de Bruin]

See my reply in your other thread

 

[Jacob Skaria]

Do you mean in sheet1

=Sheet2!A2

=Sheet3!F40

If this post helps click Yes

 

[Sean Timmons]

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

 

[Kelly]

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]

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.

 

[Jacob Skaria]

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

 

[Gord Dibben]

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

 

[Sean Timmons]

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?

 

[Sean Timmons]

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

 

[Ron de Bruin]

I posted code for that

 

[Kelly]

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?

 

[Jacob Skaria]

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

 

[Kelly]

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

 

[Kelly]

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,

 

[Gord Dibben]

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

 

[Sean Timmons]

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.