HearMePlease
New Member
- Joined
- Jul 26, 2018
- Messages
- 6
Hey Masters,
Good morning! Im a newbies in VBA and want to learn more about it to speed up my work.
I have this file which needs to be sorted everyday. Copy all the movements to each corresponding sites. Please see below the example.
<colgroup><col><col><col span="4"><col><col span="9"></colgroup><tbody>
</tbody>
Can you please help me copypaste values in each store number using VBA codes.
Thank you for your help.
Good morning! Im a newbies in VBA and want to learn more about it to speed up my work.
I have this file which needs to be sorted everyday. Copy all the movements to each corresponding sites. Please see below the example.
Store No_ | Amount Tendered | 0106 | 0109 | 0111 | 0112 | 0117 | 0119 | 0120 | 0123 | 0125 | 0126 | 0127 | 0131 | 0161 | |
0106 | 39,250.00 | ||||||||||||||
0106 | 18,400.00 | ||||||||||||||
0109 | 170,000.00 | ||||||||||||||
0111 | 1,680,200.00 | ||||||||||||||
0112 | 20,000.00 | ||||||||||||||
0117 | 5,000.00 | ||||||||||||||
0119 | 4,400.00 | ||||||||||||||
0120 | 3,950.00 | ||||||||||||||
0123 | 15,150.00 | ||||||||||||||
0125 | 13,650.00 | ||||||||||||||
0126 | 653,700.00 | ||||||||||||||
0127 | 16,500.00 | ||||||||||||||
0131 | 3,000.00 | ||||||||||||||
0161 | 2,000.00 |
<colgroup><col><col><col span="4"><col><col span="9"></colgroup><tbody>
</tbody>
Can you please help me copypaste values in each store number using VBA codes.
Thank you for your help.