automating macro when cell value changes

[hiswillbedun]

If anyone can help with this, I would buy lunch. I know only very elementary excel. I have been trying to learn macros, but have yet to be successful with it. In column A, I will be entering different data in each row. I would like to run a macro that once the value of a:a changes then it would cause another macro to run. The other macro I want to look to see if there are any duplicates in a:a. If there is a duplicate it will copy columns c-g from the original row and paste it in the row where the duplicate appears.

Is this possible? Or do I need to go back to pen and paper days?

Thank you,

help me.xlsx

[k64]

I can take a look at this, but you're going to want to change your thread title. Thread titles should not contain words like "help" or exclamation marks and should contain key words which will be helpful for searching, like "Performing 2-dimensional lookup on weekday and month." To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you

[k64]

I have a macro that does what you asked. If you change the thread title and reply, I'll post it.

K64

[hiswillbedun]

Thank you k64. I really appreciate it. I have changed title.

[k64]

You're welcome hiswillbedun,
Try putting this code in the worksheet module. (Go to the Visual Basic editor and double click on the sheet in the sidebar.)

Please Login or Register  to view this content.

[k64]

Hello hiswillbedun,

I realized this morning that the code I gave you was a bit sloppy. It will also activate if someone changes a cell in column AA-AZ. Here is modified code:

Please Login or Register  to view this content.