P
Pman
Hi Guys,
Newbie to VBA. Was wondering if I could get some help.
I have an excel sheet with close to 5000 rows and 34 columns. The Column
headings are Community, Publication, Frequency, Zone, Cluster, Ad Caption, Ad
Type, Job Code, Jan Date, Jan $.......Dec Date, Dec $, Total Net$, Total $
plus commission.
My objective is to get a macro that, subject to change in Publication, Zone,
Cluster, Ad Caption and Ad type (i.e. change in columns 2,4,5,6 and 7),
Inserts a line and concatenates the Job codes, and the Dates (columns 9, 11,
13, 15, 17, 19, 21, 23, 25, 27, 29, 31) with a delimiter.
I was wondering if anyone could help. I can further clarify if required by
printscreening my file and uploading a picture to tinypic.
Thanks Guys,
Prash
Newbie to VBA. Was wondering if I could get some help.
I have an excel sheet with close to 5000 rows and 34 columns. The Column
headings are Community, Publication, Frequency, Zone, Cluster, Ad Caption, Ad
Type, Job Code, Jan Date, Jan $.......Dec Date, Dec $, Total Net$, Total $
plus commission.
My objective is to get a macro that, subject to change in Publication, Zone,
Cluster, Ad Caption and Ad type (i.e. change in columns 2,4,5,6 and 7),
Inserts a line and concatenates the Job codes, and the Dates (columns 9, 11,
13, 15, 17, 19, 21, 23, 25, 27, 29, 31) with a delimiter.
I was wondering if anyone could help. I can further clarify if required by
printscreening my file and uploading a picture to tinypic.
Thanks Guys,
Prash