Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
One More Excel inquiry: Secure a column of data
#15
Create a separate file that we'll call a conversion file. Put all identification information (e.g. SSN, Name, Address) into this file. Now add a new column with a newly generated ID number. I can be as simple as a one up counter or a randomly generated number.

In the file to go home, remove all identification fields (the ones you stored on the conversion file), but add the new ID number.

Store the conversion file in a safe place at work; the loan data, with no identification information on it except the new ID number, should be able to go home safely. It should just be a collection of financial data.

When you take the financial file back to work, you can return the personal information from the conversion file.
Reply


Messages In This Thread
Re: One More Excel inquiry: Secure a column of data - by Don C - 05-07-2008, 02:44 AM

Forum Jump:


Users browsing this thread: 1 Guest(s)