Extracting Data from Report 6 fields with data in variable rows for each field

[Kaushik Joshi]

Hi all,

Tried coding but still seems out of my reach....
Need to extract data from a report of 6 fields.
Each field has data on variable number of rows also with some blank and merged rows in between.
Can some Ninja help me with a Macro to extract data into a simple table format......
Attaching a dummy file...
thanks and Good Day!
From a Rainy Mumbai !

 

[Kaushik Joshi]

Narayan, pls could you check if you can help!

 

[Marc L]

Hi,

can you explain output worksheet structure or attach an output workbook ?
And where to put result ?

So with a well explained need, your chance grows to obtain something !
​

 

[Surendran Setty]

Hi Kaushik,

Created a macro to export purchase data from sheet 1 to sheet 2.
Date and number columns have been formatted to the proper type.

Check the attached file (Export Purchase History.xlsm).
If you have any questions, please let me know.

Regards,
Surendran

 

[Kaushik Joshi]

Hi Surendran,
Thanks a ton for this help. Am a beginner, hence code appears Greek and Latin to me! Will try to figure out though...
Grateful!
Kaushik

 

[Kaushik Joshi]

Hi Surendran,
Works awesomely on bigger size data too. I'd like to learn to do it myself....If you don't mind can you briefly explain logic flow.....if possible, no hurry...

thanks again,
Grateful!
Kaushik