manager

It's been a while since I have posted, so not sure if I am posting correctly this time. I have an issue with conditional formatting in cells D6:D14. In Column D a response is returned depending on what is input in C13. The effect I am trying to achieve is where there is no value in C13, then...

Hi everyone, I have been using rangeToHtml recently to automate sending out emails, and I am in love with it. i am still trying to learn some things and was wondering if there is a way for me to paste a dynamic range instead of a static range. for example, every month, I send out emails to...

I attached a dropbox link so it’s easy to follow along. In this roster, I have a sheet labeled setup. In there aremanager names to reference, I want these three managers to be transferred intotheir own workbooks (individually: manager 1, manager 3, manager 5). In Sheet1,Column AR is where...

Hi everyone i have a userform1 with two optionbutton (opt1; opt2) and two check button chk1; chk2). i would like to use Name Manager in combobox (cbo1). Whem opt1 and chk1 is open the cbo1 show us a especific "name Manager" with opt2 and chk2 appear another "name manager". I am a new in vba and...

Does anyone know which add-in creates names with a _bdm. prefix? An example: _bdm.8967E1C0A2914A6EB0F4E56B3B28F0A2.edm

I've looked all over but can't really find what I'm looking for. Basically I'm trying to build a VERY basic forum within Excel. Someone can post a comment, question, etc. Then other employees/Managers can respond. The problem is that it needs to be saved so that if a manager responds no one...

Hi all, I have a worksheet where each row represents a location. Column C lists all of the employees at that location separated by carriage returns. Is it possible for the sheet to split out the employees and display individual lines for each employee? <tbody> Location ID Location Employees...

Hi, I am faced with a problem, where I have a data set in a sheet where for each date there are three columns – Manager, Time Scheduled & Time Worked. Now, in another tab, a summary is required for each manager for each date. I used the sumifs function to get the details. However, while...

I have an excel file that has a list of employees (column a), their manager name (column b), and manager email (column c). In many instances different employees may have the same manager. I want to use a macro to automatically send one (1) Outlook email to each manager along with the names of...

Hi can you show me how you construct financial model I havent got a clue :( <colgroup><col><col><col></colgroup><tbody> Modelling Skills We have 12 new sites coming on over the next 34 months (starting Feb 18 and finishing in Dec 20). We need to create a model to calculate our...

<colgroup><col><col><col span="8"></colgroup><tbody> 1 Product ( example Nescafe, Dolce Gusto Machines, Nesle Bliss)- Indicate the main products 2 Product Name List - eg: bliss orange, Bliss apple 3 The selected product Name will appear with the indication "malaysian" or " Imported" 4...

<colgroup><col><col><col><col><col><col><col><col></colgroup><tbody> Manager Supervisor Manager Supervisor Manager Supervisor Average Daily work production 85 80 89 84.67 Accuracy of work 85 90 89 89 90 </tbody> Above scores is given by managers and...

I have two column in excel I want find column differences ; I have below two column I want to find out based on the employee name check entire Manager column find any differences in manager name. Emp Name Manger Mike John Mike Victor

Hi wonderful people. I'm hoping you may be able to help. Apologies if this has already been solved elsewhere. I have HR data like the inout data table below where I have manager and subordinate employee numbers. I'd like to find some VBA code to output the table to the right below. In...

Good morning, Having difficulty getting my head around what i am doing wrong. H!M3 = data validation list called "Consignee" In Name Manager, "Consignee" = OFFSET(Consignee!$A$2,0,0,COUNTA(Consignee!$A:$A)-1,1) Consignee!$A:$A contains list of consignee short codes, for example A2=MZOUK_AD...

My file has several hundred Named Ranges ("NR") that I'm constantly using in formulas / changing. Whenever I want to edit something, I first need to look up just what cell range a particular NR refers to (so I can either change it, or edit the formula accordingly.) Currently I have to open the...

Hi everyone, I have the following table <colgroup><col><col><col><col></colgroup><tbody> Office Position Start Date Termination Date New York Manger 20-Jan-16 11-Nov-17 Chicago Director 20-Jan-16 28-Dec-18 Miami Senior Manager 20-Jan-16 13-Feb-17 Boston Director 20-Jan-16...

Hi, I am looking for VBA Code that can delete blank row above particular text. For Example.. A1: John Kenneth A2: A3: Executive Manager A4: California Like this i have 10,000 records, Now I want delete the row A2 which is above "Manager" keyword. Please suggest. Thank You, Mohan S

Hi, I am looking for VBA Code that can delete blank row above particular text. For Example.. A1: John Kenneth A2: A3: Manager A4: California Like this i have 10,000 records, Now I want delete the row A2 which is above "Manager" keyword. Please suggest. Thank You, Mohan S

I have a formula that references a table inside the file I'm working in, but I don't see the table in the Name Manager. All filters have been cleared. How is this even possible? I thought all tables were referenced in Name Manager.