+ Reply to Thread
Results 1 to 6 of 6

Trying to combine two data sets to get one answer

  1. #1
    Forum Contributor
    Join Date
    06-23-2014
    Location
    USA
    MS-Off Ver
    2010
    Posts
    239

    Trying to combine two data sets to get one answer

    Good afternoon everyone,

    OK guys I hope this can be done!?

    If you look at my workbook I have to worksheets, one called (B_D sec11) the other (data). In workbook (B_D sec 11) I have a map, a scatter plot (x, y) chart and some tables with labels, counts and something I call a Identifier . If you click the scatter plot and then click the "Identify" button you will get numbers attached to point on the scatter plot. Now if you go to the "data" workbook these numbers are from the "index" column tagged to the (x, y) points on the chart. This index number has a column before it called "items". If you click a point on the scatter plot you will get 2 red lines going to that point on the chart.
    What I am trying to figure out is how to get this or these index numbers (from the data and scatter plot chart) for that Item to go in to the cells for that item seen in the tables. So I can stop going back and forth between both worksheets and losing my position
    Example...

    Item...............................Count.....Identifiers
    Aluminum, Bearing 1 1
    Aluminum, Bottle Cap 3 8,10,11
    Aluminum, Nail 2 2,13
    Miscellaneous, House Key 1 15
    Coins, One cent 2 16,17
    Coins, Quarter 1 18
    etc....

    If anyone knows of a better way to do this and understands what I am trying to do and has a better way please feel free.

    Thank you,
    Brian
    Attached Files Attached Files

  2. #2
    Forum Contributor
    Join Date
    06-23-2014
    Location
    USA
    MS-Off Ver
    2010
    Posts
    239

    Re: Trying to combine two data sets to get one answer

    Sorry it should look like this...
    Item...............................Count.....Identifiers
    Aluminum, Bearing.......... 1................. 1
    Aluminum, Bottle Cap...... 3 ................8,10,11
    Aluminum, Nail............... 2................ 2,13
    Miscellaneous, House Key.1 ................15
    Coins, One cent.............. 2................ 16,17
    Coins, Quarter............... 1................. 18

  3. #3
    Forum Contributor
    Join Date
    06-23-2014
    Location
    USA
    MS-Off Ver
    2010
    Posts
    239

    Re: Trying to combine two data sets to get one answer

    Ok guys, I have the first part working, Identifiers. Now trying to get the second part to do its job.
    First code
    Please Login or Register  to view this content.

  4. #4
    Forum Contributor
    Join Date
    06-23-2014
    Location
    USA
    MS-Off Ver
    2010
    Posts
    239

    Re: Trying to combine two data sets to get one answer

    The second part not doing so well, it's not highlighting when I click a point within the scatter plot.
    Please Login or Register  to view this content.

  5. #5
    Forum Contributor
    Join Date
    06-23-2014
    Location
    USA
    MS-Off Ver
    2010
    Posts
    239

    Re: Trying to combine two data sets to get one answer

    Here is the workbook with the "Identify" button working.

  6. #6
    Forum Contributor
    Join Date
    06-23-2014
    Location
    USA
    MS-Off Ver
    2010
    Posts
    239

    Re: Trying to combine two data sets to get one answer

    Workbook partly working
    Attached Files Attached Files

+ 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. Combine two data sets and merge them
    By oddy73 in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 04-23-2015, 07:15 AM
  2. Combine two data sets and merge them into one table
    By oddy73 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 04-03-2015, 09:02 PM
  3. Combine to sets of data
    By rlsmith789 in forum Excel General
    Replies: 2
    Last Post: 07-08-2014, 07:43 PM
  4. [SOLVED] How to Combine two sets of data in excel
    By Jchhoule in forum Excel General
    Replies: 3
    Last Post: 05-10-2012, 02:47 PM
  5. Combine multiple data sets into one master spreadsheet
    By thetrickster in forum Excel General
    Replies: 5
    Last Post: 01-16-2012, 02:55 PM
  6. Combine two sets of data
    By FrankCastle in forum Excel General
    Replies: 4
    Last Post: 08-15-2011, 06:31 PM
  7. [SOLVED] How to combine two data sets with one category of variable in com.
    By Brown in forum Excel - New Users/Basics
    Replies: 3
    Last Post: 03-22-2005, 08:08 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