Hello team,
I'm a newbie at macros, and cannot seem to get what I need...
I have sheet 1 with a huge list of client data: accounts (Column D), product names (Column C), amounts (Column E).
What I am aiming is to create a macro that would copy data from cells located in Columns C, D and E (Sheet 1) to specific cell locations in the Sheet2.
Here's the exact scheme below. The values of cells / cells have to be copied accordingly to the formulas on the picture on the right.
I've been trying to work on this for a a while and cannot seem to be a able to create this, especially line 8 on the left screenshot.
https://ibb.co/ee0Vdo
Could you please kindly assist me in guiding through this?
Thank you!
I'm a newbie at macros, and cannot seem to get what I need...
I have sheet 1 with a huge list of client data: accounts (Column D), product names (Column C), amounts (Column E).
What I am aiming is to create a macro that would copy data from cells located in Columns C, D and E (Sheet 1) to specific cell locations in the Sheet2.
Here's the exact scheme below. The values of cells / cells have to be copied accordingly to the formulas on the picture on the right.
I've been trying to work on this for a a while and cannot seem to be a able to create this, especially line 8 on the left screenshot.
https://ibb.co/ee0Vdo
Could you please kindly assist me in guiding through this?

Thank you!