Hi everyone,

Although I have been using MS Access for a number of years, including programming with vba, I have always been a little bit wary of using Excel - I think its because I like the reports and forms you can design to make things simple for the end user. A few weeks ago I was asked to look at our current shift rota planner spreadsheet designed using Excel to see if it could be made simpler. I immediately started to redesign the page in Access but soon found myself thinking it was impossible to do on a database and went back to looking at the spreadsheet. I have picked up a few tricks in Excel and some of the vba from Access can easily apply to Excel and I am starting to get change my views on it.

I think that I will have some fun getting to grips with the capabilities of Excel and I know that there will be things I want to do but can't work out which is why I have joined this forum.

I look forward to chatting with you all and hope that I will be able to answer a few queries as a thank you for the thousands of queries I will have asked.

Thanks

SJ