I am a VBA beginner and I need your help to solve a problem that I will explain in detail below.
Suppose I have a table like this in an Excel sheet called “Merged” contained in “Foglio1.xlsx” Workbook. This table was obtained by merging together four different bank statements of two different companies on a given day. In Column B I have the name of the company. In Column D I have the IBAN of the bank account. In Column L I have the Amount in Thousands of the transaction. In Column N I have my own - defined Category of the transaction. In Column P I have the value day of the transaction. See the following picture.
What I need to do is to find a VBA - programmatic way to do the following:
1) Compute the sum of the Amounts in Thousands by IBAN, Category and Value Day.
2) Copy and paste all the sums from point 1 to an Excel sheet called “Summary Report” contained in an Excel workbook called “Foglio2”. The Summary Report sheet looks like in the following picture. In Column B I have the IBAN of the account. In Column I I have the three criteria by which the transactions need to be summed. In Columns from J rightwards I need to have reported all the sums of the Amounts In Thousands by Value Day and by Category. To further complicate matters for me, the items from the fields Value Day and Category of the Summary Report sheet can be selected from a Data Validation drop-down menu.
Suppose I have a table like this in an Excel sheet called “Merged” contained in “Foglio1.xlsx” Workbook. This table was obtained by merging together four different bank statements of two different companies on a given day. In Column B I have the name of the company. In Column D I have the IBAN of the bank account. In Column L I have the Amount in Thousands of the transaction. In Column N I have my own - defined Category of the transaction. In Column P I have the value day of the transaction. See the following picture.
What I need to do is to find a VBA - programmatic way to do the following:
1) Compute the sum of the Amounts in Thousands by IBAN, Category and Value Day.
2) Copy and paste all the sums from point 1 to an Excel sheet called “Summary Report” contained in an Excel workbook called “Foglio2”. The Summary Report sheet looks like in the following picture. In Column B I have the IBAN of the account. In Column I I have the three criteria by which the transactions need to be summed. In Columns from J rightwards I need to have reported all the sums of the Amounts In Thousands by Value Day and by Category. To further complicate matters for me, the items from the fields Value Day and Category of the Summary Report sheet can be selected from a Data Validation drop-down menu.
