|
|
#13
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). 
|
| Thread Tools | |
| Display Modes | |
|
|
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 |
Windows 8 
Office 2016
Threaded Mode