Hi All,

I have a formula in cell that I would like to add to my VBA code, the formula takes data from other workbooks and combines in one Master document, in 4 of these cells I have project numbers that I need to combine, the formula I am using at the moment to merge the cells and add separators is
Please Login or Register  to view this content.
DA2 = 2
DB2 = 10
DC2 = 252
DD2 = 1
the output I want is PJ02-0010-0252-01

Is it possible to add the formula to vba that can do this for me so it automatically merges the cells and adds the seperators when the DA,DB,DC and DD cells are populated, then move to the next line?

The full code is

Please Login or Register  to view this content.