copy row with specific name to row 52

H

hai.tio

I'm sorry for this newbie,
'i have an excel sheet with 5 column and 1000 row
'how can i copy the row with value "product" on colum B(productcolumn)
to row 50, 100, 150, ... and new value "nextp" to colum E(ATTN COLUMN)
'in this column, have also another value named "articel", some articel
have less than 9 row
'and how can i insert new row artikel below this < 9 row articel?(the
articel must greater than 9)
'this is my tabel
'no name height width attn
'1 product 1 1
'2 articel 1 1
'3 articel 1 1
'4 packing 1 1
 

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

count format excel vba 1
return multiple values when within range (greater than and less than) 11
VBA - (re-) Set a Table Style 2
Solution to tricky problem of showing exactly Top N rows in Pivottable 0
Excel 2000 formula to dynamically sum adjacent rows and columns whererows inserted/deleted 3
Return a name in the same row 3
Automatically insert rows/copy formula 1
VBA CreateNames (ignores last 5 rows?) 6

Top