allthingstech
New Member
- Joined
- Nov 26, 2016
- Messages
- 4
I have a master list of names with assigned account numbers. (sheet 1, col. A, B respectively)
once that user name is placed on list to be removed, (sheet 2)
I need master list to auto update with new user name and account.
If there is no new user name to input, then place the text "available or vacant in that cell on master list.
Finally, the user name and acct. that is that is removed, I need their info to remain in master list but in different cell...
Any wizards in the house?
once that user name is placed on list to be removed, (sheet 2)
I need master list to auto update with new user name and account.
If there is no new user name to input, then place the text "available or vacant in that cell on master list.
Finally, the user name and acct. that is that is removed, I need their info to remain in master list but in different cell...
Any wizards in the house?
