Hi everyone,
Here i am with completely new problem on VBA:
Attachment 263186
I attached you a excel file with the result i wanted.( ofcause without VBA prgm).
Sheet 1: "data GR" with 2 tables and values. I'm only intresseted in column F (scrap %)and column H(scrap cost).
What i want is: one the column F or H are "RED" ( it means values in the col F > col G, or Col H > Col I), so then i want to projet a graph on the Sheet 2 ("Chart GR").
Important: the chart should only take 4 weeks before from the "red" apprears. and that graph got 2 Yscales (left side:Scrap %; Right side: Scrap cost) and one X scale (with 4 weeks).
I really don't know where to start it, i need your support please.
Thank you.
Bookmarks