dept

I have a list of managers (column A), a list of departments that are assigned to these managers (the amount varies) (column B), the final column contains the amount/values of employees in each dept (column C). The purpose of the list is to distribute it to 6 different people. I need 6 different...

I need help with simple VBA Code. I have a SAP BW Excel Extract. In Row 3 there are are column headers of ten Depts. Each Dept's name occurs four times. I want to find the last occurrence of each Dept's name and insert two blank columns for each Dept. All the first blank column's header must be...

Good morning I have a workbook which has 9 individual Dept sheets to record travel costs. I am looking for help in calculating the total monthly cost on each sheet and transfering that figure into the correct month on the summary sheet. <colgroup><col width="64" style="width:48pt" span="7">...

Is there a way to combine results in excel? Survey was sent to ppl in different countries. Survey has dropdowns for each question. Responder will answer all questions. Format of the survey Question - Name of Responder - Company - Location - Dept 1 - Dept 2 - Dept 3...

Hi I have "dept" as ListBox and I am trying to initialize it using With-End With but I got compiler error. Thank you so much. Private Sub UserForm_Initialize() With dept .AddItem = "hr" .AddItem = "it" .AddItem = "marketing" .AddItem = "sales" End With...

I cant figure out how to get a sub to 'Here is what I have: Sub ExportDeptOneKPI CallKPIPrint ("Dept One") End Sub 'This calls the below but how do I get the name in the spot with the ???????: SubKPIPrint (PDFPrint as String) Worksheets (PDFPrint).ExportAsFixedFormat Type:=xlTypePDF...

Hey, So I am working on a project and the powers that be would like to be able to type one row of data into an excel sheet, we'll call it Main, and have any new lines appended to other sheets based on whether the field is empty, department specific. Originally I was grouping all the sheets...

Hey There! I am trying to find the number that shows as January and a specific department. I have all months in a chart and the name of the department in the top left. The formula worked for the first department but it is not working for the next department. AE:AE in the formula is looking up...

Hello, wonder if you can help me. I have a list comprising of: <tbody> ID Title Name Dept 2223344 Mr Adam 1 Dept 3344555 Miss Hannah 1 Dept 7755882 Mrs Jade 2 Dept 9772348 Mr Joe 3 Dept </tbody> The external program that i use exports a csv however leaves out the 'Dept' Is there a...

Hi I want to do reverse lookup (multiple criteria - returning multiple results). In this case user will enter Address in H3 and dept in H4 then excel will return ph# in cell H6 and name in cell H7. I highlighted cells H6 and H7 and then wrote the following formula in cell H6...

Hye guys looking for some help with countifs In column A I am looking to create a formula to concatenate the dept and the various metrics. The countifs should count each job code that begins with 1- that falls in this category. Dept are in B and Unique Identifier for job code in E. I...

I have a sheet of sales with 7 blocks of daily data, Sunday to Sat. one block for each day. They are by store, down, and dept, across. I have another spreadsheet report with 34 taps, one for each store. Each with one block for each day of the week. I need to look up values from the sheet of...

<tbody> dos id dep? id begin end dept 3/22/2018 1234 1234 4/13/2018 12/31/9999 205 4/6/2018 1234 1234 3/1/2018 4/12/2018 105 4/25/2018 1222 1222 1/31/2018 7/31/2017 106 </tbody> I have the following. I'm trying to get the dept? a member was in on the dos...

How is a 2-column drop down list created whereby one double clicks in a cell opening the 2-column drop down list then populating the cell with the data from column 2? The first column is the department name, the second column is the dept numbers, by choosing the dept name the cell is populated...

Hi, I have a table that isn't in the best format but this can't be changed. It looks something like the below.. <colgroup><col><col span="9"></colgroup><tbody> 201701 201702 201703 Department F L M F L M F L M Dept 1 61 71 63 53 87 50 63 74 19 Dept 2 87 46 75 21 70 50 26 37 41 Dept...

Hello, I am trying to create an Index/Match (open to other suggestions) that would return information from an array that was based around a few conditional matches. In the example below: John Smith has pay/deductions assigned to Department 200 and 201 (rows 2:7 are for Dept. 200, rows 8:15...

Hi I am looking to search for certain value and then return the associated row. For example Sample Data: <colgroup><col><col><col></colgroup><tbody> Name Dept Age Henry 501 28 Stan 201 19 Mary 101 22 Larry 301 29 Lynn 201 22 Harry 401 21 Joe 101 23 Lynn 301 30 </tbody>...

Hello, In column C, I want the following action: forward calculation if the criteria is met but reverse calculation if other criteria is met. This is a two-way action. <colgroup><col span="7"></colgroup><tbody> if from dept = "Step 1" & to dept ="Step 2", then QTY * WEIGHT if from dept =...

Hi I have a workbook (salesdata.xls) which contains sales information for a full year by department, it looks like this: <tbody> Week Dept A Dept B Dept C Dept D Dept E Dept F Dept G Week 1 700 520 100 620 44 120 800 Week 2 125 522 144 800 55 170 700 Week 3 122 400 200 120 44 150 500...

I have a report that shows people names First Name Lastname (Dept) I have a different system that needs people as Lastname, Firstname (Dept) - if applicable. Note - not everyone has their dept name. Just if there is more then one person at the company with the same name. I've found formula...