manager

I'm sure this is simple, but the following code produces an error "Application Defined or object-defined error". Grateful for your suggestions to correct. Function AvailCol(nAvail) As String Dim cCol As Integer 'column in which availability should be found Dim nRows As Integer 'number...

Hi Guys. I need to count rows where: - There is a status Opened in column D (Opened is a range in Name Manager, so there is more than one possible status) - There is a digit 1 in column I - There is status PG in column B (PG is a range in Name Manager, so there is more than one possible...

Hello, I have I spreadsheet similar to this: Account Manager Person Credited for Sale Joe Smith Sally Jones John Davis John Davis Sarah Clark Sometimes who the Account Manager is matches the Person Credited for Sale...

Hi All, Got an interesting query to ask.. Trying to work on a formula for the below, I need to remove duplicates that match on the same day.. So if the day and month is the same and the column c letter is the same then remove the duplicate. I cant seem to find a function or macro that could...

I have around 600 lines with cells that reference name manager values...when I look at the cell, it shows the name: Ex: =Sales*Qty When I double click to edit it changes to the cells itself: Ex: =A1*B1 I want to copy ALL 600 lines using the "Show Formula" view...but when I do that it...

I have a list of cells - when I filter on emp_type for Manager in column C I can select all of the cells in column B then click on the "green dot" in the green select box and drag it (Fill_Left) over to column A - copying the filtered text to column A How can this be accomplished in VBA? other...

Hi all, wonder if anyone can help me with this one please. I have a formula, listed in full below, but the part I am trying to amend is in blue: =IF(A5="","",IFERROR(INDEX('GMS Throughput'!$B$2:$Y$350,MATCH($A5,'GMS Throughput'!$A$2:$A$350,0),MATCH(SUBSTITUTE($BM5,"Report","Throughput"),'GMS...

Is it possible to use Index/Match to create an Org Hierarchy? For simplicity sake I've put in a few columns. So since the manager is Steve in B2, C2 would populate with Steve's manager (Marcia). A result of that D4 would populate with Marcia's manager (Andrew). A1: Employee Name (John) B2...

Hi. I've wrestled with this for several hours so any help is much appreciated. I have a table containing 5,000 projects by value. I want to show the top 10 by Project Manager and by Financial Period. I have been asked not to use VBA or Pivots. I have used the following formula to successfully...

Dears i need your assistance in the following : I have a list of employees, their IDs, grades and job titles. For each job tile there are certain Competencies related to it and for each competency it has certain courses related to it. i created a sheet with ID drop down list and whenever you...

HI All I have asked this question before but can no longer find the macro that this awesome community developed for me, and now a few years down the line I need it again! I have a worksheet comprising of 6 Columns of data. I want the data copied into separate tabs for each account manager...

I have a task built in "Windows Task Manager" that is set to open a batch file (.bat) automatically at a specific time a day everyday. That batch file is set to open an excel file loaded with an auto macro (.xlsm) The code in the macro opens a specific workbook from a shared network drive ...

I'm looking for help setting up a formula that will change with manager names from the helper page. The formula need to work when there is More or less managers ie. some months we will have 4 managers and others we will only have 2 managers. I have tried using =INDIRECT("'" & G16 & "'!" & G18)...

I'm looking for help setting up a formula that will change with manager names from the helper page. The formula need to work when there is More or less managers ie. some months we will have 4 managers and others we will only have 2 managers. I have tried using =INDIRECT("'" & G16 & "'!" & G18)...

Hi, I'm trying to set up some function that will allow me to type in a colleague's name and it pulls up his or her manager. Appreciate any assistance in this. Thanks you. :)

Hi, I'm using "Name Manager" in Formulas Tab to define LIST. Exaclty the same I want to do using VBA. I have: =OFFSET('Country'!$E$9,0,0,COUNTA('Country lvl'!$E$9:$E$20),1) Into VB: rows_x = ws.Cells(Rows.Count, "A").End(xlUp).Row wb_1.Names.Add Name:="Country_list", RefersToR1C1:= _...

Hello I've come up with a bit of an issue when trying to programatically create workbook connections via an Excel 2007 Add-in created in Visual Studio 2008 (VB.net) My current code is as follows: Imports Microsoft.Office.Interop.Excel Public Class myForm Dim Workbook As Excel.Workbook =...