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
Bookmarks