[sesachacha]

I receive a new excel spreadsheet on a daily basis which has one of 20 possible headings in cell A2. One of the tasks that I need to do is run one of 20 macros that are stored within excel by typing a hotkey. The macro that I run is determined by the name of the heading in cell A2.

Using AA, I am attempting to automate the following tasks:

1) Identify the heading name in cell A2 for each spreadsheet.
2) run the corresponding macro using the proper hotkey.
3) should the heading not match any of the 20 headings (for example it was misspelled) then pause the task and prompt me to press the hotkey.
4) once the hotkey is pressed, the task resumes.

Any help in accomplishing this is greatly appreciated.