Hello,
I am trying to create entries in a table based upon the number defined in another table. I have a master project table, I want there to be multiple work locations for each project, number starting at 1. My Project WL(work location) Sheet has Project number and Project description as well as the WL number. There will be a row for each location and a different number of WL based on each project. I have a column to define how many WL need ot be created in the Master Project List table.
Simple solution - Click an action to create a new row in the WL table with the Project number and desc but finding the maximum number already existing for that project and increasing by one. I can not get MAXROW to work for me here, this would basicly end up with clicking the action button 20 times for 20WL in a project which is fine if needed
Best Solution - Would like to enter the number of WL in a column of the project on Master Project List and have a grouped action or automation create the 20 or however many rows.
Ultimately this is so that each WL is its own entity and all data for that location of that project can be viewed edited (pics and other data), right now I have pics and activity data as a user entered data but its not related to WL only to the project. This would be a good functionality upgrade, any thoughts or help for either solution is appreciated, thanks!