Hi,
I would like a macro that can do the following:
- If Columns L and M has just the number 0 in the cell, delete the line.
- Replace the values in Column G so that the text "1 of 1" -> "1", "2 to 2" -> "2", "1 to 3" -> "3", "1 of 10" -> "10". Basically, changing the cell value to the last number.
- Replace Column R's cells if it has something in the text, for example looking for "General Admission" in "Example Super Ticket General Admission" and change it to "GA" or looking for "VIP Admission" in "Test Camp Special VIP Admission" and change it to "VIP".
I've attached before and after XLSX files to show what I mean. Thanks!
Bookmarks