M
MH
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:
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: