VBA help

[flamingogaslight]

Excel File 1 Name: "TBO 2023 (1)"
Consists of:
Column A with header “NO.”
Column B with header “TicketID"
Column C with header “Closed Acc”
Column D with header “Last Ticket Status"
Column E with header “AccNo"
Column F with header “CIF"
Column G with header “Branch Name"
Column H with header “Sales Code"
Column I with header “RM"
Column J with header “Name"
Column K with header “Segmen"
Column L with header “Open Date Acc"
Column M with header “Perhitungan 30 Hr Kerja"
Column N with header “Perhitungan 90 Hr Kerja"
Column O with header “Perhitungan 120 Hr Kerja"
Column P with header “TBO"
Column Q with header “REKOMENDASI BCO"
Column R with header “KATEGORI TBO"
Column S with header “REMARKS
Column T with header “HOLD_Code_07"
Column U with header "HOLD_Code_01"
Column V with header "HOLD_Code_FLAG"
Column W with header "SALDO SETELAH CLOSE"

Excel File 2 Name: Data CMS (Customer Service) - "TBO (Periode Maret 2023)"
Consists of:
Column B with header “Tgl_Buka” which has text format but has dates in the cells (e.g. 06/03/2023)
Column H with header "TicketID"
Column I with header “LastTicketStatus"
Column L with header "Acct_Branch_NAME"
Column M with header "Acct_Opening_DATE"
Column P with header "Segment_CIF"
Column Q with header “HOLD_Code_07"
Column R with header "HOLD_Code_01"
Column S with header "HOLD_Code_FLAG"
Column V with header "Name"
Column W with header “CIF”
Column AB with header "Comment1"

I would like for there to be a macro assigned button on excel file one that would make it so that when the button is pressed, it will automatically filter column B of excel file 2 based on all the dates in the month of March. Then filter column P of excel file 2 to only show data that contains BUSINESS BANKING, BUSINESS BANKING -NFT and NO TAGGING.

Next, I would like to copy all the data from column H of Excel file 2 to the last row of column B of Excel file 1.

Next, I would like to copy all the data from column I of Excel file 2 to the last row of column D of Excel file 1.

Next, I would like to copy all the data from column W of Excel file 2 to the last row of column F of Excel file 1.

Next, I would like to copy all the data from column L of Excel file 2 to the last row of column G of Excel file 1.

Next, I would like to copy all the data from column V of Excel file 2 to the last row of column J of Excel file 1.

Next, I would like to copy all the data from column P of Excel file 2 to the last row of column K of Excel file 1.

Next, I would like to copy all the data from column M of Excel file 2 to the last row of column L of Excel file 1.

Next, I would like to copy all the data from column AB of Excel file 2 to the last row of column P of Excel file 1

Next, I would like to copy all the data from column Q of Excel file 2 to the last row of column T of Excel file 1.

Next, I would like to copy all the data from column R of Excel file 2 to the last row of column U of Excel file 1.

Next, I would like to copy all the data from column S of Excel file 2 to the last row of column V of Excel file T.

 

[OaklandJim]

This sounds doable. Consider posting a link (using the link icon above the message area) otherwise someone willing to asssit would have to try to recreate your workbook and data...unlikely.

Are you using Excel tables?