Hi everyone!
I've been using excel for 15 years, self taught but i consider myself quite advanced -i'm just starting with macros and vba in a useful way - but there are some big gaps in my knowledge as i've just discovered....
I recently became disabled and I'm getting a lot of physio at my local hospital. I've just spent weeks on a workbook for my local physiotherapy department to ease their admin burden from their scheduling. they are recording all their appointments in a shared outlook calendar then on thursday afternoons spending several hours making up timetables for their patients in word. So I wrote a beautiful workbook which allows 15 team members to add their appointments in a diary and then crunches them into timetables for everyone.
It's a beautiful piece of work, even if i say so myself. Unfortunately it doesn't work. One of my big gaps is shared multi-user workbooks. Excel just doesn't really like them and the team need to use the workbook like they would outlook.
So, I've asked around and it seems access loves this stuff - so here I am!
I have no idea where to start but I read a 'read this first' article on normalisation and now I'm panicking!
If this forum is a fraction as helpful as the Mr Excel forum I know i'll be in good hands.
regards to all
jc
I've been using excel for 15 years, self taught but i consider myself quite advanced -i'm just starting with macros and vba in a useful way - but there are some big gaps in my knowledge as i've just discovered....
I recently became disabled and I'm getting a lot of physio at my local hospital. I've just spent weeks on a workbook for my local physiotherapy department to ease their admin burden from their scheduling. they are recording all their appointments in a shared outlook calendar then on thursday afternoons spending several hours making up timetables for their patients in word. So I wrote a beautiful workbook which allows 15 team members to add their appointments in a diary and then crunches them into timetables for everyone.
It's a beautiful piece of work, even if i say so myself. Unfortunately it doesn't work. One of my big gaps is shared multi-user workbooks. Excel just doesn't really like them and the team need to use the workbook like they would outlook.
So, I've asked around and it seems access loves this stuff - so here I am!
I have no idea where to start but I read a 'read this first' article on normalisation and now I'm panicking!
If this forum is a fraction as helpful as the Mr Excel forum I know i'll be in good hands.
regards to all
jc
