Hi All,
I am attempting to use numerous macro/ command buttons to copy entire rows in a "category" on the "Index" sheet to another sheet, named "BOM", only IF a 'quantity' above zero is entered in column 'H' and pasted to the "BOM" sheet. Once copied, i would like the rows to be pasted one after the other, without empty rows.
Picture attached. Thank you all!
I am attempting to use numerous macro/ command buttons to copy entire rows in a "category" on the "Index" sheet to another sheet, named "BOM", only IF a 'quantity' above zero is entered in column 'H' and pasted to the "BOM" sheet. Once copied, i would like the rows to be pasted one after the other, without empty rows.
Picture attached. Thank you all!