Use dropdown to copy cell groups

**wcnwzrd** · 11-25-2008, 04:17 PM

Heres what im trying to do.

Depending on the option selected in cell C44(Violet drop down) either E54:F54 (Oragne Cells) or E57:G98 (Green Cells)will be copied starting at cell A46 (Blue Cell).

The data to be copied is colored the same as the option that will copy it. I know it will take a macro started by the drop down, but have never built macros. Also the macro will need to be copied when that larger group of data is, staying attached to the bottom drop down.

**davesexcel** · 11-25-2008, 09:18 PM

Did you respond to the first thread? Somebody took the time to answer it....

**wcnwzrd** · 11-26-2008, 02:35 PM

i have replied and thanked him for his help. I have limited amount of time online and was not expecting an answer that quickly. I appologize for the oversite.