Rosa Prod Posted November 27, 2023 Share Posted November 27, 2023 Hello, i'm looking for a script that take all hanging position in the document and put it in a worksheet. I want to concate all fixture attach to hanging position in just one line of a worksheet. For example : LX1 : ETC source4 (x4), clay Paky (x2)... LX2 : Clay Paky (x3), ETC 575W (x5) Thanks for reply Quote Link to comment
Sam Jones Posted November 28, 2023 Share Posted November 28, 2023 Just a little more clarity. You want a list of hanging Positions, 1 hanging position per row. Yes? You want the cells from column B to list the fixtures attached to that hanging postion. Yes? You want one type of Lighting Device plus the total number of that device type to populate each cell (per device type) to the right of column A. Yes? How do you want to handle Accessories? Quote Link to comment
Rosa Prod Posted November 29, 2023 Author Share Posted November 29, 2023 In fact i don't need the accessories... Quote Link to comment
Rosa Prod Posted November 29, 2023 Author Share Posted November 29, 2023 16 hours ago, Sam Jones said: Just a little more clarity. You want a list of hanging Positions, 1 hanging position per row. Yes? You want the cells from column B to list the fixtures attached to that hanging postion. Yes? You want one type of Lighting Device plus the total number of that device type to populate each cell (per device type) to the right of column A. Yes? How do you want to handle Accessories? It's exactly what i want ! I don't need accessories. Thanks a lot Quote Link to comment
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.