Monday Help

Good morning all,

So I have a new issue, Shocker with it being a Monday Morning and all. I've been told that I need to change site codes for a number of OU's and change the associated groups which reside either in that OU or somewhere else.

Now

I need to change only the site part of the group, i'm kind of debating deleting and recreating the groups however in the (Likely) event that I'll need to do this again I'm trying to make it self contained.

$OUs = Read-Host "Please enter the OU and Associated groups you'd like to change"

$NewOU = Read-Host "Please enter the new name of the OU and groups"

Foreach ($OU in $OUs){
Get-ADOrganizationalUnit -filter "Name -like $ou" | Set-ADOrganizationalUnit -DisplayName $NewOU }

Get-ADGroup -filter "Name -like $ou"

Open in new window

This is where I've got to and it's pretty shocking, maybe because I broke myself on Friday night and I've still got a headache.

Any hints on how I can do this would be great. I'm still trying to learn the intricacies of PowerShell so please advise rather than giving the straight answer :D

I don't think this is a hash group thing either.

Thanks
ALex

3 Comments

I want to add a conditional formatting to the cells in column G ( 7 - 22) . I want the cells to highlight a certain color blue (RGB 183, 222, 232) if the ship date in column H is delinquent based on today's date OR if the ship date carries through to Sunday of that week. For example today is Monday, Sept 10th. The cells in column G should highlight if the ship date is through Sunday, Sept 16th.

Second, is it possible to also to write a formula in cell H31 to automatically sum up all cells that are highlighted in the blue in column G so that I don't have to manually do the sum each time I move lines around?

Third, is it possible to also to write a formula in cell H32 to automatically sum up all cells that are highlighted in the purple (RGB 204, 192, 218) in column K so that I don't have to manually do the sum each time I move lines around?

Fourth, is it possible to write a formula in cell G32 to automatically sum up all cells that are highlighted in the green (RGB 0, 255, 0) in column K so that I don't have to manually do the sum each time I move lines around?
FCS-TRAINING.xlsx

11 Comments

Hi Experts,
I had asked a question about First Monday & Third Monday of the week couple week ago and Expert Gustav Brock gave me the Public Function which works but when I tried to place to another form, it does not work as it suppose. I know I did something wrong, but did not what I miss. below is my code on a datefield:
Private Sub PDFIRSTCRTDATE_Exit(Cancel As Integer)
Dim DateInMonth As Date
DateInMonth = Date

If Me.HoldCalA = "Cal 24" Or Me.HoldCalA = "Cal 42" Or Me.HoldCalA = "Cal 54" Then
If Me.PDFIRSTCRTDATE = DateWeekdayInMonth(DateInMonth, 1, vbMonday) Or Me.PDFIRSTCRTDATE = DateWeekdayInMonth(DateInMonth, 3, vbMonday) Then
Else
MsgBox "You have schedule on the wrong Monday for the " & Me.HoldCalA & "."
End If
End If
End Sub

Here is the Public Function from Gustav Brock:
' Calculates the date of the occurrence of Weekday in the month of DateInMonth.
'
' If Occurrence is 0 or negative, the first occurrence of Weekday in the month is assumed.
' If Occurrence is 5 or larger, the last occurrence of Weekday in the month is assumed.
'
' If Weekday is invalid or not specified, the weekday of DateInMonth is used.
'
' 2016-06-09. Gustav Brock, Cactus Data ApS, CPH.
'
Public Function DateWeekdayInMonth( _
ByVal DateInMonth As Date, _
Optional ByVal Occurrence As Integer, _
Optional ByVal Weekday As VbDayOfWeek = -1) _
As Date

Const DaysInWeek As Integer = 7

…

8 Comments

Monday

Related Topics

Monday

Related Topics