Extracting Data in a tabular form using VBA from a system generated excel file

[samihuq]

Hi There,
Here i am once again begging for a solution for an interesting Problem. I receive a system generated file out of which i need to create a report for My Management using Pivot Table. The Generated Report is not ideal for Pivot Table Structure, so i need to convert it to a decent table structure manually and then do the Pivoting. This manual Task is driving me crazy and immensely time consuming. Please help me.

Here is scenery:

First 8 rows of the report has same structure with changing name on the 6th Row and then followed by a table. Now i need to extract the sixth row information under one new column along with the table Data

Can you please help me. This is really running me crazy. I can do the look up if it has one step [From your VBA and Macro Video Tutorial], but i got stuck since it has multiple steps. The variable here is the ANS.

I really really need this help.

Look forward to hear from you.

N.B: I wish i cud send the sample data or a screenshot.

Regards,
Sami

 

[jbeaucaire]

I use this:

EXCEL JEANIE
Use Excel Jeanie to post up some visible HTML examples of the data you're referring to, and perhaps a mockup of the desired results you have in mind.