Need to have many passwords for same excels and used to enter data and accept data.

bal016

New Member
Joined
Jun 6, 2020
Messages
3
Office Version
2013
Platform
Windows
1591428363707.png


One person should enter the data with his password, and his name should come in "issued by" and other person should accept the data with his password and his name should come in "accepted by". Till he accepts, it has to be in different colour. if he rejects it, the data shouldnt disappear, it should change colour, but "L" column should change to rejected.
If a data comes inside or accepted or rejected, a mail has to be circulated inside our group. can someone guide to create such a excel file?
 

Some videos you may like

Excel Facts

Highlight Duplicates
Home, Conditional Formatting, Highlight Cells, Duplicate records, OK to add pink formatting to any duplicates in selected range.

Macropod

Retired Moderator
Joined
Aug 27, 2007
Messages
3,445
And what happens if, say, the accepted data are changed after acceptance, or by the person doing the accepting?
 

bal016

New Member
Joined
Jun 6, 2020
Messages
3
Office Version
2013
Platform
Windows
And what happens if, say, the accepted data are changed after acceptance, or by the person doing the accepting?
only a mail has to be generated but the data has to be stay there in that table
 

Macropod

Retired Moderator
Joined
Aug 27, 2007
Messages
3,445
That really doesn't address either issue. Moreover, now you're introducing the possibility for the data to be changed after the mail has been sent...
 

bal016

New Member
Joined
Jun 6, 2020
Messages
3
Office Version
2013
Platform
Windows
That really doesn't address either issue. Moreover, now you're introducing the possibility for the data to be changed after the mail has been sent...
Ok. now i understood. The data once accepted should be able to be rejected again whenever by the acceptor password. Till accepted or rejected the data entry user should able to edit multiple times with his password. but once accepted/rejected, shouldnt be able to edit that particular row.
 

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
42,786
Office Version
365
Platform
Windows
Cross posted Need to have many passwords for same excels and used to enter data and accept data.

While we do allow Cross-Posting on this site, we do ask that you please mention you are doing so and provide links in each of the threads pointing to the other thread (see rule 13 here along with the explanation: Forum Rules). This way, other members can see what has already been done in regards to a question, and do not waste time working on a question that may already be answered.
 

Watch MrExcel Video

Forum statistics

Threads
1,102,545
Messages
5,487,494
Members
407,603
Latest member
jortronm

This Week's Hot Topics

Top