gmooney
Active Member
- Joined
- Oct 21, 2004
- Messages
- 252
- Office Version
- 365
- Platform
- Windows
I have an Excel file that has confidential data in it. I want to have a macro or something that will turn the character dimensions of the actual data values of each row into something that is masked and not identifiable. This data could have a column that is about Products and another column that is about geographical locations and have many rows where I want each identical product to be masked to the same name but the next different product masked to a different name and the same thing for the different geographical locations.
Any suggestions?
Any suggestions?