Data Scraping

Hello all,

I have an issue with the software that our company uses because it does not have extensive reporting features that someone in my position relies on to control a company. So I have found different ways of extracting data from the system and now I need to organize it to make it usable.

I have attached a spreadsheet with a sheet have the raw data in it (this data came from a exported pdf file that I converted to excel using DC Pro). I have also created a macro that searches for key words and then offsets to the data I'm needing, makes a copy and pastes on another sheet, and this all works great.

The problem comes in when there is more than one line item under the Description Cell because my current macro will only grab the data from the first offset cell, which that is what its supposed to do but now I need it to grab all other line items if they exist.

Please run the macro and if you need more clarification just let me know.

That works perfectly, you made the code to work so fast it is blowing my mind. You must have looked at my code and thought this guy is retarded. LOL. Thank you so much for your help, and if you have the time can you give me a breakdown of how your code works, because honestly I don't understand it, if I wanted to modify it, i wouldn't know where to start.

Thanks you again.