department

  1. K

    Vlookup/Hlookup need help

    Hello, I have GL data that basically looks like this A1:GL Acct # B1: Name C1: Total D1: Department 1 E1: Department 2 F1: Department 3 A2: 65000 B2: Wages C2: 1,000,000 D2: 500,000 E2: 250,000 F2: 250000 A3: 79000 B3: Travel C3...
  2. C

    Add a column to calculate remaining budget

    I have a PivotTable that shows expenses across departments. Each department has a set budget for the entire year. In addition to the grand total that shows how much each department has spent, I would like a column that shows how much of their budget is remaining. For example, the DA department...
  3. Johnny Thunder

    VBA Help - Code that does a lookup based on Cell and brings in metadata - Excel 2016

    Hello All, I am working on a project and have this code that works but its super slow, takes 15-25 seconds to bring the data into my sheet? Context, this is a report for an HR Department. A user can drop in a tracking number and from a Data Mart sheet the code looks up the details stored...
  4. S

    Selecting one Cell highlights all others with the same data

    Morning all I have a worksheet that contains a list of courses for 2 of my departments, Column C pertain to courses "Department A" have completed and Column G pertain to courses "Department B" have complete. There are over 450 courses detailed in each of these columns, with multiple courses of...
  5. J

    Sumif Indirect Multiple Sheets and Another File

    I am attempting to sum if the blank cells from another workbook across sheets 1 through 10 when column A:A (below) matches matches column F:F (other workbook) and row B:B (below) matches E17 (other file). I could sumif one column at a time, and change the sheet reference manually, but there are...
  6. R

    Potentially using Match/Vlookup/CountIF to calculate result

    I hope someone can help. I may get tongue-tied if I attempt to describe this issue so hopefully the scenario below will help illustrate my challenge. Worksheet 1 Cell A Folder Location Name 1 Folder Location Name 2 Folder Location Name 3 Etc... - Multiple records below which also contain...
  7. S

    Excel chart: group by month, cluster by department, stack by type

    I'm sure I've got some of the terminology wrong, but here's basically what I'm trying to do. I have a table of data with three fields I want to use in a chart: date issued, department, and type. What I'd like to end up with is months along the x-axis based on the date issued, a count of entries...
  8. T

    UserForm Dropdown from another sheet

    Hello, wondering if someone can help me, I think this will be a relatively simple question for someone. I have a UserForm with drop downs for Department and Name. I have an ever growing and changing list of Names in a sheet called ‘Staff Database’. This contains columns Department, Name and...
  9. F

    Subtotals/Aggregates not calculating correctly

    I am working on a utilization report that has a data model with 2 tables. Table 1 = Data (all hours worked by an employee), Table 2 = EmpCalc (standard hours base for an employee). My utilization measure is as follows: =sum(Data[Jan-19])/sum(EmpCalc[Jan]) I then created a Pivot which is has...
  10. M

    Dropdown based on a selection

    Hi, hope someone can help me here. Im trying to crate a sheet that creates a dropdown of roles based on the selection of a department. Example below of what I’m trying to achieve. https://we.tl/t-oFAukUJE6p Thanks!!
  11. M

    Copy and paste from Master File

    I am not sure if this is possible, but I have a master file with 6 columns. The first column has text corresponding to sheet names (a total of 13 sheets). What I'm looking for is a macro that would move data from the master file to the corresponding sheet based on Column A. For example, for...
  12. N

    Add button and module to open worksheet #2 from worksheet #1 with vba

    I have a worksheet controlled by another department that I'm working on 'improving' for my department. Without messing up the same worksheet that they use in their department. So I have worksheet #1 , controlled by my department. There are a handful of fields/cells I want to automatically...
  13. J

    Question - Data extrat from one workbook into another

    Good Day excel Guru's! I am a novice with excel but highly addicted! My issue is this: I run a small business and I would like to track my payroll from several departments into an easy to analyze workbook. The trick is that ADP generates a weekly report in Excel format (which ill try to...
  14. D

    different line per department in line chart

    https://www.flickr.com/photos/156921257@N03/46482426265/in/dateposted-public/ I want to see both department actual in the same chart different line, department 91 in blue line and department 81 in green line and the budget in blue line. now I can only slice one department all to see all...
  15. D

    different line per department in line chart

    I want to see both department actual in the same chart different line, department 91 in blue line and department 81 in green line and the budget in blue line. now I can only slice one department all to see all departments actual in the same chart. can I do it without changing the actual data...
  16. M

    replacing old department data with new department data using VBA

    Hi I've got a sheet with data and the Department name in each row. I'd like to replace data for a specific Department when I import data from a folder. I've written the code to import the data. But I'd like to know if it's possible to write code that will search for a Department name in the...
  17. J

    IF statement

    hi, was wondering if someone could help. this is probably simple but has my head a bit messed. basically i want to do a formula where if the values of two cells dont match something then sum 3 cells to give a total. in one column i have account. and in the other i have department. i want the...
  18. C

    Index and Multiple Match Help

    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...
  19. P

    Copy description from one cell to another

    Hi all, I would like to use a VBA code, so that to run through col “B” and where find the name of each department, e.g. Restaurant, Pool bar e.t.c., should place it in col. “F” and rows down for each department’s records. Therefore, that the rows are 100000+. I present below the original data...
  20. rjplante

    Transfer from report

    I have a department listing page which has the department names in Columns ACE...etc. This is the sheet I want to transfer into. Call it Sheet A. I also have a spreadsheet that is generated from a report from some accounting software. Call it Report B. Report B has two columns, Column A has...

Some videos you may like

This Week's Hot Topics

Top