Hiya all!

I have a userform setup in Excel 97 VBA and I want to transfer the
inputed data into a specific row in Excel. Initially that may sound
rather simple but here's what I believe to be the tough part. I want
the inputed data to look through the target spreadsheet and tranfer
all data from the userform based on an inputed date. This date and
all other data should all go into the specific row that fits the date.
Basically, the date should be implemented based on chronological
order.

For example, if the date entered was 5/22/04, it should be inserted
between existing entries of 5/21/04 and 5/23/04. The rest of the data
should follow it in the same row.

Now even that would be somewhat simple by the use of the sort command,
however I have subtotals at the end of each month in the spreadsheet.
The macro in question would have to insert a row in the proper area
and then import the data.

Am I crazy to think that such a scenario is possible?

Thanks in advance!

Kris Taylor
www.QuestOfAges.org Administrator