Here is the scenario. I have a spreadsheet I need 4 different cells copied from. I need to paste them into another form. Instead of doing these 1 by 1, I am trying to make a series of macros that would let me save clipboard to a variable using ctrl1, then paste that variable using alt1. The idea is that I can get all 4 cells of data saved into variables to paste into the other form. like this: Click into cell b1, hit ctrl 1. Click into f1, hit ctrl 2. h1, ctrl3. l1, ctrl 4. Then I would go to my other form select filed, alt1. Next field, alt 2 and so on.
When I try to do this, it will kind of work for the first one, but when I save the variable in the 2nd macro, it overwrites the data and I lose the data from variable %T[1]%.
I need to be able to save 4 text variables for use in the text type macro to "paste" the info from each variable.
Or some other way to accomplish this.
Thanks in advance - I hope this made some sense.