Copy rows between sheets-conditional
I would like to copy each row of sheet "Raw Data", colunms A-N, that has a
"T" in column 'R' onto a template on another sheet. This other sheet is
titled "Input Table", and I would copy into these same columns.
The number of rows in "Raw Data" could be up to 25,000 rows, and "Input
Table" maxed at 10,000.
Does anyone have recommendations for a reasonably efficient way to do this?
The "Input Table" drives a number of pivot tables and graphs. Ideally, I'd
be able to delete the "Raw Data" content after it copies over the appropriate
rows.
Thank you in advance for any help!
|