If I got 1000 records and in-between each row record there is a blank row. Is there any shortcut to remove the blank rows in-between them so i'm able to use the auto filter function? Or able to transfer all the records over to another excel sheet with no blank row. Any help will be much appreciated.
I dont want to spend my time removing the blank row one by one. Too time consuming. What if i got 10000 records?
Select the columns first > then Autofilter > blanks > then select the filtered rows and delete
VBA Noob
_________________________________________
Credo Elvem ipsum etian vivere
_________________________________________
A message for cross posters
Please remember to wrap code.
Forum Rules
Please add to your signature if you found this link helpful. Excel links !!!
wow... Thanks!!! It helps me
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks