Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Over 90% answered within 24 hours! Click here to start participating now! Also, be sure to check out the New User Guide.
I have a spreadsheet with 500 rows of data. Column A has my data of interest. After sorting, column A will have several rows of the data are the same, then it changes. The data in column A are names of employees...I need to know the easiest way to insert a blank Row where those names change other than me changing it all manually...Any ideas?
Name: DerbyDad03 Date: July 20, 2009 at 13:10:47 Pacific
Reply:
Try this...
Sub AddRowAtChange()
myRow = 1
Do Until Cells(myRow + 1, 1) = ""
If Cells(myRow, 1) <> Cells(myRow + 1, 1) Then _
Cells(myRow + 1, 1).EntireRow.Insert
myRow = myRow + 2
Loop
End Sub
0
Response Number 2
Name: Lunger Date: July 22, 2009 at 16:11:52 Pacific
Summary: Not sure if there is a solution to this problem or not, but here's what I'm attempting to do: I've designed a worksheet in which users are able to add aditional rows to different categories by clickin...
Summary: Hi I need to insert a row into a imported data which contains item, year, qty. I need to insert a row for every new item and also on the new insert row to copy a particular row formula ...
Summary: Hi, I think the following code does what you want, inserting new rows between existing rows in your selection (the initial selection must be rows). Then it selects all the new rows. I have not added a...
0 
Problems with Russian Pro...
