Forum Discussion
How do I remove unnecessary data without using a filter or deleting it row by row
Hello, I’m trying to clean up my raw data sheet, but I need to remove a lot of data. How do I go about doing this without using a filter or having to delete it row by row. For example, if I have...
If you want to replace the existing data with specific data, VBA is the only way.
And if you want to fetch the specific data from your raw data sheet on to a new sheet, you have several options like you may use Formulas, Advanced Filter, Power Query and VBA as well.
And if you want to fetch the specific data from your raw data sheet on to a new sheet, you have several options like you may use Formulas, Advanced Filter, Power Query and VBA as well.