2 cells on multiple pages onto 1 page

  • Thread starter Thread starter Kelly
  • Start date Start date
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
 
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.
 
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.
 
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
 
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
 
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?
 
to finish my thought from above, if you have tab names other than sheet2,
sheet3, etc. then, you'll probably need VB code.
 
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?
 
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
 
Yes, each tab is the part # 'PV7001BD060TXOT'. The sheet name is the same as
cell A2 on each 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,
 
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
 
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. :-)
 
Back
Top