Hello friends,
I have a report that I receive in CSV, and I need to format it in a very specific way. I need to copy the data from tab A (csv) to tab B (vertical).
TAB CSV
tabA.png
TAB vertical
tabB.png
Basically, the macro has to create a new row for each category (in rows) for each branch (in columns) adding the date and the branch name.
I don't know to create a loop that copies all the data and when the last row is empty, it jumps to the next column until the last column is empty.
Please Login or Register to view this content.
Bookmarks