p45cal,
This is excellent and I think this could be the solution.
Is it possible to put the end date of the rota in A3 and then the macro automatically adjusts the number for the DaysCount?
Thanks for your input, totally amazing!
Hi,
I'm not sure which questions I've not answered for you?
I'm happy for the rota to fill when I click the button (as you have created).
Why do You want to do Yourself that call list? There could be 'a calendar', which shows - who are available any day.
I think it's easy to just have a list...
Sorry I missed the question about how long the rota should be. It's usually only 3 months but I guess it's good that your solution can show a longer period if needed.
I wish to be able to remove or add staff to the call list and the lists for weekdays/weekends to adjust automatically without...
Hi Vletm,
Many thanks for your response and questions. To answer the questions:
1) Staff members are named in the call list. If their name is there, then they are available. This list of names may expand or contract based on the number of staff available.
3) The 2 lists are for weekdays and...
Hi,
Does anyone have a VBA solution for this problem:
I have a staff list with a set order which I use to create a rota. The list rolls over and over filling the spaces in the rota. The positions of the staff (relative to each other) in this list does not change.
When the next new rota is...
HI,
I'm looking for a VBA solution to automatically populate an on call rota please.
The rota should be filled according to the following rules:
Only 1 staff member for each day
Staff member can't be on 2 consecutive days
weekdays are allocated separately from weekend days. This is to ensure...
Hi,
The example only has two lines of data. If you can imagine that each sheet has 10+ lines of data from which 1 or 2 lines are taken to the master file. If the macro runs again at a later date I wouldn't want those same two lines of data to be added in again. Perhaps the solution would be for...
Hi,
I wish to merge sheet data (from multiple worksheets) into one consolidated worksheet (master sheet named POSITIVE) using VBA that runs before saving.
I would like to be able to loop through all of the worksheets except my master sheet and a worksheet named QFT. Ideally I would like to...
Hi,
I have a workbook that is saved as an xlsm but is also saved as a .mht (to publish the workbook). I routinely save the file as .xlsm (this is the master copy) and then as .mht before exiting.
I would like a VBA script that automatically saves a copy of the file in a separate location as...
Hi,
I have a VBA code (that I got from a YouTube tutorial) that will upload dates in to an outlook calendar. This code uploads the info in to the default calendar but I would like for it to upload in to a new calendar that I have set up named "SL Work calendar". Also I plan to have an...
Hi,
I have a need to collate an number of dates that appear in set areas of one worksheet (worksheet name SL) into a list without any gaps. The list that is generated will be used to update an outlook calendar at a later date. I have managed to use array formulas to gather the dates from the...
Yes it should not overwrite.
The TOR files are located on a CD in the D: drive, when these are manually opened a msg box appears stating that file extension is not recognised, accept if trusted. What would need included in the VBA to facilitate this?
After this msg box another appears asking...
OK, so I did as you said above and this can be found in the macros (macro2) in the archive 1.xlsm file. I have also attached a FILES IN FOLDER LOGGER Archiving.xlsm file. This has a macro for finding the files in the folder (in this case on the disc in the drive) and then a second macro to...
I am looking for VBA code to perform a multi-step task extracting data from a TOR file. The TOR files are saved to a disk that I have to then select to open as a read only workbook, select the columns of data I want and copy these in to a new worksheet in my archive master file work book. I...
Hi,
I have a VBA code that creates and names 52 new worksheets as "wk beg" plus the date.
Sub NameSheetsByMonday()
Dim i As Integer
For i = 0 To 51
Sheets("Template").Copy after:=Worksheets(Worksheets.Count)
ActiveSheet.Name = "wk beg " & Format(#1/6/2020# + (i * 7)...