I have a list of so many names and permissions for each name. Each quarter there may be changes to the list. I currently have this in Excel on a Mac. I am looking for a macro? (I don't know how to use Macros); or a perl script to do the following:
Take the list of names and set up a table, with different names in each category of the table. The permissions are so that some of the names may or may not have persmission to be listed in a certain column. No Name can be in more than one column per row.
Names - Permission Level
1 = Can be in any column
2 = Can NOT be in Column 3 (Name3)
3 = Can NOT be in Column 3 or 4 (Name3 or Name4)
Name1 -- Name2 -- Name3 -- Name4
A -- B -- C -- D
E -- F -- G -- A
H -- B -- C -- D
The total number of names on the list is not expected to exceed 20.
If you can do this online in perl/html, where I can edit the names, column headings and row titles, that would be cool. I will also need to be able to print the final list and possibly make changes to the list each quarter. Otherwise I have Excel 2004, vers 11.3 for Mac. and would like it in that format.
If you can send me a demonstration that would be helpful to make sure you understand the project.