Forum Discussion
Excel adding and removing data
In my excel sheet I have one tab (Tab A) containing vast amounts of serial numbers, and another tab (Tab B) it which i want to make a sort of shipment list containing extracts from tab A. I am tr...
try it with "=MATCH" or "=VLOOKUP" .
or with VBA if it is not Excel Online.
Here is a small example, you can adapt it in your needs.
Sub_delete_rows()
Application.DisplayAlerts = False
With ActiveSheet
.Range("A1").AutoFilter Field:=3, Criteria1:="x"
.Rows(1).Hidden = True
.UsedRange.SpecialCells(xlCellTypeVisible).Delete
.Rows(1).Hidden = False
.AutoFilterMode = False
End With
Application.DisplayAlerts = True
end sub
Hope I was able to help you with this info.
I know I don't know anything (Socrates)