+ Reply to Thread
Results 1 to 10 of 10

Adding labels to column cells

  1. #1
    Registered User
    Join Date
    09-05-2012
    Location
    Türkiye
    MS-Off Ver
    Excel 2013
    Posts
    80

    Adding labels to column cells

    Hello,

    In page1 a1 row has the labels.I want labels text to be added in front of each cell of coloumn.What is needed is on the page2..adding label to column.xlsx
    Last edited by zeroist; 05-20-2014 at 08:58 AM.

  2. #2
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2406
    Posts
    44,662

    Re: Adding labels to column cells

    Is this what you wanted?

    In sheet 2 cell A2 copy:
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    across & down.
    Glenn




    None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU

  3. #3
    Registered User
    Join Date
    09-05-2012
    Location
    Türkiye
    MS-Off Ver
    Excel 2013
    Posts
    80

    Re: Adding labels to column cells

    sorry but it gave errror

  4. #4
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2406
    Posts
    44,662

    Re: Adding labels to column cells

    Are you sure? See attached file. It seemed to work OK for me.
    Attached Files Attached Files

  5. #5
    Registered User
    Join Date
    09-05-2012
    Location
    Türkiye
    MS-Off Ver
    Excel 2013
    Posts
    80

    Re: Adding labels to column cells

    I am sorry I forget to say that empty cell should be passed.It works but not pass the empty cells.

  6. #6
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2406
    Posts
    44,662

    Re: Adding labels to column cells

    OK. We'll get there...

    Formula: copy to clipboard
    Please Login or Register  to view this content.


    Try that.

    If this works, please mark the thread as CLOSED and consider adding reputation by clicking on the star at the foot of this post.

  7. #7
    Registered User
    Join Date
    09-05-2012
    Location
    Türkiye
    MS-Off Ver
    Excel 2013
    Posts
    80

    Re: Adding labels to column cells

    opps something wrong with underlined part
    Please Login or Register  to view this content.

  8. #8
    Registered User
    Join Date
    09-05-2012
    Location
    Türkiye
    MS-Off Ver
    Excel 2013
    Posts
    80

    Re: Adding labels to column cells

    can anyone produce a macro for bulk files plz.

  9. #9
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2406
    Posts
    44,662

    Re: Adding labels to column cells

    Again, I don't see what's wrong. see attached file.
    Attached Files Attached Files

  10. #10
    Registered User
    Join Date
    09-05-2012
    Location
    Türkiye
    MS-Off Ver
    Excel 2013
    Posts
    80

    Re: Adding labels to column cells

    it is now ok.thank you very much and rep..

+ 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. Replies: 2
    Last Post: 03-28-2014, 02:01 PM
  2. Comparing cells in a column and adding result of comparison in cells of adjacent column
    By Lionel welshboy in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-19-2013, 05:37 AM
  3. Adding extra labels to column chart
    By handerson0603 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 04-17-2012, 02:40 PM
  4. Replies: 2
    Last Post: 05-16-2010, 11:23 PM
  5. [SOLVED] Pulling Row and Column labels from other cells.
    By MTUSNOW in forum Excel General
    Replies: 0
    Last Post: 09-07-2005, 07:05 PM

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