Been using this software for years and have a problem that is outside my experience. I have a macro that I need to program that moves DATA around in Excel as it gets entered.
Essentially when "1" gets entered, it needs to CONTROL+G, TYPE A1, Then CONTROL+DownArrow, then type 1+Enter.
When "2" gets entered, it needs to CONTROL+G, TYPE B1, Then CONTROL+DownArrow, then type 2+Enter.
I can program these independently but I'm sure it can be done neatly in a single macro and not use up 10 to 20 buttons.Second, is how do I nest what is essentially up to 20 triggers in the macro.
THANKS A MILLION For you help!