View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Andy Mc Andy Mc is offline
external usenet poster
 
Posts: 5
Default 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. ;-)