+ Reply to Thread
Results 1 to 4 of 4

distribute names equally in front of numbers

  1. #1
    Registered User
    Join Date
    12-17-2011
    Location
    mumbai
    MS-Off Ver
    Excel 2003
    Posts
    4

    Question distribute names equally in front of numbers

    i have one excel file which contains no of calls taken by agents. i want to distribute QC names in front of them equally by using vba.my total count of Call is 9 and my Qc's are 4
    can anybody help me???????

    My data is like this

    Calls taken Qc names
    23 mark
    65 christan
    98 paul
    78 Ginella
    45
    12
    5
    65
    85
    Last edited by rahulbawkar2006; 12-17-2011 at 06:10 PM.

  2. #2
    Forum Guru teylyn's Avatar
    Join Date
    10-28-2008
    Location
    New Zealand
    MS-Off Ver
    Excel 365 Insider Fast
    Posts
    11,364

    Re: distribute names equally in front of numbers

    Hello,

    I'm having difficulties picturing what you want to achieve. Can you post an Excel file with a "before" and manually created "after"?

  3. #3
    Registered User
    Join Date
    12-17-2011
    Location
    mumbai
    MS-Off Ver
    Excel 2003
    Posts
    4

    Re: distribute names equally in front of numbers

    [QUOTE=rahulbawkar2006;2665432]i have one excel file which contains no of calls taken by agents. i want to distribute QC names in front of them equally by using vba.my total count of Call is 9 and my Qc's are 4
    can anybody help me???????

    My data is like this

    Calls taken Qc names
    23 mark
    65 christan
    98 paul
    78 Ginella
    45
    12
    5
    65
    85
    i have attaches the attachment
    Attached Files Attached Files

  4. #4
    Forum Moderator Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    27,533

    Re: distribute names equally in front of numbers

    Hi,

    I suspect you don't need a VBA macro. Try the following in D4 and copied down

    Please Login or Register  to view this content.
    Richard Buttrey

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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