Hello, Thanks for any help, I'm a hugely new to excel macro's and looking for a bit of help on what to do

Im trying to create a master form which can be entered on "Workbook 1"

It will have the following headers (Row 1)

A B C D E F G

1 Name service Status DATE Time started Time Ended Entered By


After this, the idea is when data is entered into the second row (or rows below it) It will look to find out which Service is reported. For example "1" This will then give the macro the knowledge to file the data into the folder of the same name in a sheet named workbook named "input"


Example:

A B C D E F G

1 Name service Status DATE Time started Time Ended Entered By

2 Test 1 1 11/11/2012 12:03 12:15 greg


On this sheet when the macro "submit" button is pressed, it would look for at first the service, in this instance is "1" it will then know the file to be updated will be in the folder /1/input.xls

it will then make a carbon copy of that data into the next row of empty cells.

on the actual data though, their would be 3 different services in 3 different folders.

Also, when submitting the data entered, i wanted to be able to clear the spreadsheet of any data entered on closure.

I don't know if this is possible or if i can be any more clear?

I'd create a test sheet but it would essentially look like that above