Database in Excel
I was thinking of having just 1 or 2 people in charge of updating the
database, and only reading in Read Only mode by everyone. The database would
hold nearly 4000 names, mobile numbers, and their region/department
managers.
The cell ranges I have are A1:V3668.
Ideally I would have the raw data kept in a separate sheet or workbook and
everyone else views the data on a separate sheet or workbook.
I know this sounds like a tall order, and I guess a little complex.
I do not want it as a Auto filter as that can lead to an easier and simple
database format. But I am also trying to expand on want I can do. Pivot
Table is a better option, but not exactly the route I want to go.
Perhaps it might be better to upload the rough idea I have, without correct
data, to give you an idea of the way I am trying to go.
Many thanks for the ideas and advice, it is extremely helpful on ways I can
progress.
Also makes me think I am trying the impossible, but I will keep trying. I do
not like defeat. ;-)
|