need help in excel macro

[chantelloo]

what i need is a script respectively a macro.
exmaple: i have column A

what i want is, when i change the value in cell 10A , then the date (today) should bet set in cell 10X
when i change the value in cell 11A, then set in cell 11X.

regards

 

[Naroha]

what i need is a script respectively a macro.
exmaple: i have column A

what i want is, when i change the value in cell 10A , then the date (today) should bet set in cell 10X
when i change the value in cell 11A, then set in cell 11X.

regards

X10=IF(A10<>"",NOW())
this wont work if A10 is empty

 

[chantelloo]

X10=IF(A10<>"",NOW())
this wont work if A10 is empty

t hink , this only works when A10 is empty and then it gets a value.
but what when 10A already have a value, and i just change the value?
will be the event still triggered?

regards

 

[Naroha]

t hink , this only works when A10 is empty and then it gets a value.
but what when 10A already have a value, and i just change the value?
will be the event still triggered?

regards

should be triggered everytime

 

[chantelloo]

should be triggered everytime

yeah, but thats a problem.
i just want the new date when the value changed.
when its everytime triggered, then i will have everytime the date from today when the value is not empty?
or i am wrong?
will test it out.

regards

 

[Naroha]

yeah, but thats a problem.
i just want the new date when the value changed.
when its everytime triggered, then i will have everytime the date from today when the value is not empty?
or i am wrong?
will test it out.

regards

ah damn thats true my bad lol it will continue counting everyday ... heh sorry

 

[SEO Supreme]

Try this:
Record a macro that does follows these steps:

0. Start recording in cell A1. There should be blank cells in column A from A1 up to where you want the content to be displayed.
1. Goes to the last row in column A (shift + down arrow)
2. Goes to the cell next to it
3. Writes Norha's formula: X10=IF(A10<>"",NOW())
4. Goes a cell to the left
5. Goes a cell to the right (so you're on top of the cell with the formula again)
6. Copies the content
7. Pastes it in place as a value
8. Goes a cell to the left
9. Goes to the topmost cell (shift + up arrow) so you're back in cell where you started. This macro would work if there are no empty rows in column A from A1 until where you want the code to be written.

Hope this helps.

 

[chantelloo]

Try this:
Record a macro that does follows these steps:

0. Start recording in cell A1. There should be blank cells in column A from A1 up to where you want the content to be displayed.
1. Goes to the last row in column A (shift + down arrow)
2. Goes to the cell next to it
3. Writes Norha's formula: X10=IF(A10<>"",NOW())
4. Goes a cell to the left
5. Goes a cell to the right (so you're on top of the cell with the formula again)
6. Copies the content
7. Pastes it in place as a value
8. Goes a cell to the left
9. Goes to the topmost cell (shift + up arrow) so you're back in cell where you started. This macro would work if there are no empty rows in column A from A1 until where you want the code to be written.

Hope this helps.

will try this thanks!