Hello,
VBA to merge two worksheets into a new worksheet based on criteria.
Input Sheets : APA, BANK, GA
Output Sheets: APA PAYMENT & GA PAYMENT
I want to do the following:
and...
See example tables below :
INPUT SHEET : APA
<tbody>
</tbody>
INPUT SHEET : GA
<tbody>
</tbody>
INPUT SHEET : BANK
<tbody>
</tbody>
OUTPUT SHEET : APA PAYMENT (vba code)
<tbody>
</tbody>
OUTPUT SHEET : GA PAYMENT (vba code)
<tbody>
</tbody>
Thanks in advance.
VBA to merge two worksheets into a new worksheet based on criteria.
Input Sheets : APA, BANK, GA
Output Sheets: APA PAYMENT & GA PAYMENT
I want to do the following:
- Copy all data from APA sheet and paste to APA Payment
- Copy data that contains "APA" in Column B from BANK sheet and paste to APA Payment
- APA Payment Sort by date and add a subtotal
and...
- Copy all data from GA sheet and paste to GA Payment
- Copy data that contains "GA" in Column B from BANK sheet and paste to GA Payment
- GA Payment Sort by date and add a subtotal
See example tables below :
INPUT SHEET : APA
NUMBER | DATE | CLIENT | DEBIT | CREDIT | DESC | SHEETNAME |
CH1 | 1/9/19 | CUST1 | 1000 | T1 | APA | |
CH2 | 2/9/19 | CUST2 | 2000 | T2 | APA |
<tbody>
</tbody>
INPUT SHEET : GA
NUMBER | DATE | CLIENT | DEBIT | CREDIT | DESC | SHEETNAME |
CH100 | 3/9/19 | CUST10 | 5000 | T10 | GA | |
CH101 | 4/9/19 | CUST11 | 6000 | T11 | GA |
<tbody>
</tbody>
INPUT SHEET : BANK
CHQ | DATE | CLIENT | DEBIT | CREDIT | DESC | SHEETNAME |
BK1 | 5/9/19 | APA | 1000 | CUST1 | BANK | |
BK2 | 6/9/19 | APA | 2000 | CUST2 | BANK | |
BK3 | 6/9/19 | GA | 5000 | CUST10 | BANK |
<tbody>
</tbody>
OUTPUT SHEET : APA PAYMENT (vba code)
INV | DATE | CLIENT | DEBIT | CREDIT | DESC | SHEETNAME |
CH1 | 1/9/19 | CUST1 | 1000 | T1 | APA PAYMENT | |
CH2 | 2/9/19 | CUST2 | 2000 | T2 | APA PAYMENT | |
BK1 | 5/9/19 | APA | 1000 | CUST1 | APA PAYMENT | |
bk2 | 6/9/19 | APA | 2000 | CUST2 | APA PAYMENT | |
TOTAL | 3000 | 3000 | APA PAYMENT |
<tbody>
</tbody>
OUTPUT SHEET : GA PAYMENT (vba code)
INV | DATE | CLIENT | DEBIT | CREDIT | DESC | SHEETNAME |
CH100 | 3/9/19 | CUST10 | 5000 | T10 | GA PAYMENT | |
CH101 | 2/9/19 | CUST11 | 6000 | T11 | GA PAYMENT | |
BK3 | 6/9/19 | GA | 5000 | CUST10 | GA PAYMENT | |
TOTAL | 11000 | 5000 | GA PAYMENT |
<tbody>
</tbody>
Thanks in advance.