View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
[email protected] paul.robinson@it-tallaght.ie is offline
external usenet poster
 
Posts: 789
Default Excel 'database'

Hi
The obvious answer is to simply all use one file on a shared drive?????
Or am I missing something?
regards
Paul

Duncan wrote:

Hi Guys,

Just posing a small and potentially simple question (well not to me!)

I have made a tiny excel 'program' that looks at the contents of its
sheet and then returns the answer from it, and through it you can add
new entries to the sheet (sheet1).

Now if I wanted to share this with others, how could I have one central
file that we all can open and add to and see each others additions? At
the moment what is on my sheet will not be on someone elses sheet
obviously but I would really like us to all see the same info that each
other has put in. Im sure there is a simple way to do this but I cant
fathom it, its kinda like wanting excel to be access!

Any ideas or tips would be greatly appreciated