•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Automatically transfer data from a monthly duty roster table (3-shift system/7 days) to a weekly table.
Our take
Are you tired of manually transferring data from your monthly duty roster to a weekly schedule? Automating this process can save you time and eliminate errors, especially when managing shifts for a team of 50. With VBA code, you can streamline the creation of your weekly schedule based on your existing monthly table, improving efficiency and accuracy. Keep reading to discover the specific commands you need to learn, and unlock the power of automation for your scheduling tasks.
Hello,
Unfortunately, I'm not very familiar with Excel's VBA code. I'd like to automate the creation of the weekly schedule for about 50 people, based on the monthly schedule where the respective shifts are already defined.
Is it possible to program something like this with VBA code? And could you help me identify the specific commands I need to learn to implement this?
Further information about the original table:
The structure is as follows:
1st row: the date
1st column: the employee names, followed by the shift for each date.
[link] [comments]
Read on the original site
Open the publisher's page for the full experience
Related Articles
- Creating a work schedule visualiserHello! I'd like to take a list of dynamic work shift times, 10:00-14:00, 12:00-18:00, etc, and paste them into column A of a sheet which will visually 'map out' the whole day with conditional formatting. The sheet columns would run from the beginning of the day, say 08:00, hourly, until the end of the day. A shift time of 08:00-12:00 pasted into column A would therefore fill in the cells from column 08:00 to column 12:00. I'm certain this is possible but my research has turned up nothing but incorrect AI slop. Excel version 2602 submitted by /u/Chegolas [link] [comments]
- Creating an Auto Scheduler for my Work’s DepartmentI realize I may go down a rabbit hole and this could potentially take me months or maybe even longer, but that’s fine I just need starting points for my research. My experience: Not a lot. Limited to extremely basic functions (e.g. SUM, IF, AND, OR), conditional formatting, data validation. Willing to delve into VBN but I know that requires basic knowledge of programming. Goal: There’s ~40 people in my department and we have an excel sheet that tracks all the daily tasks that need to be completed. There’s myself and a manager that makes the schedule for our respective sides of the week and it takes us 2-3 hours each week to assign each task one by one until the schedule is filled out. I would like to automate this in some kind of way. Ideas: - Assign a theoretical/average time to complete a task. - Set each task as either an AM or PM shift specific task, and other tasks that can be completed by either shift. - Assign people to a specific shift, and how many hours their shift is and on what days. - If people have planned PTO, being able to update the available analysts that Excel will take into account. - Excel does the work of auto-populating tasks with a person for each task accounting everything above and not assigning tasks that would cumulatively exceed the number of hours they’re at work, as well as averaging the workload between each person. - Dynamic and editable after cells are auto-populated. Truthfully this is not required, but a quality of life. People call out, emergency situations might come up that might require attention over daily tasks, etc. My thought is I can copy the results and paste it into a separate sheet that can be editable as the week goes on. Again I’m sure I have no idea how much work I’m asking for and it may be way above my capabilities, but as you roast me in the comments at least leave something that I can use to help me get started. Appreciate yall. submitted by /u/GoldJomell [link] [comments]
- Monthly tracking workbook I use to track employee sales metrics; Trying to find a way to make the process less labour intensiveTruly having a hard to describing my issue effectively but hoping someone can help. First time posting here and I'm by no means an expert with excel, so please be kind! I have a monthly workbook where I track each employees revenue and other metrics. Every 2 weeks for payroll, I provide a print out of these numbers, and the payroll sheet pulls data from multiple sheets in the workbook. For example, every workbook has a separate sheet for each day of the month, titled "1" through "31". I have pay period sheets, so I'll use one titled "04.02.26 - 04.15.26". Then I'll have the data for each employee pulled from multiple sheets. For example, I use the formula =SUM('2:15'!E3) to pull the sales data from each day of that period for the specific employee. This works quite well. However, when I create a new month's spreadsheet, I have to manually alter this formula for each employee and for each data point (more than just revenue, at least 6 different data points for 7 employees). Is there a way to automate this? For example, a cell or two where I'm able to enter the date range and all of the formulas update to that date range for the corresponding pages? I'm sorry of this post is confusing. Truly it's confusing even typing it! submitted by /u/Ok_Smile9222 [link] [comments]
- Creating an auto-populating visual calendar for multiple departments to view?I coordinate student schedules across multiple hospital units. I log the shifts in an hours log spreadsheet (date, start time, end time, unit, student name, etc.). Every month, I need to send each unit a schedule showing who is coming in and when so they can review and plan coverage. Right now, this part is very manual, and does not lend to tracking any data like how many students on each units, hours, etc., which we need as a department. We have over 100 students each month, so as much automizing as possible would be helpful as its a big process. Ideally, I’d like something that: Pulls directly from the hours log (no retyping or copy/paste) Is easy to read at a glance for unit managers Can handle many units, many months, and many students Lets me filter by unit + month I'm not really an excel genius, and I've been using copilot to help me with some of this and formulations, but It's not providing me with accurate formulas for the actual calendar conversion. If there are any resources on what formulas to use, what platforms that I could maybe look into for how to do this, or just honestly any advice at all. We've gotten the data tracking mostly drafted up and it's able to pull from pivot tables and show the analytics, but the calendar is my biggest hurdle at the moment. submitted by /u/JuggernautFlashy6489 [link] [comments]