PDA

View Full Version : conditional addition of row



MNJ
01-29-2007, 06:40 PM
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
01-30-2007, 02:19 AM
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
01-30-2007, 05:37 PM
hi, pls look at my attached workbook for reference. :)


Thanks alot.

lucas
01-30-2007, 06:10 PM
2 questions:
can you do away with the merged cells..
can you have a space between the sections on the summary sheet?

MNJ
01-30-2007, 07:09 PM
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.
:)