LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 38
Default 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!
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
what formula do I use to pull rows containing a number? Alexis Excel Discussion (Misc queries) 1 June 27th 08 12:33 AM
formula to pull names out of list Kim Shelton at PDC Excel Discussion (Misc queries) 3 January 23rd 08 05:30 AM
is anyone familiar with the pull formula in excel? tnguyen030 Excel Worksheet Functions 1 June 28th 07 02:14 PM
formula to pull name and amount because Excel Worksheet Functions 1 February 1st 07 08:35 PM
Can i pull text with a Getpivottable formula? Jonathan Excel Worksheet Functions 0 September 14th 06 08:39 PM


All times are GMT +1. The time now is 10:55 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"