Can someone help me on the excel pls????Very very Urgent!!!!

sorry about not being able to type in Chinese, as the computer in the office do not allow me to.

there is a spreedsheet content as below, and I am wondering whether someone can help me on something about excel skills or maybe VBA?

Region Client Total Amt in Euro Start Date End Date Sep-10 Nov-10 Dec-10 Jan-11 Feb-11

as I was required to write some formulas so that when I finish inputting something in the cells under the “Start Date” and “End Date” columns, correpsonding values of the money as indicated in “Total invoice amt in Euros” could appear in the right cell, such as cells under column “Sep-10”, “Nov-10” automatically and accruately.

Millions of thanks in advance

:cn03:

Did you solve it? I am a bit confused about what you were trying to say.

Do you want to calculate a value or copy a date?

已解决

谢谢MM~