assignment

I have created a assignment list for a large gathering. Sheet 1 contains a list in column 1 of all adults attending, 40 names. Sheet 2 contains a list in column 1 of tasks needed for the gathering. For example bringing items, cooking, cleaning. In column 2 contains a validation list...

Hello all! I could really use some brainstorming and help with a project for which I have been tasked. I work for a multifamily management firm that oversees more than 5,000 apartments. We have around 80 staff that are each assigned to a portfolio of apartments. Every apartment receives a...

What does this error mean and how can i fix it? Set wb = Workbooks.Open(filename, True, True) Do While Range("C" & i).Value <> "" Dim newChart As Chart Dim accName As String Set newChart = Charts.Add accName = Range("C" & i).Value MsgBox ("Got here")...

Hi everyone, I need to assign a value from a set list of values to a line based on what score it has. Essentially, if a line has a score of 1 it gets assigned a number from one list, 2 and it gets a number assigned from another. These lists are finite and I want excel to start assigning numbers...

Hello, I am getting a type mismatch "Run-time error '13'" when I try to assign a textbox to a property of a class object which is defined as textbox. I do the same thing for combobox and button controls with no problem. The class "clsSessionTextBox" is like: ------------------------ Public...