S
slavenp
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!
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!