Macro for Copying with conditions

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:
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Search files and copy with destination on file 0
Macro help?: move row to other sheet when text is entered in cell 0
Macro not working correctly 3
Conditional Formatting 1
Extract name, address and ph# 8
VBA to Find Key Words in Word doc then Extract Content to Excel.xlsm file 3
Copy and paste to the last row 3
Copying parts of a sheet with macro 7

Top