+ Reply to Thread
Results 1 to 4 of 4

check to see if a person has already been added to the workbook

  1. #1
    Forum Contributor
    Join Date
    04-04-2016
    Location
    dallas tx
    MS-Off Ver
    365 (15.0.5501.1000)
    Posts
    534

    check to see if a person has already been added to the workbook

    This is kind of the same issue I dealt with earlier with trying to add and remove a persons name to every page in a workbook. The codes for adding and removing are working great but as the workbook was already created I am finding that some names had already been added to some pages of the workbook and left off others. Again i come to you experts as my rudimentary coding skill is not up to the task.

    The code needs to look at a cell on my update page for a name, check all the other pages of the workbook to see if that name has been added yet and Let me know if it has. I am not sure what would be better, a list of pages that do have the name or a list of pages that do not?

    Any help would be greatly appreciated.

    Password for the document is "quality"
    Attached Files Attached Files

  2. #2
    Forum Expert Mumps1's Avatar
    Join Date
    10-10-2012
    Location
    Toronto, Canada
    MS-Off Ver
    Excel 2010, 2013
    Posts
    7,821

    Re: check to see if a person has already been added to the workbook

    Try the attached file. In your "Update Page" sheet, I unmerged the cells because merged cells almost always create problems for macros. You should avoid merging cells at all costs. I have created a new sheet named "Sheet1". As you enter a name, last name followed by a comma and space and then first name, in column B of "Update Page" and exit the cell, the macro will check all the other sheets to see if that name already exists. If it does exist, the name and sheet will be listed in "Sheet1".
    Attached Files Attached Files
    Last edited by Mumps1; 05-05-2018 at 08:34 AM.
    You can say "THANK YOU" for help received by clicking the Star symbol at the bottom left of the helper's post.
    Practice makes perfect. I'm very far from perfect so I'm still practising.

  3. #3
    Forum Contributor
    Join Date
    04-04-2016
    Location
    dallas tx
    MS-Off Ver
    365 (15.0.5501.1000)
    Posts
    534

    Re: check to see if a person has already been added to the workbook

    Thank you very much. that works great. How do i look at the code? Its not listed in the macro for this page list. I would like to study it so I can learn how it works.

  4. #4
    Forum Expert Mumps1's Avatar
    Join Date
    10-10-2012
    Location
    Toronto, Canada
    MS-Off Ver
    Excel 2010, 2013
    Posts
    7,821

    Re: check to see if a person has already been added to the workbook

    The macro is a WorkSheet_Change event which is triggered automatically whenever you change a cell in the worksheet. It can be found in the worksheet code module. Right click the tab name for the "Update Page" sheet and then click 'View Code'.

+ 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. Check if Person Belongs Based on Given Information
    By jamesjunkers in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 10-31-2016, 08:47 AM
  2. call macro when newly added check box is checked on different workbook
    By tanvi_kalra in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-22-2016, 08:02 AM
  3. Check for value on a by person by month basis.
    By MRHF in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 08-12-2015, 01:58 PM
  4. VBA to check if the person using excel is the same as loged in the PC
    By Megatronixs in forum Excel Programming / VBA / Macros
    Replies: 18
    Last Post: 02-15-2013, 07:29 AM
  5. add a check box and have weight added when box is checked
    By jamiemchick in forum Excel General
    Replies: 6
    Last Post: 12-17-2010, 03:37 PM
  6. How to add a check box for each sheet added?
    By gshock in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 03-25-2008, 10:58 AM
  7. How to add check boxes as sheets are added?
    By gshock in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-24-2008, 03:50 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