excel - filter for specific name, if not present skip to next line of code -
I wrote a column in the name of a person last week to copy the active cells and give them a new Paste in work sheet as person name, it was great as long as the person name was no longer in the data set. Is there a way to keep a list of names and if those names are not in existence, then go ahead? The bulk of this macro was recorded. Aktivevindokskrollklumn = 2 ActiveWindowkskrollklumn = 3 ActiveWindowkskrollklumn = 4 ActiveWindowkskrollklumn = 5 ActiveWindowkskrollklumn = 6 ActiveWindowkskrollklumn = 7 ActiveSheet. Range ("$ A $ 1: $ U $ 188") Autofilter field: = 13, criterion1: = _ "Sober Justin" category ("M32"). Choose active window. Scroll column = 8 active window Scroll column = 9 active window. Scroll column = 10 ActiveWindow.ScrollColumn = 11 ActiveWindow.ScrollColumn = 12 ActiveWindow.ScrollColumn = 13 ActiveWindow.ScrollColumn = 14 ActiveWindow.ScrollColumn = 15 range ( "U1") Choose Range (selection, selection. Finally (xlDown)) S...