TheWennerWoman
Active Member
- Joined
- Aug 1, 2019
- Messages
- 270
- Office Version
- 365
- Platform
- Windows
Hello,
I hope everyone is staying safe.
I am hoping that someone might be able to help, I will try to explain what I am attempting to achieve.
I have a sheet named "From Here". This sheet has nine columns and a sample dataset is as follows (top row is header) - there might be hundreds of records, I am listing just two
I need to get this onto a sheet named "To Here" and like this (top row is header)
Company, Currency and Nominal are all constants, El8 Code is "P" + the five digits from Assoc Ref.
This seems like an impossible task but I know from experience how clever some of you guys are with VBA......so am I asking too much?
Many thanks for reading, everyone please stay safe.
I hope everyone is staying safe.
I am hoping that someone might be able to help, I will try to explain what I am attempting to achieve.
I have a sheet named "From Here". This sheet has nine columns and a sample dataset is as follows (top row is header) - there might be hundreds of records, I am listing just two
Assoc Ref | Assoc Name | Practice | Practice Ref | Description | Amount | Repayment Months | Amount | 1st Repayment Date |
A34567 | John D | Test One | PR1000 | PR1000 Loan | 3000 | 10 | 300 | 30/06/2020 |
A56789 | James P | Test Two | PR1003 | PR1003 Loan | 7000 | 7 | 1000 | 30/06/2020 |
I need to get this onto a sheet named "To Here" and like this (top row is header)
Assoc Ref | Company | Currency | Date | Inv Number | Value | Description | Nominal | Practice Ref | El8 Code |
A34567 | ABC1 | GBP | 17/04/2020 | Loan | 3000 | Loan | 123456 | PR1000 | P34567 |
A34567 | ABC1 | GBP | 30/06/2020 | Instal 1 | -300 | Instal 1 | 123456 | PR1000 | P34567 |
A34567 | ABC1 | GBP | 31/07/2020 | Instal 2 | -300 | Instal 2 | 123456 | PR1000 | P34567 |
A34567 | ABC1 | GBP | 31/08/2020 | Instal 3 | -300 | Instal 3 | 123456 | PR1000 | P34567 |
A34567 | ABC1 | GBP | 30/09/2020 | Instal 4 | -300 | Instal 4 | 123456 | PR1000 | P34567 |
A34567 | ABC1 | GBP | 31/10/2020 | Instal 5 | -300 | Instal 5 | 123456 | PR1000 | P34567 |
A34567 | ABC1 | GBP | 30/11/2020 | Instal 6 | -300 | Instal 6 | 123456 | PR1000 | P34567 |
A34567 | ABC1 | GBP | 31/12/2020 | Instal 7 | -300 | Instal 7 | 123456 | PR1000 | P34567 |
A34567 | ABC1 | GBP | 31/01/2021 | Instal 8 | -300 | Instal 8 | 123456 | PR1000 | P34567 |
A34567 | ABC1 | GBP | 28/02/2021 | Instal 9 | -300 | Instal 9 | 123456 | PR1000 | P34567 |
A34567 | ABC1 | GBP | 31/03/2021 | Instal 10 | -300 | Instal 10 | 123456 | PR1000 | P34567 |
A56789 | ABC1 | GBP | 17/04/2020 | Loan | 7000 | Loan | 123456 | PR1003 | P56789 |
A56789 | ABC1 | GBP | 30/06/2020 | Instal 1 | -1000 | Instal 1 | 123456 | PR1003 | P56789 |
A56789 | ABC1 | GBP | 31/07/2020 | Instal 2 | -1000 | Instal 2 | 123456 | PR1003 | P56789 |
A56789 | ABC1 | GBP | 31/08/2020 | Instal 3 | -1000 | Instal 3 | 123456 | PR1003 | P56789 |
A56789 | ABC1 | GBP | 30/09/2020 | Instal 4 | -1000 | Instal 4 | 123456 | PR1003 | P56789 |
A56789 | ABC1 | GBP | 31/10/2020 | Instal 5 | -1000 | Instal 5 | 123456 | PR1003 | P56789 |
A56789 | ABC1 | GBP | 30/11/2020 | Instal 6 | -1000 | Instal 6 | 123456 | PR1003 | P56789 |
A56789 | ABC1 | GBP | 31/12/2020 | Instal 7 | -1000 | Instal 7 | 123456 | PR1003 | P56789 |
Company, Currency and Nominal are all constants, El8 Code is "P" + the five digits from Assoc Ref.
This seems like an impossible task but I know from experience how clever some of you guys are with VBA......so am I asking too much?
Many thanks for reading, everyone please stay safe.