Pulling Data From Sheet To Sheet Based on Text

Ok, I just got about 250 spreadsheets that has data but it isn't in a usable format and I need to pull it to 1 sheet. Most of the data is on a line that end with a specific character string and the data. How do I do this?

Your post is lacking in details, but perhaps you can adapt this bit of code as a start. See attached for demo.

Please Login or Register  to view this content.