I've built a macro to pull specific data out of a standardized template. The macro inserts a column into column A of the template sheet with "=B1&C1" formulas in order to create more specific identifiers for use with Vlookups. It turns out some of the cells in B1 and C1 are sometimes the same.
What would I need to do to make my macro say something similar to:
if any cells in column A are duplicates then make the 2nd duplicate cell formula =B1&C1&-1 and then the thrid duplicate =B1&C1&-2 and so on.
Could even add the "-1" to the first duplicate, if that would be easier as long as there are no duplicate cells left.
Thanks for any help,
James
What would I need to do to make my macro say something similar to:
if any cells in column A are duplicates then make the 2nd duplicate cell formula =B1&C1&-1 and then the thrid duplicate =B1&C1&-2 and so on.
Could even add the "-1" to the first duplicate, if that would be easier as long as there are no duplicate cells left.
Thanks for any help,
James