Script to search an excel sheet based on info from a text file

[darin.m]

Good afternoon,

I have a problem I am hoping you good people can help me with. Please allow me to explain.

Once a week, the receptionist at my work has to downloads a new calendar from a website into Excel. From here, she has to delete several rows (the same every week), several columns (the same every week), and then go through a column (the same every week) and remove select names (the names only change a few times a year) from the column. The names may appear many times in the column (max once per cell. However the rest of the data in that cell remains untouched unless it is another name in the list.
So what I have been trying to do, with no success, is to create a script to save the receptionist about two hours a week.
I know a script can be written to do some of this like the deletion of the rows and columns since they stay the same from week to week. But I would like a script that she can run weekly that would delete the rows and columns and also open a text file in a known location (each line of this file would contain a different name (Last, First)) and then go through the cells in a given column and delete only the names in that text file along with all extra hard returns and double spaces and such leaving all over data in the cells intact.

And on top of all that, it needs to be easy to for her to start and run as she is not very computer savvy. Which is why the list of names is a separate text file that would be very easy for her to change when it is needed.

I myself Love Excel and have been playing trying to get this to work, but I have not been able to.

Can something like this even be done? If so, how and where to start?

Am I even explaining this in a way that makes sense?

Please know that I do know there are ways for some of the experts on this forum to be compensated, i am unable to provide any sort of compensation. But any help you give me would be greatly appreciated.