Hi,
I have serveral very large documents with logged data that i want to sort out. But first i need to delete certain rows wich contains for example BE850 and BE410. its a long sting but those are the tag-names that i can use to delete.
Since there is over 800000 rows in each document and it would take forever to split down the files i wonder if there is any way i can get help to make an macro to find and delete those values for me.
I have tried serveral ready macros from different forums but none that can help me (as far as i can see) im no pro on VBA.
And i also understand that Excel don't really like big documents like this because it hangs up if i hapend to do it with some macros i have found but i guess there is something to not refres the screen.
All help would be apreciated since im no pro at this
I have serveral very large documents with logged data that i want to sort out. But first i need to delete certain rows wich contains for example BE850 and BE410. its a long sting but those are the tag-names that i can use to delete.
Since there is over 800000 rows in each document and it would take forever to split down the files i wonder if there is any way i can get help to make an macro to find and delete those values for me.
I have tried serveral ready macros from different forums but none that can help me (as far as i can see) im no pro on VBA.
And i also understand that Excel don't really like big documents like this because it hangs up if i hapend to do it with some macros i have found but i guess there is something to not refres the screen.
All help would be apreciated since im no pro at this