How To Set A New Variable

[bloodmilksky]

Hi Guys, I hope you are all well and had a great holiday season.

I was wondering if anyone can help me. I would like to know how to add a new variable to the code below that I am using for a holiday request form.

That would say that If Team X is entered allow 2 people off and if Team Y Is entered allow 1 person off

Dim Name As String, Team As String, StartRng As String, EndRng As String, ShiftRng As String, Final As StringDim LastRow As Long
Dim Rng As Range, Rng2 As Range, cRange As Range, Cell As Range


Team = Sheets("Sheet1").Range("B11").Value
Name = Team & Replace(Sheets("Sheet1").Range("B7").Value, " ", "")
LastRow = Sheets(Team).Cells(Rows.Count, "A").End(xlUp).Row

Any help would be greatly appreciated as I really want to learn how to do this.

many thanks

Jamie