Hello All,

I have creted a form to submit rates of items. There are 3 fields Date, Item, Rate in form

in sheet named "Purchase". At one date i can input say 10 item's rate in another sheet named

"Item Rate" through the said form, these rates to be submitted horizontally. there is first

column for date and after from Column B to Column U for items (A to T). Suppose on 1st

November i submit rates of all 10 items in 2nd and 3rd november i don't submit new rates.

But 4th November i submit 4 items new rate so in "Item Rate" Sheet till 4th November

previous rates should appear and 4 items new rates should overlap the old one only in 4th

november and till these rates will applicable when ever i change new rates.

Please help me...

Manoj