Is it possible to use a worksheet as a form to collect data for example, we
have monthly reviews, where we enter data into cells of an excel spreadsheet
(this is full of Validation and Conditional Formating) so January 2007 would
be selected from a drop down list, as would the Company who's review was
taking place. A "once a month date" is entered as the date the review takes
place.
What I would like to do (without creating 12 worksheets) is to colate this
data, into a (hiden) worksheet so that I can use this to calculate "year to
date" figures and for comparison previous years figures and use the main
input form to recover a previous reviews data.
I supose what I am after doing is similar to a Access input form writing to
and reading from an Access table, but in excel.
Is this possible???
Thanks in anticipation
Paul