HELP! Writing to Master Workbook.

Hi everyone.

I have a bit of a problem, and hopefully you wise Excel-ites can help me out.

As part of a new Document Management initiative in my organisation we are trying to create some new procedures and policies to fix our cluttered Shares.

One of the main problem areas is the creation and reporting of Incidents (construction business) on all sites. So we had an idea to create a Master Excel register which contains all incidents, and another workbook that will act as a 'incident form'. Staff will input basic incident details and hit a button and an appropriately named folder will be created and the incident details will be stored in the master register. Also I can only use Excel for this as most of the sites have no access to MS Access.

I have created a 'Incident Form' and a button tied to a macro that creates the folder (thanks to a response in this forum).

The trouble I'm having is the code that will write the details found in the 'Incident Form' to the Master Register.

Sorry for the wall of text but I've had no luck searching for the answer on the Web, and don't know all the required terminology so thought I would fully explain it.

Thanks a lot!

Ivan

Just a suggestion!
Can you not create/format the Incident form on 1 sheet, then have the register of incidents on sheet2.
Use VBA and buttons to create a new incident record by completing the formatted form(sheet1), then save(button - VBA) to populate the entered data into the register(sheet2)?

Much easier to keep track of as all documents/data are in the one place.
Just my POV.

Hi coreytroy, thanks a lot for your reply!

Its a great idea, the only issue for us is that we have multiple site specific 'project' areas, so we would need to create the 'incident form' in all the sites, with a central 'master register'. But the solution maybe having shortcuts to the combined 'master register/incident form' in all the site folders.

I will still have to do some research on how to populate between sheets, and how to lock of certain sheets as the 'register' would have privacy restrictions.

Thanks again for your time.