Trend Calculation using VBA

[a_driga]

Hi all,

I working with inventory and I would like to know the trend during the last cycle of an article lead time.

I have attached a file, hopefully with add clarity to the calculation which I would to have.

Within that file several article of inventory have been outlined.
As calculation example, article AAA has a lead time of 7 weeks, and I would like to check the trend based on formula written in cell Y2.

There are two question:
1. Is it the right methodology to check for the trend?
2. If the answer for 1 is correct, then what would be the best method to employ it using VBA?

Thanks for any help given.

[a_driga]

Hmm.. still no response..

[shg]

Probably because no one understands your data. What's the header row mean? What's the data in the body of the table? What's the significance of the highlighting? What are you trying to calculate? What's the formula supposed to calculate, and how did you arrive at it?

[a_driga]

Probably because no one understands your data. What's the header row mean? What's the data in the body of the table? What's the significance of the highlighting? What are you trying to calculate? What's the formula supposed to calculate, and how did you arrive at it?

The header row, within that file what stated within row 1 of the sheet 1:
it contains: ART # (cell A1), DESCRIPTION (cell B1) and week number W40 (cell C10) to W8 (cell W1). The lead time for each article is given in column X.

The manual calculation in Y1 is the summation of the two adjacent cell from the beginning of the last lead time cycle (Q2) until V2.
Y2 = =(R2-Q2)/Q2+(S2-R2)/R2+(T2-S2)/S2+(U2-T2)/T2+(V2-U2)/U2+(W2-V2)/V2
and if the summation is positive then the trend is generally upward and vice versa.

The highlighted cells is to show the last lead time cycle for each article.