+ Reply to Thread
Results 1 to 3 of 3

Simplifying a project tracker

  1. #1
    Registered User
    Join Date
    05-24-2021
    Location
    Bloomington, IN
    MS-Off Ver
    2016
    Posts
    1

    Simplifying a project tracker

    We use excel to track the recurring work we have to do for clients. Generally, we assign a staff member to a particular function of a client and have to type in the staff member's name for each occurrence through 12/31. Is there a way to make it so if I change the staff member in one cell, it would change all of them? We use a shared workbook, so I can't use any macros. This is more to satisfy my curiosity than anything. I have already spent quite some time tinkering. I know I could use an if statement, but we have 12 staff members and roughly 60 recurring client projects, so the if(a1="x", "y".....) would be inconvenient. As an example, Cell A5=Walmart, Cell D5=Bob. This is repeated 52 times through the year, if I change cell D5 to "Jane", I want all the cells below it to change to "Jane" as well, but without affecting D1 through D4. This is normally something you would have to code, but I want to see if anyone knows of any cool functions or features that could get the job done. If not, that's fine too.

  2. #2
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    15,860

    Re: Simplifying a project tracker

    Hi ryuzukai and welcome to the forum,

    If you wanted to change all "John" to "Jane" then using the Search and Replace dialog would be my first choice. If you only wanted to change some of them, I think you'd need to do them manually.
    One test is worth a thousand opinions.
    Click the * Add Reputation below to say thanks.

  3. #3
    Forum Contributor
    Join Date
    05-18-2021
    Location
    London, Ontario
    MS-Off Ver
    365
    Posts
    113

    Re: Simplifying a project tracker

    not sure if you're aware of this shortcut but if you typed John into the cell at the top row then double click on the bottom right of that cell, it should fill in every cell of that column with John

+ 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. multi project time tracker VBA
    By Sambuddy in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-12-2019, 03:43 AM
  2. Project tracker automation
    By hassanm in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-09-2017, 05:39 PM
  3. Creating a project tracker
    By sorensjp in forum Excel General
    Replies: 8
    Last Post: 01-17-2017, 05:45 AM
  4. [SOLVED] Project supplies tracker
    By makinmomb in forum Excel Formulas & Functions
    Replies: 15
    Last Post: 04-12-2014, 12:55 PM
  5. [SOLVED] Project Timeline Tracker
    By AnnaG87 in forum Excel General
    Replies: 1
    Last Post: 04-30-2013, 11:39 PM
  6. Replies: 0
    Last Post: 06-14-2012, 02:49 PM
  7. Need help with excel Project tracker Macro
    By david.snellen in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-16-2010, 09:47 AM

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