Sequential Fill Based on one cell value

[ekasey]

Long time lurker first time poster, thanks in advance for all of the help you guys give to n00bs like me


I'm sure this isn't that difficult to do but I can't figure out how to do it without modifying the code each time.

Purpose Enter one value in a cell ( let's say L1 ) and everytime that number changes it will autofill the values starting with A5

So If I enter a value of 255 in cell L1, I want it to fill Cells A5 through A259 with the values 1 through 255 respectively.

I need it to repopulate if I enter a different number say 500 in L1 would fill A5 through A504

Thanks for any help

[JBeaucaire]

1) Put the number 1 in cell A5
2) Right-click the sheet tab and select VIEW CODE
3) Paste in the Worksheet_Change macro code

Please Login or Register  to view this content.

4) Close the VBEditor and save your workbook as a macro enabled (*.xlsm)
5) Change the value in L1

Each time you change L1, this macro will reassess your numeric list.

[Jaizee]

Hello Jerry,

Is there a formula for this? Don't know VBA hence asking!

Jaizee

[ekasey]

Jerry,

You Rock thanks so much would have probably taken me days to figure that out!

[ekasey]

Now i'm trying to figure out how to get it to write across columns instead of rows...

Spent an hour or so trying to figure out how to get it to write across on row 5, instead of down column A, any help with what I'm missing in the code here ?

Here's the notes I came up with

Please Login or Register  to view this content.

ok another update I believe I found where it is in the code

Please Login or Register  to view this content.

[snb]

Answer to your first question:

Please Login or Register  to view this content.

[snb]

answer to your second question:

Please Login or Register  to view this content.

[ekasey]

You guys rock, thanks so much