Hi all,
I work for a ticket office and we are sending season ticket booklets in the next few months. We have an excel document with information for each ticket and need to do simple edits throughout the document.
I was curious if it was possible to run a macro to edit a few things:
1) I need to the clear contents (not delete the row) in columns C, D, E, F, and G if column A says "ticket".
2) I need to insert a row at the bottom of each unique group of account numbers. I want to separate the last account number from the rest of the group (as seen in the images I attached).
3) I would like to clear contents of rows M-S if they say the same thing and are next to each other. Like in the image I would like only the first name to be displayed, not the rest of the names underneath it.
I understand these requests are quite specific and may be impossible, but any help would be much appreciated!
Thanks for the help - AD
Bookmarks