Ok, i'll try it again:
But the only thing is that de order date is AUTOMATICALLY
given/CALCULATED (in my case when there are more then 21.600 subs
used).
So when a company produced on a day 30.000 products, they need to order
a new pallet of subs (for 1 product you use 1 sub) because more then
21.600 subs are used and then there goes an order for 1 pallet.
So there is far more then 1 order date, but e.g. 7,10,12,13,17 and 18
Jan.
This makes it more difficult.... :(
Cheers
Mark
JulieD Wrote:
Hi Mark
i'm sorry i don't understand what you mean in this post .. could you
please
clarify what you would like to see.
Cheers
JulieD
"Elboo" wrote in message
...
Ok thanks, that's something that looks good. But the only thing is
that
de order date is given (in my case when there are more then 21.600
subs
used).
But i will try to fix it, if you have a suggestion i will hear it.
Thanx 4 your time :)
With many love ;) Mark
Hi Elboo
To get what i think you're after to work i had to change it just a
little ..
..................column A..........column B
row 1.......Order No..........ABC123
2................Order Date........5/1/05 (ie 5 Jan 05)
3................Del. Time (days)..3
4...............1/1/05..................=IF($A4=B$2,"order
date",IF($A4B$2,IF(B$2+B$3=$A4,"delivery",""),"") )
and filled down the column
Now you enter the order date in B2
enter the number of days delivery in B3
and on your calendar you will see the words "order date" and
"delivery"
If you change either B2 or B3 the calendar will adjust
automatically
You can then go across into column C for the next order etc ...
Hope this helps.
Cheers
JulieD
--
Elboo
------------------------------------------------------------------------
Elboo's Profile:
http://www.excelforum.com/member.php...o&userid=16624
View this thread:
http://www.excelforum.com/showthread...hreadid=318689
--
Elboo
------------------------------------------------------------------------
Elboo's Profile:
http://www.excelforum.com/member.php...o&userid=16624
View this thread:
http://www.excelforum.com/showthread...hreadid=318689