I NEED A PROGRAM THAT WOULD SCRAMBLE THE DATA IN COLUMNS OF A SPREADSHEET SUCH AS EXCEL AND PLACE THE DATA BACK INTO THE COLUMN IN A DIFFERENT ORDER.SCRAMBLING THE ORDER IN WHICH THE DATA IS DISPLAYED IN EACH COLUMN AND ROW.
I AM A SECURITY SUPERVISOR FOR A LARGE RETAIL STORE. WE HAVE MANY EMPLOYEES. EACH HAS A LOCKER. SOMETIMES DURING THE HOLIDAY WE GET MORE EMPLOYEES AND THEY MUST SHARE A LOCKER. SOME HAVE TWO TO A LOCKER AND A FEW THREE TO A LOCKER.
FROM TIME TO TIME WE EMPTY AND REASSIGN THE LOCKERS. I NEED A PROGRAM TO SPEED UP THE PROCESS.
COLUMN A WOULD BE NAMES: FIRST AND LAST AND SOMETIMES MORE.
COLUMN B WOULD BE THE LOCKER NUMBERS.
COLUMN C WOULD BE THE COMBINATION NUMBERS.
COLUMN D WOULD BE LOCK NUMBERS: THE REFERENCE NUMBER TO KEEP TRACK OF THE COMBINATION NUMBERS.
COLUMN C AND D MUST ALWAYS CORESPOND. OTHERWISE WE CAN’T OPEN THE LOCKS.
I NEED A PROGRAM THAT WILL SCRAMBLE ANY COLUMN AND PLACE THE DATA INTO A NEW SPREADSHEET. BASICALLY TRANSFERRING THE DATA IN A RANDOM ORDER.
I ALSO NEED IT TO TELL ME THE LOCKER NUMBER THE LOCK WAS ON AND IS ON NOW. THE DATA IN A SIDE BY SIDE COMPARISON. THIS WAY I CAN GO THROUGH THE LIST QUICKLY. LOCKER 1 HAD 555555555 AND NOW IT WILL BE ON LOCKER 20. LOCKER 20 HAD 444444444 AND NOW IT WILL BE ON LOCKER 39. LOCKER 39 HAD 333333333 AND NOW IT IS ON LOCKER 2.
I ALSO WANT TO TRANSFER CERTAIN COLUMNS OF DATA ONTO A FORM.
EXAMPLE FORM:
NAME:______________ LOCKER NUMBER:___________
COMBINATION:______________
I WILL NEED TO TRANSFER EVERY ROW IN A SPREADSHEET TO SUCH A FORM. THUS THE FORMS MUST BE SMALL TO FIT A NUMBER OF FORMS PER PAGE.
THE PROGRAM MUST TRANSFER ROW BY ROW INTO FORM BY FORM.
ALSO I WILL NEED AN ADDITIONAL FORM FOR THE HOLIDAYS WHEN THEY MUST SHARE LOCKERS.
THE ADDED INFOMATION:LOCKER BUDDY:________________
I NEED IT TO BE FLEXIBLE WITH THE TITLES IN THE FORMS. I MUST BE ABLE TO RENAME COLUMNS AND FORM PLACEMENTS.