Results 1 to 4 of 4

Run table of values through a tab of calculations

Threaded View

  1. #1
    Registered User
    Join Date
    04-24-2013
    Location
    Scotland
    MS-Off Ver
    Excel 2013
    Posts
    43

    Run table of values through a tab of calculations

    Dear people cleverer than me,
    I am looking for some advice on how to run a series of values in a table through a calculation on another tab and then return the value back to a column on the original.

    See attached.
    I have selected the appropriate cells in the first row - how would I go about making this iterative for all the following rows?

    Cell C5 into F5 (on calc sheet)

    Cell F5 into F7 (on calc sheet)

    Cell G5 into H28 (on calc sheet)

    Cell H5 into H30 (on calc sheet)

    Cell J5 into H34 (on calc sheet)

    Cell H168 (on calc sheet) BACK into J5
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Excel 2007 : Pivot table calculations
    By interested in forum Excel General
    Replies: 11
    Last Post: 12-30-2011, 07:21 PM
  2. Pivot Table calculations
    By salexander in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-31-2011, 02:26 PM
  3. calculations in a pivot table
    By Blake 7 in forum Excel General
    Replies: 4
    Last Post: 11-19-2010, 10:55 AM
  4. Pivot table and calculations
    By Horia in forum Excel General
    Replies: 5
    Last Post: 07-16-2010, 02:30 PM
  5. PIvot Table Calculations
    By mistereous in forum Excel General
    Replies: 1
    Last Post: 06-06-2010, 07:56 AM
  6. Excel 2007 : Pivot Table Calculations
    By RHELP in forum Excel General
    Replies: 5
    Last Post: 01-07-2010, 03:05 PM
  7. [SOLVED] add:Pivot Table Calculations
    By PB in forum Excel General
    Replies: 2
    Last Post: 11-25-2005, 03:25 PM
  8. pivot table without any calculations
    By benb in forum Excel General
    Replies: 1
    Last Post: 01-26-2005, 08:06 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1