Hello Everyone.
I am new with VBA. I have been watching tons of videos to get some insight on how to do what I want but to no avail, I think there’s multiple solutions to get around this, but I lack the knowledge.
I want to get my “Journal Entry workbook” (I’ll call this “Workbook1”) to auto-populate taking some specific information from another workbook (I’ll call this “Workbook2”) that contains the credit card transactions for the first 2 weeks of the month of several Cardholders in individual Sheets each one (I'll call each sheet "Name1, "Name2", "Name3").
Since this is on a semimonthly basis, I also need to be able to update Workbook1 with the remaining transactions from Workbook3 (which will be the same as Workbook2 but with the remaining transactions of the month) without affecting the previous information already inserted in Workbook1 from Workbook2, so this last part will need to be inserted above of the previous information for each cardholder in Workbook1.
Example
Workbook2 with individual Sheets: Name1, "Name2", "Name3. Cells highlighted in blue need to be copied and inserted in a specif place in Workbook1 for each cardholder:
Copy D6:D11 from Name1 and insert them in Workbook1 above A3.
Copy E6:E11 from Name1 and insert them in Workbook1 above L3.
Copy F6:F11 from Name1 and insert them in Workbook1 above J3.
Copy G6:G11 from Name1 and insert them in Workbook1 above G3.
Copy I6:I11 from Name1 and insert them in Workbook1 above K3.
Copy D6:D14 from Name2 and insert them in Workbook1 above A7.
Copy E6:E14 from Name2 and insert them in Workbook1 above L7.
Copy F6:F14 from Name2 and insert them in Workbook1 above J7.
Copy G6:G14 from Name2 and insert them in Workbook1 above G7.
Copy I6:I14 from Name2 and insert them in Workbook1 above K7.
Copy D6:D14 from Name2 and insert them in Workbook1 above A11.
Copy E6:E14 from Name2 and insert them in Workbook1 above L11.
Copy F6:F14 from Name2 and insert them in Workbook1 above J11.
Copy G6:G14 from Name2 and insert them in Workbook1 above G11.
Copy I6:I14 from Name2 and insert them in Workbook1 above K11.
The result should be this:
Note: Transactions for remaining dates of February should be inserted above row3, row13 and row26 respectively.
Thank you so much for help, I have been doing all this manually for over 2 years with over 300 Credit card holders and I am really frustrated not being able to find a solution for this.
I am new with VBA. I have been watching tons of videos to get some insight on how to do what I want but to no avail, I think there’s multiple solutions to get around this, but I lack the knowledge.
I want to get my “Journal Entry workbook” (I’ll call this “Workbook1”) to auto-populate taking some specific information from another workbook (I’ll call this “Workbook2”) that contains the credit card transactions for the first 2 weeks of the month of several Cardholders in individual Sheets each one (I'll call each sheet "Name1, "Name2", "Name3").
Since this is on a semimonthly basis, I also need to be able to update Workbook1 with the remaining transactions from Workbook3 (which will be the same as Workbook2 but with the remaining transactions of the month) without affecting the previous information already inserted in Workbook1 from Workbook2, so this last part will need to be inserted above of the previous information for each cardholder in Workbook1.
Example
Workbook2 with individual Sheets: Name1, "Name2", "Name3. Cells highlighted in blue need to be copied and inserted in a specif place in Workbook1 for each cardholder:
Copy D6:D11 from Name1 and insert them in Workbook1 above A3.
Copy E6:E11 from Name1 and insert them in Workbook1 above L3.
Copy F6:F11 from Name1 and insert them in Workbook1 above J3.
Copy G6:G11 from Name1 and insert them in Workbook1 above G3.
Copy I6:I11 from Name1 and insert them in Workbook1 above K3.
Copy D6:D14 from Name2 and insert them in Workbook1 above A7.
Copy E6:E14 from Name2 and insert them in Workbook1 above L7.
Copy F6:F14 from Name2 and insert them in Workbook1 above J7.
Copy G6:G14 from Name2 and insert them in Workbook1 above G7.
Copy I6:I14 from Name2 and insert them in Workbook1 above K7.
Copy D6:D14 from Name2 and insert them in Workbook1 above A11.
Copy E6:E14 from Name2 and insert them in Workbook1 above L11.
Copy F6:F14 from Name2 and insert them in Workbook1 above J11.
Copy G6:G14 from Name2 and insert them in Workbook1 above G11.
Copy I6:I14 from Name2 and insert them in Workbook1 above K11.
The result should be this:
Note: Transactions for remaining dates of February should be inserted above row3, row13 and row26 respectively.
Thank you so much for help, I have been doing all this manually for over 2 years with over 300 Credit card holders and I am really frustrated not being able to find a solution for this.
