insertrow

Hi, I'm new to writing macros and I'm getting stuck on how to insert partial rows using macro script. What I am trying to do is - Insert cells/partial row in Columns D and E, and shift the rest of the data down if Column G contains the text "DUP" ' QAQCRowInsert Macro Dim c As Range For Each...

Hello, I'm new to VBA. I'd want to insert a row under in two columns only using "yes"/"no" option buttons (as shown). When "yes" is selected a new row will be created. If "no" is selected then the created row will be deleted. Hoping for something simple enough that can be modified & used...

I've got a machine that is out putting 5 data sets in a row. Each data set contains 8 data points. Data set 1 has data in D, E, F, G, H, I, J, K. Data set 2 is in L, M, N, O, P, Q, R, S and so on. This is in sequential order. The next row contains the next 5 data sets and so on. I have...

Hello, I am very new to VBA. For my project I'm trying to insert certain number of rows based on a value input from another sheet. For example, Sheet1 A1 input number is n Then insert 2*(n-1) blank rows between row 1 and row 2. Obviously this doesn't apply...

Hi, I am new to VBA and trying to automate some of my day to day work. So any help would be greatly appreciated. I have searched the forums for what I need but nothing was matching what I need. I have an excel sheet with several rows and in each row there are some months with values others...