+ Reply to Thread
Results 1 to 6 of 6

Repaeting the same value in raw lable

Hybrid View

  1. #1
    Forum Contributor
    Join Date
    11-26-2013
    Location
    India
    MS-Off Ver
    2010
    Posts
    157

    Repaeting the same value in raw lable

    Hi Friends,

    I have a challenge in pviot table i need to repaet the raw lable value as fist feild & and second ..........

    am attaching a file for your reference.

    sheet dta contain pivot data.

    sheet pivot contain the pivot table.

    i need to repaete 1 and the 2 all columns....

    if we are adding more valeus same require all feilds..


    thanks

    Liju
    Attached Files Attached Files

  2. #2
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,485

    Re: Repaeting the same value in raw lable

    Have you tried,

    Design > Layout > Report Layout > Repeat All Item Labels.
    Cheers
    Andy
    www.andypope.info

  3. #3
    Forum Contributor
    Join Date
    11-26-2013
    Location
    India
    MS-Off Ver
    2010
    Posts
    157

    Re: Repaeting the same value in raw lable

    Hi Friend ,

    I tried to mentioned ways for repaeting the item labkes but the final step is not showing on excel find the attached worbook am attacing the snap their.
    Attached Files Attached Files

  4. #4
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,485

    Re: Repaeting the same value in raw lable

    Either correct your profile to say you have xl2007 or mention it in post if the client has xl2007.

    The repeat labels is available in xl2010.

    For alternative in older versions.
    http://datapigtechnologies.com/blog/...le-row-fields/

    You would need to use event code to have this happen automatically.

  5. #5
    Forum Contributor
    Join Date
    11-26-2013
    Location
    India
    MS-Off Ver
    2010
    Posts
    157

    Re: Repaeting the same value in raw lable

    am using the Excel 2007...

  6. #6
    Forum Contributor
    Join Date
    11-26-2013
    Location
    India
    MS-Off Ver
    2010
    Posts
    157

    Re: Repaeting the same value in raw lable

    thank for replied,
    I check the same but the blank column can't fill am using Excel 2007 version

+ 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. Lable on Userform not updating
    By duckboy1981 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-03-2009, 07:54 AM
  2. lable duplicate entries
    By howardjo in forum Excel General
    Replies: 5
    Last Post: 07-24-2008, 07:47 AM
  3. how do i add lable to the points in the chart,
    By arash in forum Excel General
    Replies: 1
    Last Post: 05-11-2006, 08:10 AM
  4. Userform.Lable Variables
    By Roger in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 10-09-2005, 06:05 PM
  5. lable ranges in Excell
    By david in forum Excel General
    Replies: 2
    Last Post: 02-02-2005, 08:06 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