Dropdown select worksheet to point data?

ArviLaanemets · #1 05-03-2018, 02:15 PM

Here is an example how I would do it.

Sheet Hidden, as you can guess, will be hidden.

I started with grouping organizations like in your example (OrgTypes), but dropped the idea and went with organizations instead. The sheet and columns remained, but aren't used.

On Persons sheet, last 2 columns are meant to be hidden too.

On report sheet, you can drag fields with formulas into any position on sheet you want. I prepared only some fields to give you the idea. and of-course you can display organization info on report sheet too (use VLOOKUP).

ShankedS · #2 05-07-2018, 08:08 AM

Quote:

Originally Posted by ArviLaanemets

Here is an example how I would do it.

Sheet Hidden, as you can guess, will be hidden.

I started with grouping organizations like in your example (OrgTypes), but dropped the idea and went with organizations instead. The sheet and columns remained, but aren't used.

On Persons sheet, last 2 columns are meant to be hidden too.

On report sheet, you can drag fields with formulas into any position on sheet you want. I prepared only some fields to give you the idea. and of-course you can display organization info on report sheet too (use VLOOKUP).

So. No VBA here, it seems, which would definitely be more manageable for me. However, when I checked Data Validation for Report, B1 and B2, I found references to a column name that I can't seem to find within the document?

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