excel - Copy consolidated row data from multiple worksheets where a specific column is populated -
i'm looking copy range of data multiple worksheets single summary sheet based upon specific column being populated. i'm using code found on link : https://msdn.microsoft.com/en-us/library/cc793964(v=office.12).aspx under section entitled 'copying data except column headers multiple worksheets' it works although i've been trying modify code instead of copying whole sheet, copies rows in column 'n' populated. i disabled line of code sets copyrng whole sheet , introduced loop check n column - got program return values present inside column n across sheets need return entire rows of these instances. here modified code section in question : ' if source worksheet not empty , if last ' row >= startrow, copy range. if shlast > 0 , shlast >= startrow 'set range want copy 'set copyrng = sh.range(sh.rows(startrow), sh.rows(shlast)) each cell in sh.range("n4:n...
