Hi

I'm a considerably experienced and confident Excel user (and Office Professional generally - loads of experience with Access too), but I'm running into problems doing something new with Excel - making forms! (I have succeeded with doing different forms in Word though)

I've fathomed out my combo boxes and my validation rules and I've experimented with the Forms... tool on the data menu and seen how this works, but it doesn't quite accomplish what I think I need. I've also had a play with the various timesheet templates that are available throughout the net, but again ditto. Let me explain:

I want to make a worksheet with 5 sheets - one for each weekday and a 6th sheet in the work book to provide a collated weekly result. The daily sheets will essentially show, start time, stop time, contract number worked on, and other bits in the same row, all for entry by the user.

Therefore, each day could contain a different number of row entries. Each daily spreadsheet will look the same (so the input rows on each sheet will always start on the same row and column and will always finish on the same column, BUT crucially, I think, NOT on the same row number)

The concept that I want is for cells on the last sheet to be able to automatically examine all the daily entries and generate cell entries calculating the total time worked throughout the week for each project on a new row. To do this I think will require range names on each daily sheet to be specified - but the row length of these will change depending on the number of entries.

I am completely open to suggestions and/or maybe instructions for eample could it be necessary to make a form (like the Forms... tool) that will fill in rows in range and update the underlying range name parameters etc. etc.

If it helps I am a VB novice - I don't know enough of the grammar to write the stuff myself from scratch, but I can usually tweak relatively simple code examples into something that I can make function in my own system.

Any ideas I'd be grateful

Julia