Hi, so I have the table below which will change daily:
I need a VBA code to put into a macro:
I want to keep that table where it is but two lines below, to have the headings and all the Team A together. Then a table two lines below that one, with headings and Team B. Etc.
Also, anyway I can change the date to get rid of the 00:00:00?
Really appreciate the help!
Thanks,
P
| local_acc_no | closing_balance | currency | closing_balance_eur | stmt_date | FEED_TYPE | balance | DayCount | Team | Comments |
| Paul | -3,830,439.00 | JPY | -32,700.77 | 15/04/2020 00:00:00 | STM | 43,597,701.00 | 1 | A | Expense |
| Jack | -2,248,520.60 | IDR | -132.17 | 15/04/2020 00:00:00 | STM | -2,248,520.60 | 3 | B | Expense |
| Chris | -1,713,448.18 | USD | -1,571,250.05 | 15/04/2020 00:00:00 | STM | 10,330,502.38 | 2 | A | Expense |
| John | -1,163,793.13 | USD | -1,067,210.57 | 15/04/2020 00:00:00 | STM | 251,530.81 | 1 | A | Expense |
| Steven | -919,493.09 | USD | -843,184.86 | 15/04/2020 00:00:00 | STM | 337,087.79 | 2 | B | Expense |
| Marianne | -6,568.79 | EUR | -6,568.79 | 15/04/2020 00:00:00 | STM | 13,018,289.65 | 2 | B | Expense |
| Mary | -69.80 | RON | -14.44 | 15/04/2020 00:00:00 | STM | -69.80 | 5 | A | Write off |
| Jane | -36.92 | EUR | -36.92 | 15/04/2020 00:00:00 | STM | 0.00 | 31 | A | Write off |
| Julia | -4.00 | ISK | -0.03 | 15/04/2020 00:00:00 | STM | 0.00 | 34 | C | Write off |
| Tony | -1.00 | JPY | -0.01 | 15/04/2020 00:00:00 | STM | 0.00 | 5 | C | Write off |
| Harry | -0.54 | CHF | -0.51 | 15/04/2020 00:00:00 | STM | -0.54 | 29 | A | Write off |
| Sebastian | -0.36 | NOK | -0.03 | 15/04/2020 00:00:00 | STM | 0.05 | 1 | C | Write off |
| Nicola | -0.31 | SEK | -0.03 | 15/04/2020 00:00:00 | STM | -0.31 | 5 | A | Write off |
I need a VBA code to put into a macro:
I want to keep that table where it is but two lines below, to have the headings and all the Team A together. Then a table two lines below that one, with headings and Team B. Etc.
| local_acc_no | closing_balance | currency | closing_balance_eur | stmt_date | FEED_TYPE | balance | DayCount | Team | Comments |
| Paul | -3,830,439.00 | JPY | -32,700.77 | 15/04/2020 00:00:00 | STM | 43,597,701.00 | 1 | A | Expense |
| Chris | -1,713,448.18 | USD | -1,571,250.05 | 15/04/2020 00:00:00 | STM | 10,330,502.38 | 2 | A | Expense |
| John | -1,163,793.13 | USD | -1,067,210.57 | 15/04/2020 00:00:00 | STM | 251,530.81 | 1 | A | Expense |
| local_acc_no | closing_balance | currency | closing_balance_eur | stmt_date | FEED_TYPE | balance | DayCount | Team | Comments |
| Jack | -2,248,520.60 | IDR | -132.17 | 15/04/2020 00:00:00 | STM | -2,248,520.60 | 3 | B | Expense |
| Steven | -919,493.09 | USD | -843,184.86 | 15/04/2020 00:00:00 | STM | 337,087.79 | 2 | B | Expense |
| Marianne | -6,568.79 | EUR | -6,568.79 | 15/04/2020 00:00:00 | STM | 13,018,289.65 | 2 | B | Expense |
Also, anyway I can change the date to get rid of the 00:00:00?
Really appreciate the help!
Thanks,
P
