Hi Folks
I have a large csv, and I would like to run a Macro that imports it (say from C:\Test\Test.csv), then allows the user to specify a string via Input Box (or otherwise), and any row not containing that string (in a specific column "G") gets deleted/removed.
I'm having a bit of a nightmare trying to do it with filters, as that leaves the data in there, and I have 6/7 subsequent macros, that seemingly won't play ball if it's filtered.
Any help/advice would be greatly appreciated.
I have a large csv, and I would like to run a Macro that imports it (say from C:\Test\Test.csv), then allows the user to specify a string via Input Box (or otherwise), and any row not containing that string (in a specific column "G") gets deleted/removed.
I'm having a bit of a nightmare trying to do it with filters, as that leaves the data in there, and I have 6/7 subsequent macros, that seemingly won't play ball if it's filtered.
Any help/advice would be greatly appreciated.