Fairly noob here.
I have a list of Person names on another sheet. I want to automate building a separate monthly trend chart for each person and paste them all onto a new sheet, one right after the other. Will this code work?
I have a list of Person names on another sheet. I want to automate building a separate monthly trend chart for each person and paste them all onto a new sheet, one right after the other. Will this code work?
VBA Code:
Worksheets("Report").Range("A4").Value = Agent
Call createChart("Report ", "B3:N23", File2)
.ChartArea.Copy
End With
ws.Range("A4").PasteSpecial xlPasteValues