Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
v. Excel 2007
I have a front sheet that you update which runs for a number of columns along, 12 of which information is taken and 80 rows down. Certain parts of the front sheet information is pulled through to 80 different pages. The current formula I use to pull information through is: =+'Master Info'!B13, =+'Master Info'!C13, etc up to =+'Master Info'!M13 The above populates only one page, the next page should read: =+'Master Info'!B14, =+'Master Info'!C14, etc up to =+'Master Info'!M14 How do I set up the formula in the same cell for each page but have the number change in each time without doing it manually? Thanks for the help! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
what formula do I use to pull rows containing a number? | Excel Discussion (Misc queries) | |||
formula to pull names out of list | Excel Discussion (Misc queries) | |||
is anyone familiar with the pull formula in excel? | Excel Worksheet Functions | |||
formula to pull name and amount | Excel Worksheet Functions | |||
Can i pull text with a Getpivottable formula? | Excel Worksheet Functions |