Dear All,
We have data entry from one spreadsheet (A) to another (B) as below:
(A)
<colgroup><col width="64" span="5" style="width:48pt"> </colgroup><tbody>
</tbody>
(b) Instead of entering the cell as = A1 + B1 + C2 + D5 we need to enter as " = +99 + 99 + 66 + 92,
Is there any quciker way to do it or any possible vba solutions?
Cheers,
Peter
We have data entry from one spreadsheet (A) to another (B) as below:
(A)
a | b | c | d | |
1 | 99 | 99 | 81 | 54 |
2 | 67 | 69 | 66 | 94 |
3 | 50 | 64 | 91 | 57 |
4 | 62 | 59 | 91 | 57 |
5 | 90 | 65 | 65 | 92 |
6 | 63 | 86 | 66 | 62 |
<colgroup><col width="64" span="5" style="width:48pt"> </colgroup><tbody>
</tbody>
(b) Instead of entering the cell as = A1 + B1 + C2 + D5 we need to enter as " = +99 + 99 + 66 + 92,
Is there any quciker way to do it or any possible vba solutions?
Cheers,
Peter