New user to Macros am slowly gaining experience.
Currently I am using a Macro to copy an entire line then delete out the last letter in the first column of the newly copied line. Additionally, it corrects the formula used to determine the most recent revision. This is efficient but it could be more efficient. Please, see below for current used Macro.
Moderator's note: Please take the time to review our rules. There aren't many, and they are all important. Rule #3 requires code tags. I have added them for you this time because you are a new member. --6StringJazzerPlease Login or Register to view this content.
The letter being deleted is a revision letter essentially a string of 16 numbers (total) that ends in a revision letter. Revision Letters occur alphabetically (A, B, C, etc.).
I am looking for a way to instead of only deleting the letter but change it to the next subsequent letter.
Any and all help is appreciated!
Thank you for your time!
Bookmarks