inserting rows

Hi all, I'm a new member so forgive me if this has been answered elsewhere but I have scoured the internet in search of an answer to my problem but I am yet to come up with a solution. Basically the problem is this. I have an IF formula that starts in AH4 that runs the length of Column AH from...

Hello, I was wondering if someone could help me develop a code to insert 300 rows after a specific row. For example I would like to add 300 rows right after row 80 000 in my data set. :) Hope someone will get back to me soon !

I have worksheet where Column A if for Serial Number, Column B for Post, Column for ROPA, Column D for Pay Scale, Column E for DOA, Column F for Pay, Column G for DOTA, Column H for Reason and Column I for Remark. I want automatic insertion of rows on certain conditions. IF any cell of Column =...

I'm new to VBA and am looking for some additional assistance. I saw a previous post similar to my question but it's not working. Here's where I'm at: - A7:N12 is a named range "trailer_req_lanes" A7:n8 are titles - A13:N17 is a named range "trail_prod_queue" A13:N14 are titles - A18:N21 is a...

I am working on small excel vba program that takes Employee time punches, calculates hours, etc. Problem I am having is inserting missing days for the beginning of month. I need a row for each day of the month. If employee did not have a records for that day a blank row with employee name and...

Hi i guys . i am hoping you might be able to help me . I have a data set of 300 points and i want to increase my data range by a factor of 10 . For example if i have Column A with master points A1=10 A2 = 20 A3 = 30 . I would like to be able to automatically enter in the same about of new...

Hi Everyone, I have a table that is provided to me that contains data like the below. Number of rows/columns can vary. <tbody> Site Account Vend1 Vend2 Vend3 Vend4 Vend5 Vend6 Vend7 Vend8 ON 12345 5% 2% 2.25% 3.25% 4% 5% 6% 2% BC 67890 5% 3% 2% 3% 4% 5% 7% 8% </tbody> In this case, I...

Hi - hope you can help . . . I've got some data relating to 1800 individuals, each represented as a row. The way the data has come to me, however, means that for some questions, where a response was not given, I don't have a row. For instance, I'm currently looking at something which starts with...

Hello I'm once again troubling this forum's community with a puzzle that has been driving me crazy for the past 2 days. I wrote a code that has to insert rows when certain conditions are met. The code finds the conditions, reads a number (X) in a row that meets those conditions and inserts X...

I'm trying to figure out how to write the following logic inside a macro: IF W19=Y, THEN INSERT 2 ROWS BELOW R19 IF W19=Y AND X19=Y, THEN INSERT 5 ROWS BELOW R19 Then I would like it to loop to the next row of data and do the same thing (until it gets thru each row of data). For example, if 5...