+ Reply to Thread
Results 1 to 5 of 5

Copy Branch Names in Header to first Blank Column

  1. #1
    Forum Contributor
    Join Date
    07-12-2018
    Location
    South Africa
    MS-Off Ver
    Office 2021
    Posts
    2,709

    Copy Branch Names in Header to first Blank Column

    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
    Attached Files Attached Files
    Last edited by Howardc1001; 04-01-2020 at 09:56 PM.

  2. #2
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    22,464

    Re: Copy Branch Names in Header to first Blank Column

    Are you sure about "BR3", not "Sothern1" in your final?

  3. #3
    Forum Contributor
    Join Date
    07-12-2018
    Location
    South Africa
    MS-Off Ver
    Office 2021
    Posts
    2,709

    Re: Copy Branch Names in Header to first Blank Column

    My apologies, it should be Sothern1 and not BR3

  4. #4
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    22,464

    Re: Copy Branch Names in Header to first Blank Column

    Then this should do.
    Please Login or Register  to view this content.

  5. #5
    Forum Contributor
    Join Date
    07-12-2018
    Location
    South Africa
    MS-Off Ver
    Office 2021
    Posts
    2,709

    Re: Copy Branch Names in Header to first Blank Column

    Hi Jindon

    Thanks for the help, code works perfectly

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Exctract Unique Branch Names
    By flupsie in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-22-2018, 01:27 AM
  2. Extract column names by searching Row 1 header names?
    By Syfy in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 07-04-2015, 07:27 PM
  3. Replies: 6
    Last Post: 01-08-2014, 01:56 PM
  4. Replies: 1
    Last Post: 10-05-2013, 03:35 PM
  5. Need to copy header row in group to all rows below header; stop if blank and repeate
    By jmcaleer10 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-18-2013, 11:09 AM
  6. [SOLVED] copy column and header names from existing spreadsheet to new spre
    By lbierer in forum Excel - New Users/Basics
    Replies: 2
    Last Post: 07-15-2006, 11:35 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1