conditional addition of row

[MNJ]

Hi all,
really important question here. I was wondering if i could add row on Sheet Summary, if sheets A,B,C,D have a particular code running.

Meaning, if macro : Addmaterial runs, a row will be added on sheet summary. if the macro runs twice, 2 rows will be added to sheet summary.
Here's a twist, the values from sheet A has a range on sheet summary. As for all the sheets. so the row must be added to the according range


Thanks alot.

[Bob Phillips]

Adding a row is trivial.

Understanding what you mean by '... Here's a twist, the values from sheet A has a range on sheet summary. As for all the sheets. so the row must be added to the according range ...' is not trivial.

Can you elaborate?

[MNJ]

hi, pls look at my attached workbook for reference.


Thanks alot.

[lucas]

2 questions:
can you do away with the merged cells..
can you have a space between the sections on the summary sheet?

[MNJ]

Hi,
Many thanks for your prompt reply.

I know merge cells are a hassle. So i'm willing todo away with it. Yes, and they can before a blank row in between the sections.

Many thanks in advance.