Hello,
I found this template on google which is great. The first worksheet has a form (schedule), which upon sumbission writes to the schedule log and works fine.
I've created two other mini forms on the first worksheet, and would like to replciate the process so that upon submission its writes to the trasnaction and corresponding customer sheets.
Would you mind explaining what I need to do for this to happen? And please be gentle
I'm not too bad with excel formaulas but have zero experience with VBA.
The spreadsheet is here: http://www.ozgrid.com/forum/attachment.php?attachmentid=37419&d=1301972825
I found this template on google which is great. The first worksheet has a form (schedule), which upon sumbission writes to the schedule log and works fine.
I've created two other mini forms on the first worksheet, and would like to replciate the process so that upon submission its writes to the trasnaction and corresponding customer sheets.
Would you mind explaining what I need to do for this to happen? And please be gentle
I'm not too bad with excel formaulas but have zero experience with VBA.The spreadsheet is here: http://www.ozgrid.com/forum/attachment.php?attachmentid=37419&d=1301972825
