HI
I am currently writing a code to concatenate data to create warehouse labels. At the minute I am using the concat function however it is throwing up issues when I mail merge to word. The problem is as I use the concat funtion as a continuous code in column M when I mail merge it returns an infinite number of labels as the concat is running the full length of the excel sheet.
I set my concat to only generate information for rows that are TRUE.
I would like to make this a looped VBA code that will only generate info for rows that are TRUE. This would mean there is only data in Column M for cells that are TRUE and not show the concat code in blank rows (if that makes sense). My screenshot shows the concat code still appearing in cell M8 even though there is no data in columns A-L
My current formula is
=IF(A2>0,CONCATENATE($O$3, $P$3, CHAR(10), B2,CHAR(10), L2, CHAR(10),$S$1, D2, CHAR(10), F2, $T$1, $U$1, E2),"")
Please disregard info in columns K and L, these are not needed. The TPO is the purchase order number
Thanks
Dan
I am currently writing a code to concatenate data to create warehouse labels. At the minute I am using the concat function however it is throwing up issues when I mail merge to word. The problem is as I use the concat funtion as a continuous code in column M when I mail merge it returns an infinite number of labels as the concat is running the full length of the excel sheet.
I set my concat to only generate information for rows that are TRUE.
I would like to make this a looped VBA code that will only generate info for rows that are TRUE. This would mean there is only data in Column M for cells that are TRUE and not show the concat code in blank rows (if that makes sense). My screenshot shows the concat code still appearing in cell M8 even though there is no data in columns A-L
My current formula is
=IF(A2>0,CONCATENATE($O$3, $P$3, CHAR(10), B2,CHAR(10), L2, CHAR(10),$S$1, D2, CHAR(10), F2, $T$1, $U$1, E2),"")
Please disregard info in columns K and L, these are not needed. The TPO is the purchase order number
Thanks
Dan