+ Reply to Thread
Results 1 to 2 of 2

Get values from input table to add data in output table depending on header

  1. #1
    Forum Contributor
    Join Date
    04-22-2013
    Location
    Philippines
    MS-Off Ver
    Office 365, Excel 2016
    Posts
    146

    Get values from input table to add data in output table depending on header

    I have this input tab where all the listed items. I need to add each line in the output tab and highlight in red.

    There will have additional rows in the output tab.

    A. Column B = Transfer data from input tab (Column A) to output tab (column B)

    B. Column C = Transfer data from input tab (Column C) to output tab (Column C)

    C. Create new line where A will do the same on the next line

    D. From input tab, get the value in column C then locate the value where the column B(input) is located in the output. should be +/- value.
    Attached Files Attached Files

  2. #2
    Forum Contributor
    Join Date
    04-22-2013
    Location
    Philippines
    MS-Off Ver
    Office 365, Excel 2016
    Posts
    146

    Re: Get values from input table to add data in output table depending on header

    Anyone could help me on getting values from input table to add data in output table depending on header

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Display values based on input / output table
    By zdimitrov in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 11-11-2015, 09:12 PM
  2. Replies: 3
    Last Post: 08-13-2015, 10:07 PM
  3. Replies: 0
    Last Post: 11-06-2014, 07:25 PM
  4. Replies: 9
    Last Post: 04-15-2014, 08:12 PM
  5. Read from table input - output summarised data
    By heatwave in forum Excel General
    Replies: 0
    Last Post: 08-02-2010, 08:51 PM
  6. Making a table from input and output
    By JXPES in forum Excel General
    Replies: 0
    Last Post: 04-13-2010, 07:33 PM
  7. Input table -> Output table
    By liquidicy in forum Excel General
    Replies: 2
    Last Post: 09-01-2009, 07:27 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