additionally,

how many columns are you summing?
or are they rows?
is all the data to be searched for the condition below row 6?

you aren't being very clear & i can't decipher what you want....
what i SEE is

article=columnA
total = column B

for each row in worksheet
if range("article")="bike" and
if range("total")= what????? then
sum what?
insert row @ row 5
copy row found to row 6

maybe somebody else can figure it out the way you've got it, but
you've lost me.
susan


On Feb 28, 10:45 am, "Susan" wrote:
columns don't have a height.................
do you mean row height or column width?
item will ALWAYS be added @ row 6?
susan

On Feb 28, 10:11 am, wrote:



How can I make for loop?
the conditions a if total value column height = 5 and column
Article = "bike" then copy second row to row 6 (therefore 1 row
added between file 5 and 6)
thanks for your response- Hide quoted text -

- Show quoted text -