Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
MS Excel: I need section heading rows to remain when autofiltering?
I have a problem in relation to filters in excel. I have a list of about 2000 rows, with the rows being divided into four sections. I want to filter all columns. When i use 'Autofilter' in excel it removes the rows which give the section name once a value has been selected. So in other words...- EoinWALSH
- Thread
- Replies: 4
- Forum: Microsoft: Office
-
Excel Macro; Delete row by looking up 2 different values
Hello, I am looking to write a macro that deletes certain rows on a sheet. I have just written a macro that inserts a row between entries for formatting purposes. However on some occasions there are two accounts listed with the same Account number. When this happens i want to keep the two...- EoinWALSH
- Thread
- Replies: 7
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Excel; Write VBA Macro to delete rows that contain same field value
Hello, I looking to write a macro that deletes certain rows on a sheet. I have just written a macro that inserts a row between entries for formatting purposes. However on some occasions their is two accounts listed with the same Account number. When this happens i want to keep the two accounts...- EoinWALSH
- Thread
- Replies: 3
- Forum: Microsoft: Office
