whitebread136
New Member
- Joined
- Aug 8, 2014
- Messages
- 3
I have a very cumbersome Macro set up that I know is unnecessarily long. It takes about 25 minutes to run and I finally have some time to look at making it more concise.
Basically all I need the macro to do is enter two values into cells A1 and A2 (these are inputs to a formula) and then have it copy and paste the result in cell A3 to B1. I need this process to repeat a few hundred time but with different values for A1 and A2 each time and I need the result to paste below the preceding result (so have a string of results from B1 down to B1000). I would appreciate any help. Thanks
Basically all I need the macro to do is enter two values into cells A1 and A2 (these are inputs to a formula) and then have it copy and paste the result in cell A3 to B1. I need this process to repeat a few hundred time but with different values for A1 and A2 each time and I need the result to paste below the preceding result (so have a string of results from B1 down to B1000). I would appreciate any help. Thanks