conflict

Oh the headache this is causing... I am sure there is a geniously simple solution to this, but neither me (or google) have discovered it yet. (Google just doesn't understand the question I am asking it seems ) Here is the case: We are a bunch of people using an Excel macro file stored on a...

Hi There, I have been working on a multilocation (6) weekly scheduling board for 19 employees with some of them having different attributes (notary/supervisor). I would like to make sure the same employee doesn't get schedule at two location for the same time, but sometimes, employees have two...

I am receiving the method range of object worksheet failed error on the line below: G() = PBK.Range(Cells(2, 1), Cells(N, 1)) G is a variant, PBK is "Set PBK = Workbooks("A_LA_CARTE.xls").Sheets("Sheet1")", and N is an integer variable I am not sure why the range method used to select the...

Hi all! I am not really sure what to call what I am looking for, so if this has been asked before I apologize. I am making a schedule each month and I want to make sure I dont schedule people in more than one department. Is there a function that will allow me to type in a name on one sheet and...

Hello, I am trying to perform an IF function with multiple criteria. I'll explain what I'm trying to do first and then my formula is at the end. There are 3 columns: Check Mark, Formula, Activity (in A, B & C) In my example, imagine the "1" to be a check mark to do the activity in column C. If...

Hi, I am a herbal medicine practioner, I made a excel program to help me in my trade. I need some help from excel vba masters that how can I do vba coding for following: 1) Sheet1 col A and B <colgroup><col><col></colgroup><tbody> Medicine Tmp No Mohrak 1 Molyen 5 Shadeed 1 Molyen 1...

I am building a workbook for several users to enter data. There are a number of fields for each record, and the users may not know there is a conflicting save point (created by another user) until after they've spent a decent amount of time in the workbook. Is it possible to have a VBA code...

Hi, I hope someone can assist with my predicament! I have an Excel spreadsheet (2010) which has two tabs, one a list of dates and tasks, the 2nd sheet is a calendar. When a date is entered into the list, depending on the type of task I have got it to conditionally format the appropriate date...

Hi, i've just started a new job today and i introduced shared workbooks to the office but I have a problem which has caused me to have some egg on my face.. (:S) I have a shared workbook on a network and when there is a conflict, Excel doesn't ask my permission. The shared workbook settings...

Hello When opening my file I went to full screen (sub workbook_open) with a macro and when I close my file I went back to a normal screen also with a macro (BeforeClose) code = Application.DisplayFullScreen = False or True When closing the file even when I change nothing in my file the...

Hello! I am attempting to create a shared workbook with 3 different "types" of users, with multiple users of each type. Every user will have his or her own tab in which to operate. However, I want to create a User Form object for each type where users will be able to input and update data. I...

Worksheets("Main").Range("C3:GT69").Select Selection.Replace What:="X", Replacement:="", LookAt:=xlPart, _ SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, _ ReplaceFormat:=False I am working with version 03, and I do not have any issues with the above code. I...

Hi Folks, I have a userform which multiple user will be accessing to enter data, this data will then be saved on another workbook, I’ll call this file "log" this workbook is shared so that more than one user can access it at the one time. On the user form I’m using the last row code to find...