Hi all,
I have not used macros before, but cant figure out another way to solve my problem.
I have a database with a column marked "turf" some of these cells have a number, others "bad". The data is based on the following 19 cells, so the data cannot be sorted. I would like to find cells where "turf">13 and then cut it and the next 19 rows of data and paste them onto a new sheet. Each subsequent set would also be pasted onto a new sheet.
Thanks,
Kris
I have not used macros before, but cant figure out another way to solve my problem.
I have a database with a column marked "turf" some of these cells have a number, others "bad". The data is based on the following 19 cells, so the data cannot be sorted. I would like to find cells where "turf">13 and then cut it and the next 19 rows of data and paste them onto a new sheet. Each subsequent set would also be pasted onto a new sheet.
Thanks,
Kris