Hi Guys,
I would like to have the values from the Revenue and cost sheet tranferred to the work sheet respectively:
<tbody>
</tbody><colgroup><col><col><col><col><col span="2"><col><col><col><col span="2"></colgroup>
I would like to have the values from the Revenue and cost sheet tranferred to the work sheet respectively:
Work sheet | ||||||||||
Jan | ||||||||||
Serial number | Process fee | Registration fee | Process cost | Registration cost | ||||||
123525 | 5245+5647-5475 | 5648 | 5245+5647+5475 | 5648 | ||||||
126542 | 5415 | 4512 | ||||||||
124562 | ||||||||||
124851 | ||||||||||
124487 | ||||||||||
589581C | ||||||||||
V15689 | 4526-4562 | 4526+4562 | ||||||||
Revenue sheet | Cost sheet | |||||||||
Serial number | invoice number | Description | Customer | Amount | Serial number | Invoice number | Description | Customer | Amount | |
123525 | 12RD000451 | Process fee_04.18-06.18.2018_SN_123525 | A | 5245 | 123525 | 1562 | Process fee_04.18-06.18.2018_SN_123525 | A | 5245 | |
12MD000541 | registration fee_04.18-06.18.2018_SN_123525 | A | 5648 | 1895 | registration fee_04.18-06.18.2018_SN_123525 | A | 5648 | |||
12RD000457 | Process fee_04.18-06.18.2018_SN_123525 | A | 5647 | 4589 | Process fee_04.18-06.18.2018_SN_123525 | A | 5647 | |||
12RC000548 | Process fee_04.18-06.18.2018_SN_123525 | A | 5475 | MJJK-221 | Process fee_04.18-06.18.2018_SN_123525 | A | 5475 | |||
126542 | 12RD000452 | Process fee_04.18-06.18.2018_SN_126542 | B | 5415 | 126542 | 5652 | Process fee_04.18-06.18.2018_SN_126542 | B | 5415 | |
12MD000542 | registration fee_04.18-06.18.2018_SN_126542 | B | 4512 | 2452 | registration fee_04.18-06.18.2018_SN_126542 | B | 4512 | |||
124562 | 12RD000453 | Process fee_04.18-06.18.2018_SN_124562 | C | 5541 | 124562 | 2154 | Process fee_04.18-06.18.2018_SN_124562 | C | 5541 | |
12MD000543 | registration fee_04.18-06.18.2018_SN_124562 | C | 412 | 5541 | registration fee_04.18-06.18.2018_SN_124562 | C | 412 | |||
124851 | 12RD000454 | Process fee_04.18-06.18.2018_SN_124851 | D | 451 | 124851 | 5412 | Process fee_04.18-06.18.2018_SN_124851 | D | 451 | |
12MD000544 | registration fee_04.18-06.18.2018_SN_124851 | D | 2562 | 4545 | registration fee_04.18-06.18.2018_SN_124851 | D | 2562 | |||
124487 | 12RD000455 | Process fee_04.18-06.18.2018_SN_124487 | E | 5412 | 124487 | 4654 | Process fee_04.18-06.18.2018_SN_124487 | E | 5412 | |
12MD000545 | registration fee_04.18-06.18.2018_SN_124487 | E | 4515 | 45JJa | registration fee_04.18-06.18.2018_SN_124487 | E | 4515 | |||
589581C | 12RD000456 | Process fee_04.18-06.18.2018_SN_589581C | F | 4514 | 589581C | 568 | Process fee_04.18-06.18.2018_SN_589581C | F | 4514 | |
V15689 | 12MD000546 | registration fee_04.18-06.18.2018_SN_V15689 | G | 4526 | V15689 | 2018965 | registration fee_04.18-06.18.2018_SN_V15689 | G | 4526 | |
Any assistance would be greatly appreciated! Thank you ! | 12MC000542 | registration fee_04.18-06.18.2018_SN_V15689 | G | 4562 | 352 | registration fee_04.18-06.18.2018_SN_V15689 | G | 4562 |
<tbody>
</tbody><colgroup><col><col><col><col><col span="2"><col><col><col><col span="2"></colgroup>