I am working on a time sheet for my company. It has cost codes associated with the hours logged for each day. Now that I have issued it to the job foreman, the request I am running into is that each job has a different arrangement of cost codes based on the scope of work and instead of listing all the cost codes for every project, I was trying to make it easier for the foreman and just provide the cost codes associated with their project. (i.e. 100+ possible codes down to a job specific 25 codes). This way it saves time and less of a chance of selecting a code that related to the project.
What that causes me to do is create a new drop down list everytime I create a timesheet for a new project (be it just once at the beginning). While that doesnt seem tedious, there are 20 name rows with 7 days of the week and each day is split in two in case that workers time is split. So that creates 280 drop downs that have to be placed (using the place multiple fields command) each time. Again, not the end of the world but it really works over the computer every time I run that many fields.
Is there a way to enter in a document level script that can be more easily changed and reflected in all the associated drop downs with just a call function? I found the following but I don't think it clearly defines what is needed to do. Plus some of the old links don't work.
Whats nice about that article is that it appears I can list out the full description of the cost codes in the drop down and write in the export value of how it will show up in the cell so I am excited to learn if there is a process to do it. In the mean time, I am going to start working on the script to see if I get anywhere. I realize I could do this before but it was a lot more manual input than writing out the script in excel and having it flash fill all the lines of script, copy and paste.