Concatenate Rows depending on cell value in rows

  • Thread starter Thread starter Pman
  • Start date Start date
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
 
I forgot to mention that the original rows from which the data is
concatenated would have to be deleted.

Thanks.
 
Back
Top