VBA wich copies values when a cell changes

[SRA]

Hi,

I'm writing a macro that's supposed to copy the values from a sourcecell into different destinationcells when a certain cell changes it's value. I've got the first part to work (when the particular cell's value changes, the macro copies the values from the sourcecell to the destination) however I don't want the destination cell to be constantly overwritten. When the sourcecell changes for the second time, I want that information to be copied to a cell beneath the first destinationcell.

How can this be done?

Thanks!

[Bishonen]

if for example you have the following:

Please Login or Register  to view this content.

you can replace the pasting part with:

Please Login or Register  to view this content.

[xladept]

In the Worksheet, something like this:

Please Login or Register  to view this content.

Directions for running the routine(s) just supplied

Copy the code to the clipboard

Press ALT + F11 to open the Visual Basic Editor.


Click on the appropriate worksheet from the Insert menu

Type "Option Explicit" then paste the code under it

and you're ready to go!

[SRA]

Thanks alot! This seems to work perfectly!

[SRA]

If I want to copy a range of cells (in stead of just one value) that have changed to another location, how would I do that?

Thanks again

[xladept]

You're welcome!

Maybe:

Please Login or Register  to view this content.

[robertc93]

Hi,

I'm writing a macro that's supposed to copy the values from a sourcecell into different destinationcells when a certain cell changes it's value. I've got the first part to work (when the particular cell's value changes, the macro copies the values from the sourcecell to the destination) however I don't want the destination cell to be constantly overwritten. When the sourcecell changes for the second time, I want that information to be copied to a cell beneath the first destinationcell.

How can this be done?

Thanks!

Hey Man,

I'm trying to do the same as yourself. I was wondering could you please post the code that you used and got working.

Thanks in Advance!!