Results 1 to 6 of 6

How to insert header row with every change in value in a column

Threaded View

  1. #1
    Registered User
    Join Date
    09-29-2014
    Location
    Lahore Pakistan
    MS-Off Ver
    2010
    Posts
    3

    How to insert header row with every change in value in a column

    Hello,

    I have to insert header row whenever there is a change in value in column A. I have more than 1000 records and it is very time taking activity to insert header row manually.
    Sample data sheet has been attached. please help.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] VBA Insert Column And Add Header On Multiple Sheets
    By hobbiton73 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-27-2014, 10:50 AM
  2. [SOLVED] VBA macro to add header text, insert & copy-down formula, move column
    By shootstill in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-24-2014, 05:44 AM
  3. Can Excel automatically insert the column header as the axis title?
    By galaxytraveler42 in forum Excel Charting & Pivots
    Replies: 11
    Last Post: 09-20-2013, 06:17 AM
  4. [SOLVED] Formula to find header and insert in new column
    By dbracken1 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 12-03-2012, 03:50 AM
  5. Replies: 1
    Last Post: 05-02-2008, 04:57 AM

Tags for this Thread

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