I have a macro coded to create a new sheet, copy from the first sheet, and paste in specific format to the newly created sheet2. My problem is I cannot get column C to truncate at the end of each cell's string; being "..D" or "...D*". Every cell in column C ends in either "D" or "D*" and I need this removed. Any assistance would be helpful.
Code I am currently working with is shown below. I would like to insert the needed code after
CopyPaste_Sheet2.Hide
ActiveWorkbook.Sheets(2).Activate
Thanks for looking at my frustrations.
J.
Bookmarks