Hi Guys,

I have this excel file, I want to do :

Export the ERPdata into Output for each table skipping the lines in between (4 lines) and redo it until the end.

For each table there is a zone (EAST, WEST, ...) and I want to populate the last column in OUTPUT with the good zone.

I tried copy pasting table and using a combination of astRow = sht.Cells(sht.Rows.Count, "A").End(xlUp).Row + offset to skip a certain number of lines but the problem is though overal...

Thanks a lot for our help.

A - prepare structured data .xlsm