Automatically adding values to cells...
 

Hi all.

I need some help on this problem;
Hope this make sense; here goes...

Cell D11 has a button with a macro that generates random numbers when clicked.
The generated value is displayed in cell D9 fixed. I want this value
generated to display in cell D12 . When I click the button again the new
value generated must display in D13 and so on. How can I achieve this?

This would be great help...thanks all.

Automatically adding values to cells...
 

Posting the macro would help but this will always write to the first empty
cell (reading up) in column D

Cells(Rows.Count, "D").End(xlUp)(2).Value = x

Mike

"Markv" wrote:

Hi all.

I need some help on this problem;
Hope this make sense; here goes...

Cell D11 has a button with a macro that generates random numbers when clicked.
The generated value is displayed in cell D9 fixed. I want this value
generated to display in cell D12 . When I click the button again the new
value generated must display in D13 and so on. How can I achieve this?

This would be great help...thanks all.

Automatically adding values to cells...
 

thanks but can you clarify your answer in more detail. can I add this line
into a new module?

"Mike H" wrote:

Posting the macro would help but this will always write to the first empty
cell (reading up) in column D

Cells(Rows.Count, "D").End(xlUp)(2).Value = x

Mike

"Markv" wrote:

Hi all.

I need some help on this problem;
Hope this make sense; here goes...

Cell D11 has a button with a macro that generates random numbers when clicked.
The generated value is displayed in cell D9 fixed. I want this value
generated to display in cell D12 . When I click the button again the new
value generated must display in D13 and so on. How can I achieve this?

This would be great help...thanks all.

Automatically adding values to cells...
 

Hi,

On it's own it will do nothing. You have a button that generates a random
number and writes it ti D9 and it's that macro that needs changing. Post the
macro and someone will help.

Mike

"Markv" wrote:

thanks but can you clarify your answer in more detail. can I add this line
into a new module?

"Mike H" wrote:

Posting the macro would help but this will always write to the first empty
cell (reading up) in column D

Cells(Rows.Count, "D").End(xlUp)(2).Value = x

Mike

"Markv" wrote:

Hi all.

I need some help on this problem;
Hope this make sense; here goes...

Cell D11 has a button with a macro that generates random numbers when clicked.
The generated value is displayed in cell D9 fixed. I want this value
generated to display in cell D12 . When I click the button again the new
value generated must display in D13 and so on. How can I achieve this?

This would be great help...thanks all.