VBA, IF THEN, SELECT CASE or ...

[sylwester.cz]

Hello All,

First of all Happy Easter to all of you!

I am a beginner in VBA and mostly self learner (using various examples if this forum and other internet sources). Currently I need to write a code however I faced a wall and I am stucked there. The code you will see in the VBA editor took me few hours to write, it is quite tough for me still.

Anyway, I hope you can help me to find a good solution. Short explanation:

Data table is in "Revenues" sheet. Currently there are 4 columns (from "I" to "L") with different revenues values for each month, Rev1, Rev2, Rev3 and Rev4.
- If there is a value in cell for example "I3" then it should copy the rage "B3:H3" and also that value in I3 + preferably column heading (as it is show in "desired outcome" sheet).
- then there is another value for Jan in cell "J3". Again, range "B3:H3" and that value in J3 + preferably column heading.
- and so on..

Link to the excel file: Download project.xlsm from Sendspace.com - send big files the easy way

You will notice that my macro is far away from the desired result. Any help will be very appreciated.

Thank you in advance!
Sylwester

 

[sylwester.cz]

Arghhh of course! I have missed that detail. Thank you once again for quick reply. I really appreciate it.

 

[par60056]

Glad to help.

Always the simple things you overlook.