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?