I need a change event macro that fires any time there is a change on
the range G11:G30. I need to the macro to take the name in the G
column and make it the name of the 4 cells directly to the right (H-K).
If someone can figure out how to do that for me that would be great.


G H I ....K
11 Cars Ford Ranger BMW
12 Movies Harry Potter Red Eye
.... ... ... ...
.... ... ... ...
.... ... ... ...
.... ... ... ...
.... ... ... ...
30 Computers Dell IBM