Hi,

I've set up a worksheet/workbook which holds details of applications processed in a team I manage. At the moment I've set the workbook up so it has a number of spreadsheets, one for each month, containing details of the applications each officer deals with. I've then got a final sheet at the end with a summary of the year to date info in it.

Unfortunately, since designing this spreadsheet, I've found that I need more than one officer to be able to access info at the same time. I've also found that for official reasons within the organisation, each officer needs a record of their own applications. This obviously goes against the design of the spreadsheet so far which was made to be a central database of all the applications done, not a database of each officer's individual work separated.

In view of the above, I'm going to have to make a few changes obviously. However, I'm not sure which route to go down.

I still need the summary info of 'year so far' with running totals in it, which will need to take info from all of the officers combined.

I will also need something that they can all access at the same time, as opposed to the one-person data entry restriction that applies to a normal spreadsheet. Ideally, I would have one workbook per officer, i.e. with their name on the saved file, a summary of their work to date in each workbook, and somehow have this feed into a separate 'Overall' stats spreadsheet/workbook. However, whilst I'm aware of shared workbooks, I'm not sure how to get multiple workbooks update one central workbook?

Just to be up front, I know nothing about VBA codes, but happy to be advised how one might work in this instance if there is no simple alternative.

Any takers?