Microsoft Office Forums

Go Back   Microsoft Office Forums > >
Reload this Page Adding names of users from one column to another and color change to annual cap Adding names of users from one column to another and color change to annual cap
Register FAQ

Reply
 
Thread Tools Display Modes
  #1  
Old 04-27-2017, 12:26 PM
cmgtlg cmgtlg is offline Adding names of users from one column to another and color change to annual cap Windows 7 32bit Adding names of users from one column to another and color change to annual cap Office 2013
Novice
Adding names of users from one column to another and color change to annual cap 		 
Join Date: Dec 2014
Location: New York
Posts: 5
cmgtlg is on a distinguished road
Default
Sample ALM_Core_2017-18 (Detail).xlsxPlease see attached updated sheets.

I've also noticed that when typing the user name in Column B, some of the items in Column C are not coming through correctly.

So sorry for all of this, it seems the more I try to get what I want, something else happens.

Thank you!
Last edited by cmgtlg; 04-27-2017 at 12:28 PM. Reason: added attachment
Reply With Quote
  #2  
Old 04-27-2017, 10:22 PM
xor xor is offline Adding names of users from one column to another and color change to annual cap Windows 10 Adding names of users from one column to another and color change to annual cap Office 2016
Expert
  
Join Date: Oct 2015
Posts: 1,101
xor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to all
Default
In sheet Apr 17 I have shown a possible formula in column C. Note that Supervisor and user are defined names (Press Formulas on the Ribbon, then Name Manager). I have also added an IFERROR to your formulas in columns F and J. You can delete the IFERROR construction again if you want to see the error messages. If you like what I have done you can make something similar in sheets May 17 and Jun 17.

I hope Q1 now shows what you expected.
Attached Files
File Type: xlsx ALM_Core_2017-18.xlsx (96.3 KB, 13 views)
Reply With Quote
  #3  
Old 04-28-2017, 05:46 AM
cmgtlg cmgtlg is offline Adding names of users from one column to another and color change to annual cap Windows 7 32bit Adding names of users from one column to another and color change to annual cap Office 2013
Novice
Adding names of users from one column to another and color change to annual cap 		 
Join Date: Dec 2014
Location: New York
Posts: 5
cmgtlg is on a distinguished road
Default
Thank you!
Reply With Quote
Reply

« Previous Thread | Next Thread »


Similar Threads
Thread Thread Starter Forum Replies Last Post
Read multiple xml files in excel - Column names and Tag - Column alignment sumshen Excel Programming 0 04-17-2017 12:55 AM
Adding names of users from one column to another and color change to annual cap Tool to know color names - powerpoint Mac - Accessibility zaddig PowerPoint 1 11-05-2016 03:12 AM
Color Coding Users in Shared Calendar reyrey1332 Outlook 0 08-26-2014 07:03 AM
Adding names to sheet for printing WV8VFD Excel 4 12-01-2013 11:02 PM
Adding names of users from one column to another and color change to annual cap matching names in column A with names in column C bob999999 Excel 1 04-28-2013 11:21 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 12:14 PM.

Contact Us - Privacy Statement - Top

Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft