Hi,
I have a worksheet that requires a unique ID in column B for each row that doesn't ever change once it's applied. I would like to concatenate the contents of column A along with a unique identifier value (It can be sequential numeric and doesn't need to be more than 4 characters long) Example: CSW-0415 where column A = CSW. Since rows will be both added and deleted from the worksheet, it has to never change the values once they are assigned. Can this be done using a macro or vba using a button?
I have a worksheet that requires a unique ID in column B for each row that doesn't ever change once it's applied. I would like to concatenate the contents of column A along with a unique identifier value (It can be sequential numeric and doesn't need to be more than 4 characters long) Example: CSW-0415 where column A = CSW. Since rows will be both added and deleted from the worksheet, it has to never change the values once they are assigned. Can this be done using a macro or vba using a button?