Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pull formula through
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! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pull formula through
One way would be to put the formula on the 1st sheet. Then copy it to the
2nd sheet, but one row lower, and so on for the other sheets. Then for sheets 2-80, drag the row back up to where you really wanted it to be. Another way would be to use a find/replace from the edit menu -- this gets a little tricky because you want to replace only the numbers. You could also put togther a macro to create all of them. If you want to go this route, let me know, and provide a little more info and I'll try to help. "slavenp" wrote: 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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
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 |