Hi!
I have a worksheet that contains a variable amount of excel tables. I have code to filter these tables, but then i want to be able to click on a cell (using a button probably) in any given table in a column that would be named "Add to order:" and have that active row get copied to a separate worksheet, with that worksheet being named by one of the columns of the table called "Vendor". Here is where it gets a little tricky. I only want the columns and header row that the header row cell contains "#copy" to get copied to this sheet, not all of the table columns. Also, if i have multiple rows to copy from within the same table, it only copies the header row one time, any following rows gets only the active row copied to the table. If the "Vendor" is different than the first copied data, then just start a new sheet again using vender name, with the same format as above. Any help with some vba code to do this?
I have a worksheet that contains a variable amount of excel tables. I have code to filter these tables, but then i want to be able to click on a cell (using a button probably) in any given table in a column that would be named "Add to order:" and have that active row get copied to a separate worksheet, with that worksheet being named by one of the columns of the table called "Vendor". Here is where it gets a little tricky. I only want the columns and header row that the header row cell contains "#copy" to get copied to this sheet, not all of the table columns. Also, if i have multiple rows to copy from within the same table, it only copies the header row one time, any following rows gets only the active row copied to the table. If the "Vendor" is different than the first copied data, then just start a new sheet again using vender name, with the same format as above. Any help with some vba code to do this?
