Hi. My situation is this:
Every week, I get a worksheet full of data. Some rows are relevant to me, and some are not. My goal is to quickly create a list of only the relevant rows. (I send this list on to others who are not interested in the process, so for the final product, I don't want it to include the filter or the original data, just the results.)
So right now, my process is:
1) receive the new data
2) paste my formulas in to the rows to the right of the new data
3) filter based on the results of my formulas
4) Copy and paste visible cells into a new worksheet, which will then be sent to co-workers.
This seems a bit labor-intensive to me. I think I shouldn't have to re-paste the same formulas every time. The data that I receive is always in the same format, with the exact same columns (although the number of rows changes).
The obvious solution would be to just re-create my formulas on a separate sheet, referencing the data on the new sheet.
But this has a few problems:
a) On the new sheet, I will still have to filter the data based on the formula results.
b) I don't know how many rows of data there are going to be on the new sheet, so I would have to either put my formulas in every row (taking up too much memory), or put them on too few rows (necessitating the process of finding out how many rows there are on the new sheet, dragging down the formulas, etc.)
Interested in thoughts on my best approach. Happy to answer questions.
Thanks!
Every week, I get a worksheet full of data. Some rows are relevant to me, and some are not. My goal is to quickly create a list of only the relevant rows. (I send this list on to others who are not interested in the process, so for the final product, I don't want it to include the filter or the original data, just the results.)
So right now, my process is:
1) receive the new data
2) paste my formulas in to the rows to the right of the new data
3) filter based on the results of my formulas
4) Copy and paste visible cells into a new worksheet, which will then be sent to co-workers.
This seems a bit labor-intensive to me. I think I shouldn't have to re-paste the same formulas every time. The data that I receive is always in the same format, with the exact same columns (although the number of rows changes).
The obvious solution would be to just re-create my formulas on a separate sheet, referencing the data on the new sheet.
But this has a few problems:
a) On the new sheet, I will still have to filter the data based on the formula results.
b) I don't know how many rows of data there are going to be on the new sheet, so I would have to either put my formulas in every row (taking up too much memory), or put them on too few rows (necessitating the process of finding out how many rows there are on the new sheet, dragging down the formulas, etc.)
Interested in thoughts on my best approach. Happy to answer questions.
Thanks!
