Creating a VBA code to copy a range of cells from one part of a worksheet to another

[amconner]

Good Evening,
I have been working on a contest incentive. The document is attached. The point of the contest is to get our sales team to sell more of a particular product. If they sell one (Column G) in the first month they automatically qualify for points for the month 2 and three of the contest.


However, if they sell one I do not want to have to retype their information (Columns A-F) into month 2(scroll down and you will see it) and month 3.

I need to write a code that states that if Column "G" is 1 then Columns A-F is automatically copied down to months 2 and 3.


I got so lost writing this VBA code. I wanted to know if someone out there can shed some light on my dilemma.

The document is attached.

[jaslake]

Duplicate Thread

http://www.excelforum.com/excel-prog...ing-error.html