Glad it worked.

Paul Kinnear wrote:

Sorry for taking so long to thank you, but I just had to get this right.
Thanks Dave you are "the main man"
Best regards
Paul

"Dave Peterson" wrote:

You may want to look at Debra Dalgleish's site:

http://contextures.com/xlForm02.html
And maybe later...
http://contextures.com/xlForm03.html


Paul Kinnear wrote:

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

--

Dave Peterson


--

Dave Peterson