I get an excel sheet every morning with updated lists of concert and show ticket inventory from a ticket broker including:
Event IID
Event
Venue
City
State
Date/Time
Ticket inventory (y/n)
Landing page URL
1.) I would like to make running changes to this list, however would still like to be able to update it every day. Is there a way to do this in Excel, or will i need some sort of software?
2.) I'd like to remove events that aren't relevant and have the file update without those events, or at least maybe highlight the events that have been added.
I know the updating part will need to be done manually, however there are nearly 80,000 events, so i'd like to automate these processes as much as possible.
Short example of list is attached.
Thanks!!
Bookmarks