After my last job at Universal Studios TV Residual Department, I used to tell people, "I can make Ecel wash your car," but of course, it's the simple things that trip us up, isn't it?
I'm making a form for a film festival that I work for. The idea is to have a single form to fill out for each submission that tracks all of its life with the festival -- from submission, to screening results, to either rejection letters or acceptance and beyond.
To do this, I've created a template and used the Data Tracking Wizard to have the data from the template stored in a list. Fine. It's set up okay, but I can't figure out how to save the data on the screen and clear it to start on another film. I have all kinds of formulas and validations within the template, so I can't just record a macro to delete the fields. I don't want to have a workbook for each film, as we have thousands of submissions.
Can this be done in Excel, or am I looking at having to use Access?
I'm making a form for a film festival that I work for. The idea is to have a single form to fill out for each submission that tracks all of its life with the festival -- from submission, to screening results, to either rejection letters or acceptance and beyond.
To do this, I've created a template and used the Data Tracking Wizard to have the data from the template stored in a list. Fine. It's set up okay, but I can't figure out how to save the data on the screen and clear it to start on another film. I have all kinds of formulas and validations within the template, so I can't just record a macro to delete the fields. I don't want to have a workbook for each film, as we have thousands of submissions.
Can this be done in Excel, or am I looking at having to use Access?
