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
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
Bookmarks