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
Bookmarks