I am sure VB code can be written that is capable of doing this.

Any code would have to be set up to be specific to your layout, so not much
can be offered beyond the above.

--
Regards,
Tom Ogilvy

"sowetoddid " wrote in message
...
Sheet1 performs a series of calculations everytime and "event" occurs.
Each "event" will always occur on a unique date. However, the event
does not occur every day.

The goal is for the user to type the event data into the input sections
on sheet1. Upon pushing a command button (ie "calculate"), the inputs
will be run through the calculations and outputs pasted into a unique
row on sheet2. Each time a unique date is put in the inputs section,
the next row on sheet2 will be pasted with data associated with that
date.


Is there a VB code capable of doing this?


Thanks.


---
Message posted from http://www.ExcelForum.com/