I have a set of data as follows:
Column names in the first row of columns B:G
Column B: Employee Number (unique ID)
Column C: Name
Columns D:G: Either blank or contain a number
Data begins on the 2nd row of each column
I'm on excel 2010 and looking for a macro that will copy any rows from a table (that could change in length) that have a number in either column D,E,F, or G and create a new sheet and place those rows (along with the original column headings) on that sheet in a table.
Does anyone know the code for a macro that could accomplish this? I only know one that does it based on filtering one column, but in this case there are 4 that could possibly have values in them.
Any help would be much appreciated - Thanks in advance
Column names in the first row of columns B:G
Column B: Employee Number (unique ID)
Column C: Name
Columns D:G: Either blank or contain a number
Data begins on the 2nd row of each column
I'm on excel 2010 and looking for a macro that will copy any rows from a table (that could change in length) that have a number in either column D,E,F, or G and create a new sheet and place those rows (along with the original column headings) on that sheet in a table.
Does anyone know the code for a macro that could accomplish this? I only know one that does it based on filtering one column, but in this case there are 4 that could possibly have values in them.
Any help would be much appreciated - Thanks in advance
