Re: Registers and Issue Sheets

Tech-Archive recommends: Fix windows errors by optimizing your registry

Don Guillett wrote:
Sounds more like a project than a specific question



Indeed, it feels like it!

Arvi Laanemets wrote:

...When in some column (p.e. Recipient) values may repeat frequently, then you
may consider having a register table for those values on separate ***. In
data table, you then apply data validation list for this column, with
register table as source (you define a dynamic named range based on register
table for this). Data validation prevents users from entering misspelled
entries too.


[quoted text clipped - 45 lines]


Thanks for that Arvil. With my lack of knowledge, and as Don so rightly
suggests, this has turned into a project, and looking at your outline, I can
understand how.

I do understand in part what you're explaining, but do start feeling out of
my depth when I get to your last paragraph re: estimating the number of
entries in a year. I have no idea on how to even begin setting this up.

Could you direct me to some good resources on putting something like this
together?

--
Message posted via http://www.officekb.com

.

Quantcast