Data manipulation from one sheet to another - VBA

TheWennerWoman

Active Member
Joined
Aug 1, 2019
Messages
270
Office Version
  1. 365
Platform
  1. 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

Assoc RefAssoc NamePracticePractice RefDescriptionAmountRepayment MonthsAmount1st Repayment Date
A34567John DTest OnePR1000PR1000 Loan30001030030/06/2020
A56789James PTest TwoPR1003PR1003 Loan70007100030/06/2020

I need to get this onto a sheet named "To Here" and like this (top row is header)

Assoc RefCompanyCurrencyDateInv NumberValueDescriptionNominalPractice RefEl8 Code
A34567ABC1GBP17/04/2020Loan3000Loan123456PR1000P34567
A34567ABC1GBP30/06/2020Instal 1-300Instal 1123456PR1000P34567
A34567ABC1GBP31/07/2020Instal 2-300Instal 2123456PR1000P34567
A34567ABC1GBP31/08/2020Instal 3-300Instal 3123456PR1000P34567
A34567ABC1GBP30/09/2020Instal 4-300Instal 4123456PR1000P34567
A34567ABC1GBP31/10/2020Instal 5-300Instal 5123456PR1000P34567
A34567ABC1GBP30/11/2020Instal 6-300Instal 6123456PR1000P34567
A34567ABC1GBP31/12/2020Instal 7-300Instal 7123456PR1000P34567
A34567ABC1GBP31/01/2021Instal 8-300Instal 8123456PR1000P34567
A34567ABC1GBP28/02/2021Instal 9-300Instal 9123456PR1000P34567
A34567ABC1GBP31/03/2021Instal 10-300Instal 10123456PR1000P34567
A56789ABC1GBP17/04/2020Loan7000Loan123456PR1003P56789
A56789ABC1GBP30/06/2020Instal 1-1000Instal 1123456PR1003P56789
A56789ABC1GBP31/07/2020Instal 2-1000Instal 2123456PR1003P56789
A56789ABC1GBP31/08/2020Instal 3-1000Instal 3123456PR1003P56789
A56789ABC1GBP30/09/2020Instal 4-1000Instal 4123456PR1003P56789
A56789ABC1GBP31/10/2020Instal 5-1000Instal 5123456PR1003P56789
A56789ABC1GBP30/11/2020Instal 6-1000Instal 6123456PR1003P56789
A56789ABC1GBP31/12/2020Instal 7-1000Instal 7123456PR1003P56789

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.
 

Excel Facts

Using Function Arguments with nested formulas
If writing INDEX in Func. Arguments, type MATCH(. Use the mouse to click inside MATCH in the formula bar. Dialog switches to MATCH.
Can we get clarification on the circled items?

1587120948301.png
 
Upvote 0
Thanks for replying. Assoc Name is the name of the person receiving the loan and practice is the surgery at which he/she practices. Although John D (above) might also do some work for another surgery so he might appear further on down in the list. Likewise, there might be a Jane D who practices at Test One.

Company and currency will always be ABC1 and GBP.
 
Upvote 0
Cross posted Moving data between two sheets VBA

While we do allow Cross-Posting on this site, we do ask that you please mention you are doing so and provide links in each of the threads pointing to the other thread (see rule 13 here along with the explanation: Forum Rules). This way, other members can see what has already been done in regards to a question, and do not waste time working on a question that may already be answered.
 
Upvote 0

Forum statistics

Threads
1,213,544
Messages
6,114,239
Members
448,555
Latest member
RobertJones1986

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top