11-21-2007, 08:17 PM
Looks good but I would also like to have it go back and paste where there is an amount in the array.
date | 11/21/06 | 11/21/07
---------------------------------------------------------
| |
LIST | 100.00 | 110.00 < paste this amount from calculation
COL1 | 75.00 | 82.50 < paste this amount from calculation
COL2 | | < sometimes there will be an amount here.
COL3 | | < sometimes there will be an amount here.
PUB-COST | 50.00 | 55.0 < This would be the new amount I would key.
REP-COST | 50.00 | 55.0
The new amount that I key will be the amount to multiply up from.
and paste new values under the 11/21/07 column
How can I manually enter the 55.00 or whatever the new cost is into the calculation.
Then send the output back to the clipboard to paste.
I really love quick macros, but I have a ways to go to get the full use out of it.
Thanks,
yoz
date | 11/21/06 | 11/21/07
---------------------------------------------------------
| |
LIST | 100.00 | 110.00 < paste this amount from calculation
COL1 | 75.00 | 82.50 < paste this amount from calculation
COL2 | | < sometimes there will be an amount here.
COL3 | | < sometimes there will be an amount here.
PUB-COST | 50.00 | 55.0 < This would be the new amount I would key.
REP-COST | 50.00 | 55.0
The new amount that I key will be the amount to multiply up from.
and paste new values under the 11/21/07 column
How can I manually enter the 55.00 or whatever the new cost is into the calculation.
Then send the output back to the clipboard to paste.
I really love quick macros, but I have a ways to go to get the full use out of it.
Thanks,
yoz
