auto insert

I have data in sheet1 in Column A I have values from 1 to 10000. I want that after every 10th row a new row/cell will be inserted and in column A against the new cell text "NEXT" will be added. What should be the code for this ?? kindly help

Hi, Any help with the following problem would be greatly appreciated. So I have 2 seperate workbooks (not sheets) 1 & 2). Workbook 1 <tbody> Job# Serial code job1 T123 job1 AW5566 job2 T100 job3 T101 job3 T307 job3 T308 job4 T123 job4 AW5566 job4 T200 </tbody> Job...

I need to show the following and I can not figure this out! Scenario 1 I have row 10 filled with data up to column O I have rows 11-24 hidden This 15 row set up is copied down 50 times so the below process would need to be repeated in each of those 15 row sets If column O has a value >0 than I...

Just when I was starting to get a basic grasp for VBA!! Little bit of code: Private Sub Worksheet_Change(ByVal Target As Excel.Range) If Target.Row = [TotalVal1].Row - 1 Then Application.EnableEvents = False [TotalVal1].EntireRow.Insert ActiveCell.Offset(-1...

Hi All, I hope can anyone help me with the below requirement. I have data as below and need to insert one new row whenever number changes. This should happen through macro because my data would be very huge like 500 to 1000 rows so, sometimes it goes beyond this number. Ex:- Column 1 650 650...

Hi, I am new to excel. While searching for help on codes and different ways to simplify my task i came across this forum. would be glad if someone could help me with my problem. I have a huge excel sheet with data more than 100s of rows. it's a common workbook shared by evryone in my company...

I love visiting these forums and reading all of the responses as I have learned so much from it. Unfortunately I have not been able to find this specific solution in the forum yet. I have a range of data A5:R55 and is sorted by ID's in column B. I would like to automatically insert a row...