+ Reply to Thread
Results 1 to 4 of 4

List that is manually changed Daily but uses the same 30 names in different rows

  1. #1
    Registered User
    Join Date
    04-28-2020
    Location
    united states
    MS-Off Ver
    365 home
    Posts
    2

    List that is manually changed Daily but uses the same 30 names in different rows

    The sheet in excel is a duty roster for my fire department. Each day the Officer in charge would copy and paste a name from a list below the Roster into the slot that he chooses, thus assigning that person to that particular job assignment. I changed the "autocorrect" in "proofing" to replace the initials, or the first three letters of the person's name because some guys have the same initials. Now the officer in charge can just type JK in the engine 7 officer row, then " Capt. James Kite 113" for example will populate that merged cell. I did this because I couldn't word the question properly on the NET regarding this issue. Question 1: is there a better way by using an excel function? Question 2: is it complicated by obscure excel language? Also I notice that the attachment isnt "clean" like it is on my laptop. boundaries arent recognized if you get my meening.
    Last edited by jbk131; 04-28-2020 at 06:46 PM.

  2. #2
    Forum Guru Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    Excel 2010 on Linux
    Posts
    10,946

    Re: List that is manually changed Daily but uses the same 30 names in different rows

    Administrative note

    Welcome to the forum

    in your haste to solve your problem, you probably missed the yellow banner advising how to get answers faster by posting a sheet ?

    Please take a moment to read it and attach a sheet accordingly.

    Thanks you for helping us help you

  3. #3
    Registered User
    Join Date
    04-28-2020
    Location
    united states
    MS-Off Ver
    365 home
    Posts
    2

    Re: List that is manually changed Daily but uses the same 30 names in different rows

    hows this?
    Attached Files Attached Files

  4. #4
    Forum Expert Logit's Avatar
    Join Date
    12-23-2012
    Location
    North Carolina
    MS-Off Ver
    Excel 2019 Professional Plus - 2007 Enterprise
    Posts
    5,532

    Re: List that is manually changed Daily but uses the same 30 names in different rows

    .
    Your posted workbook does not have any formulas or VBA code.

    What is it you are seeking ? Having your example code will assist.

+ 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. VBA Timestamp only updates if Target cell is manually changed?
    By arwebb0264 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 02-12-2016, 04:58 PM
  2. Code works when cell is manually changed only the first time and not with vba
    By sdl2 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 12-17-2014, 08:18 PM
  3. [SOLVED] Set 2 cells equal, while allowing either one to be manually changed
    By thanhmasterip in forum Excel General
    Replies: 4
    Last Post: 08-20-2014, 01:20 AM
  4. Replies: 4
    Last Post: 02-01-2014, 10:37 PM
  5. Replies: 5
    Last Post: 01-07-2014, 10:45 AM
  6. Replies: 12
    Last Post: 10-17-2012, 08:12 AM
  7. Square shapes change it's names when value in the list changed
    By captcha in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-21-2011, 02:28 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