Forum Discussion

mrgcav's avatar
mrgcav
Copper Contributor
Oct 20, 2023

Re: How to insert (or create) new rows under every row that meets a certain condition?

khjhzw 

Similar to what I need.
I have a form with 10 rows and columns A-Z (26).  Some files have less than 10 entries. Some files have more than 10 entries.  All cells have a formula with in them.

I do not know VBA but I Need a simple macro to add another row (row 11)when Cells 10A and 10B and 10C all have data. so by the time I fill in 10Z there is a row 11 and the cells in row 11 have a incremented formula.

w

1 Reply

  • peiyezhu's avatar
    peiyezhu
    Bronze Contributor
    If you create a new thread and upload your file for a new question,I guess new discussion can start soon.

Resources