Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Insert a new row when the criteria is met in the cell above
I have part numbers in a spreadsheet that may appear several times in a
column. I do a sort on these part numbers to get the same part numbers together. I now need to insert a blank row between the different part numbers. (As soon as the part numbers changes I need a blank row inserted) |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Insert a new row when the criteria is met in the cell above
For i = Cells(Rows.Count,"A").End(xlUp).Row To 2 Step -1 If Cells(i,"A").Value < Cells(i-1, "A").Value Then Rows(i).Insert End If Next i -- HTH Bob Phillips (replace xxxx in the email address with gmail if mailing direct) "Firefighter1" wrote in message ... I have part numbers in a spreadsheet that may appear several times in a column. I do a sort on these part numbers to get the same part numbers together. I now need to insert a blank row between the different part numbers. (As soon as the part numbers changes I need a blank row inserted) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Insert text in Cell A1 based on keyword criteria | Charts and Charting in Excel | |||
how do I insert the address of a selected cell into a fixed cell | Excel Discussion (Misc queries) | |||
Urgent date/scheduling calc needed | Excel Worksheet Functions | |||
count cell if value present in every other cell + criteria | Excel Worksheet Functions | |||
"criteria" in a sumif refering to the value in another cell | Excel Discussion (Misc queries) |