•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Trying to create a weekly work schedule. Created a table with dropdown menu. How can I reference this table to a separate table that the value has already been chosen?
Our take
Creating an effective weekly work schedule can streamline your team's productivity. In your current setup, you have a weekly table with employee names and dropdown menus for job types. To reference this data in a separate table, you could use functions to count how many times each job type is selected. By populating entries with a '1' for the first selection and a '2' for subsequent selections, you can easily track job assignments. Alternatively, color-coding could visually represent selections for added clarity.
Hello,
I created a weekly table with a list of employee names. I also created a dropdown menu for each field of all the job types to select from.
I am trying to reference this table into a different table with all the job types on 1 column so I know that it has been chosen on any given day. I was thinking it can populate with a '1'
Bonus if the same job is chosen again, then it can populate a '2'. If this is not possible, then perhaps, using different colours?
I will add a photo to give you an idea of what I'm trying to do. Thanks.
[link] [comments]
Read on the original site
Open the publisher's page for the full experience
Related Articles
- Dynamic Calendar with multiple table dataHi I'm trying to create a single monthly calendar that pulls in data from 4 separate tables. The tables need to be separated to keep clients that need followed up with 1. Now, 2. 30 days 3. 60 days 4. 90 days. Is it possible to color coordinate that to the calendar as well? I.e. clients in blue need contacted in 30 days; clients in orange need contacted in 60 days etc. I've made a dynamic Calendar and can get 1 table of data in the calendar working, but not multiple tables. Any help would be appreciated! I need to present to my boss Friday morning. Apologies...this is my first time posting I tried to add the screenshots to the post, but it kept deleting them. So I added them in the comments. I would like the 4 tables to add to the calendar. They may be the same names, so that's why I would like to color code according to which table they are from. submitted by /u/rainbowluck34 [link] [comments]
- How do I create a table with days in the columns, locations in the rows, and program names and times in the cells?I need to create something like this image, without doing it manually (hopefully). I need the days of the week as headings on the x axis, locations on the y axis, and then program name and time of program in the cells. I've tried using a pivot table, but the values field won't show the text only calculations. There are over 5,300 events, but I need it summarized down to this to give to the marketing team. I would also like to be able to edit with additional notes if needed. Any ideas other than copy and pasting this manually into a grid? https://preview.redd.it/fk7n51pmcdyg1.png?width=768&format=png&auto=webp&s=c995a7b9f596e97036d1821acc4d61553c82fab2 submitted by /u/im_8675309 [link] [comments]
- Populate cells depending on the value of a columnHello ! I am trying to find the simplest possible way (if possible) to populate some cells of a table I have. A table right below to make it understandable. https://preview.redd.it/lynysfdnk6zg1.png?width=351&format=png&auto=webp&s=e7d6f65e5831cc8bedcfb354eedb22d3f7de0532 So on this table, I got three persons, that can be present or not overall. If they are, they are "by default" present Monday-Tuesday-Wednesday. If they are absent, absent "by default" on Monday-Tuesday-Wednesday. I would like to have a button or something in lieu of the big "VALIDATE" I wrote, that would fill automatically the Monday-Tuesday-Wednesday cells depending on the "present" value for each person. The important thing is I would like to be able to "pre-populate" the cells, and then maybe overwrite some days (like person 1 would be present by default, but exceptionnally absent on Wed, which I would adjust by hand). Thanks for any help, if any questions are needed please ask ! submitted by /u/EaraNiniel [link] [comments]
Tagged with
#financial modeling with spreadsheets#Excel alternatives for data analysis#rows.com#natural language processing for spreadsheets#generative AI for data analysis#Excel compatibility#Excel alternatives#weekly work schedule#job types#Excel#dropdown menu#employee names#chosen jobs#reference table#populating data#counting selections#workforce planning#table relationships#color coding#daily schedule