Definitely needed the sheet to understand it, but hopefully you like what I have
now sent you. Have gotten rid of all the interim steps, ditched the VBA, and is
all done by formulas. Takes a few seconds to calculate, but is fully automatic.

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------



"Ken Wright" wrote in message
...
LOL - Good timing!! I just finished two weeks of hell at work, and am in a
very
happy mood, so go ahead and send it on down :-)

ken.wright at ntlworld.com - obviously change the ' at ' bit

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------



"jrb " wrote in message
...
Ken,

Is it possible for me to send you a copy of this spreadsheet I am
working on. I have one other item that I am trying to accomplish, but
it will be difficult to explain without you seeing the sheet.

Jeff


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



---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.595 / Virus Database: 378 - Release Date: 25/02/2004




---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.598 / Virus Database: 380 - Release Date: 28/02/2004