Dropdown select worksheet to point data?

ArviLaanemets · #1 05-07-2018, 12:09 PM

I don't have Excel on my home computer, and for some reason I can't connect to another one through VPN currently, so I can't look what formulas are used on Report sheet. But in general, the formulas use Table and Table Field names, and Named Ranges. So probably a Named Range was the one to confuse you.

Of-course you can post the formula here too (for me it's night currently, so probably I will see it tomorrow morning anyway, but it will be nice to know which formula and which part of it needs to be commented).

ShankedS · #2 05-07-2018, 12:58 PM

Quote:

Originally Posted by ArviLaanemets

I don't have Excel on my home computer, and for some reason I can't connect to another one through VPN currently, so I can't look what formulas are used on Report sheet. But in general, the formulas use Table and Table Field names, and Named Ranges. So probably a Named Range was the one to confuse you.

Of-course you can post the formula here too (for me it's night currently, so probably I will see it tomorrow morning anyway, but it will be nice to know which formula and which part of it needs to be commented).

Here's a visual representation of what I'm looking at in the file. So this is where I'm looking at the data validation for the drop-downs in Report.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Looking to copy select cells in table using dropdown list to paste to new table in another worksheet	CaptainRetired	Excel Programming	18	01-04-2018 07:22 PM
Use function to select another worksheet	eugeneradial	Excel	2	04-27-2017 04:53 AM
Select added value from dropdown menu, program output	Aleksm	Excel Programming	1	01-28-2017 05:40 AM
select a cluster of point from a range based on x and y values	sandcharles	Excel	5	02-19-2015 06:15 AM
Appending unique data from one worksheet to existing data on another worksheet	EdStockton	Excel	1	08-06-2014 11:00 PM