+ Reply to Thread
Results 1 to 2 of 2

Need Macro to Find Data in sheet based on User Name

  1. #1
    Registered User
    Join Date
    07-07-2014
    Location
    Birmingham, AL
    MS-Off Ver
    2010
    Posts
    12

    Need Macro to Find Data in sheet based on User Name

    AD_Report.xlsx

    Here is a small sample of the data I am using and its format.

    What I am needing:

    I would like a macro that once a command Button is selected it scans the entire document and for each agent puts the total Percent In Adherence with that agent.

    Example output:

    Carol Jackson 92.45%
    Priscilla Jackson 80.01%
    April Jackson 80.03%


    Ive had very little experience with VB Macros so any assistance would be awesome!

  2. #2
    Forum Contributor mongoose36's Avatar
    Join Date
    06-10-2013
    Location
    Lincoln
    MS-Off Ver
    Excel 2013
    Posts
    389

    Re: Need Macro to Find Data in sheet based on User Name

    Your data is pretty spread out...but this should work for you. I've tested it and it worked on my test. I've also commented it so you can see the logic and reason for the different lines of code. You will need to create headers in Sheet2 and format it a bit.

    Please Login or Register  to view this content.
    If your questions has been answered to your satisfaction please don't forget to do the following:

    Add Reputation ... and ... Mark Thread as Solved

    Thanks,

    Ma 10:8b Freely you have received; freely give.

+ 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] I'm a new user: Need a macro that will auto paste data from one sheet row to another sheet
    By Daotor in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 10-22-2013, 10:15 AM
  2. [SOLVED] a macro to find number based on user input
    By J4kub in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 04-14-2013, 05:59 PM
  3. a macro to find text based on user input
    By J4kub in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-14-2013, 07:46 AM
  4. As user fills out data sheet, then fill out a results sheet based on data sheet entry
    By clemsoncooz in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 02-13-2012, 03:57 PM
  5. a macro to find text based on user input
    By CDPRINT in forum Excel Programming / VBA / Macros
    Replies: 20
    Last Post: 08-29-2010, 12:23 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