MVB (microsoft visual basic) thru MS Excel...
goto tools,
macros,
Record macros....
while Running macros
you could assign a shortcut to run a macro at cell A1,
by tools, macros, macros, assign a shortcut,
which will do as what you need.