Macro To Mask Data In A Sheet

[skf786]

Hi,

i have some customer data in a sheet named 'Data'. I am looking for a macro that will do the following:

1. Replace dates (wherever they are in the sheet) to 1/1/XXXX where the day and months are replaced with 1s while the year remains the same as given in each cell.
2. Social Security Numbers are replaced with 111-11-XXXX where the last 4 digits are random numbers where the rest are placed with 1s.
3. Replace street address with 111 Main while rest of the address remains the same.

Many thanks.

KF

 

[Jeffrey Mahoney]

Do you have these 3 items in special columns or are they scattered throughout?

Dates seem pretty easy. SS# might be easy if they are all the same format, ie. with dashes. Addresses on the other hand are hard. Do you have your street address in a separate cell from the city, state, and zip?

 

[skf786]

Do you have these 3 items in special columns or are they scattered throughout?

Dates seem pretty easy. SS# might be easy if they are all the same format, ie. with dashes. Addresses on the other hand are hard. Do you have your street address in a separate cell from the city, state, and zip?

Yes, dates are with dashes, SS number is in standard format with dashes and street addresses are in separate column.

 

[Jeffrey Mahoney]

You should record a macro that simply replaces all those values.