I have a spreadsheet that is tracking sales number from multiple sales people. Each person has their own tab & all the columns are the same info.
I need a macro to run and copy the full row when "Active" is typed into column F on each sale's person's worksheet. Then paste those rows onto a single Summary worksheet within the same workbook.
Can anyone help??
Also wondering if the rows will auto-populate updated numbers when information is changes on the individuals' worksheets? Or do you have to run the macro again?