Macro for Copying with conditions
 

Hi,

I have almost not much knowledge of making macros except for simple ones.
here is my question
I the sample data below need to copy "SystemA" in the cells below when it
find something written in column B and C and stop at Total in column C after
copying there also and goes down and does the same thing for the next block.

Any help will be appreciated
Thanks
MH


A B C
SystemA
CIVIL
PIPING
CABLE

Total:
SystemB
CIVIL
PIPING
CABLE
TERMINATION
Total:

--
MH