The data part of the macro I'm trying to create may be better suited for Access but it lays out better in Excel. I have 3 or 4 different data stores or the equivalent of tables. Very small business. Nothing to big.
main employee list.
A positions list they like to be able to edit.
A training list to certify training that they would like to edit.
I'm thinking that storing them in table like format and connecting them with a key would be best. So, questions are:
Would it be better to store each "table" on a separate worksheet?
If I generated a primary key, what would be the best way to do that?
main employee list.
A positions list they like to be able to edit.
A training list to certify training that they would like to edit.
I'm thinking that storing them in table like format and connecting them with a key would be best. So, questions are:
Would it be better to store each "table" on a separate worksheet?
If I generated a primary key, what would be the best way to do that?
