Automatic fill cells

[kharder]

Hi all,

Is there a function that fills cells automaticaly??

If I enters the values 1 and 10, I would like Excell to automaticaly fill cells with values like this..

1 10

1,00
1,01
1,02
etc.. up to 10.

Thanks in advance.
Kharder

[Bryan Hessey]

Hi all,

Is there a function that fills cells automaticaly??

If I enters the values 1 and 10, I would like Excell to automaticaly fill cells with values like this..

1 10

1,00
1,01
1,02
etc.. up to 10.

Thanks in advance.
Kharder

Put 1 in a cell and Copy
Select the area required and Paste, special = Add

Put =Rand() in a cell and Copy
Select the area required and Paste, special = Multiply.


You can modify the Rand() to suit your needs.
---

[kharder]

Thanks for your reply Brian...

But that was not what I had in mind.

If I write 1 in cell A1 and 10 in cell B1 then Excel should return the values from 1,00 to 10,00 on a list.

Hope this makes it more clear.

[Bryan Hessey]

Thanks for your reply Brian...

Who?

But that was not what I had in mind.

If I write 1 in cell A1 and 10 in cell B1 then Excel should return the values from 1,00 to 10,00 on a list.

Hope this makes it more clear.

Try a macro with the code

Please Login or Register  to view this content.

and put a 1 in D1, a .1 in E1 and a 2 in F1

You can adjust as required.

---

[kharder]

That solved my problem... Thank you Bryan.