I have branch Names in Col A. I would like a macro to copy these branch names in the first blank Column and the row just below the header and these must copied up until the first blank row applicable for the branch name . The text "Branch" must be inserted next to the header in the first blank column
I have attached sample data and shown what the data must look like on sheet "Final" after running the macro
Your assistance is most appreciated
Bookmarks