Increment values 1 by 1 and refresh columns automatically

[FilipeF]

Hi all,

EXCEL QUESTION.png

-ONLY M3 matters. The rest of column M and N are IRRELEVANT.
In this example, for M3=120 I would like the following to happen automatically:
-Column K is filled starting from K3=0 till K123=M3=120 (K4=1, K4=2, K5=3, etc.);
-Column L is filled starting from L3=100000 till L123=L3=100000; (L"y"=L3);

M3 is a variable value >0.

This is the Macro I'm trying to use for the column K:

Sub Increment_Macro()

Dim i As Integer, j As Integer
i = 4
j = 11
Do Until i < whatsinthecell = Worksheets("AidCalc1").Range("M3").Value
Cells(i, j).Value = whatsinthecell = Worksheets("AidCalc1").Range("K3").Value
i = i + 1
Loop

End Sub

This is what I get:
result.PNG

QUESTIONS:
-How do I fix the Macro for column K?
-What should the Macro be for column L?
-The next step is to plot these columns in a line graph. How do I define the columns to be plotted since they are always different depending on the M3 input?


Thanks in advance!

[daboho]

Perhab like this

Please Login or Register  to view this content.

[FilipeF]

Thanks a lot, now it's running!

Although everytime I run the macro for a new value of M3 it opens a new sheet. Is it possible to first clean the columns $K$3:$L$(VALUE of M3+3) and then run the macro always on this sheet (AidCalc1) and introduce the values on the columns K and L?

Also, the next step of what I want to do is to plot those 2 columns into a line graph. Any ideas on how I can do that? The range is variable so I'm not sure how to overcome that.

Thanks a lot for your help!

[mohan.r1980]

i have a UPS Master Macro file
find the attached file which will help you

[FilipeF]

Thank you once again but it's password protected.

[mohan.r1980]

No FilipeF its not password protected

when you open it just enable the protection which see on top

[FilipeF]

I want to view the code to adapt it to my case and, as I said, it's password protected
passwordprotected.PNG

[daboho]

Thanks a lot, now it's running!

Although everytime I run the macro for a new value of M3 it opens a new sheet. Is it possible to first clean the columns $K$3:$L$(VALUE of M3+3) and then run the macro always on this sheet (AidCalc1) and introduce the values on the columns K and L?

Also, the next step of what I want to do is to plot those 2 columns into a line graph. Any ideas on how I can do that? The range is variable so I'm not sure how to overcome that.

Thanks a lot for your help!

If not in other sheet

erhab like this
Code:

Please Login or Register  to view this content.

[mohan.r1980]

ahh that have password
ok

i am pasting the code below

Please Login or Register  to view this content.

the file which i provided is for ups only.
In your case if you put 120 in B column and "ABC" In Column A then macro will repeat "ABC" 120 times
anyway i am working on your question. let me have some time

[FilipeF]

Minor detail: As shown in the image I have other stuff on the sheet. Is it possible to just clear the columns $K$3:$L$(VALUE of M3+3)?
More significant observation: Whether I run the macro on this sheet or not, the same issue with the graph plotting stands. How do I plot a line graph with a variable range? (M3 is a variable value>0)
Capture.PNG
Once again, Thank you!

[mohan.r1980]

Please Login or Register  to view this content.

[FilipeF]

Minor detail: As shown in the image I have other stuff on the sheet. Is it possible to just clear the columns $K$3:$L$(VALUE of M3+3) instead of the whole sheet?
More significant observation: Whether I run the macro on this sheet or not, the same issue with the graph plotting stands. How do I plot a line graph with a variable range? (M3 is a variable value>0)

Before running the macro:
Attachment 598936

After running the macro:
Attachment 598937
Once again, Thank you!