| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
2 cells on multiple pages onto 1 page
How can I get cell A2 and F40 from multiple pages onto one page in two columns?
-- Kelly |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
2 cells on multiple pages onto 1 page
See my reply in your other thread
-- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Kelly" wrote in message ... How can I get cell A2 and F40 from multiple pages onto one page in two columns? -- Kelly |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
2 cells on multiple pages onto 1 page
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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
2 cells on multiple pages onto 1 page
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 |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
2 cells on multiple pages onto 1 page
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 |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
2 cells on multiple pages onto 1 page
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 |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
2 cells on multiple pages onto 1 page
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 --------------- Jacob Skaria "Kelly" wrote: 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 |
|
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
2 cells on multiple pages onto 1 page
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 On Wed, 21 Oct 2009 09:42:02 -0700, Kelly wrote: How can I get cell A2 and F40 from multiple pages onto one page in two columns? |
|
#9
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
2 cells on multiple pages onto 1 page
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? "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 |
|
#10
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
2 cells on multiple pages onto 1 page
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 |
|
#11
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
2 cells on multiple pages onto 1 page
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 |
|
#12
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
2 cells on multiple pages onto 1 page
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? -- Kelly "Jacob Skaria" wrote: 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 --------------- Jacob Skaria "Kelly" wrote: 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 |
|
#13
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
2 cells on multiple pages onto 1 page
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 --------------- Jacob Skaria "Kelly" wrote: 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? -- Kelly "Jacob Skaria" wrote: 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 --------------- Jacob Skaria "Kelly" wrote: 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 |
|
#14
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
2 cells on multiple pages onto 1 page
Yes, each tab is the part # 'PV7001BD060TXOT'. The sheet name is the same as
cell A2 on each page. -- Kelly "Sean Timmons" wrote: 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 |
|
#15
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
2 cells on multiple pages onto 1 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, -- Kelly "Gord Dibben" wrote: 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 On Wed, 21 Oct 2009 09:42:02 -0700, Kelly wrote: How can I get cell A2 and F40 from multiple pages onto one page in two columns? . |
|
#16
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
2 cells on multiple pages onto 1 page
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 On Wed, 21 Oct 2009 12:23:02 -0700, Kelly wrote: 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, |
|
#17
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
2 cells on multiple pages onto 1 page
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. :-) "Kelly" wrote: 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, -- Kelly "Gord Dibben" wrote: 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 On Wed, 21 Oct 2009 09:42:02 -0700, Kelly wrote: How can I get cell A2 and F40 from multiple pages onto one page in two columns? . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Printing Multiple pages one one page | Excel Discussion (Misc queries) | |||
| Printing multiple pages onto one page | Excel Discussion (Misc queries) | |||
| compling info from multiple pages onto one page? | Excel Worksheet Functions | |||
| add cells from various pages in a summary page | Excel Discussion (Misc queries) | |||
| sumif on multiple pages?---not just one page | Excel Worksheet Functions | |||
Linear Mode
