department

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

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

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

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

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

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

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

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

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

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!!

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

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

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

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

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

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

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

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

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

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