management

Hi All, I want to create an asset management work sheet that I can drag an object that holds a value (vehicle 1) for example and place it in another cell. The idea is a yard management document where I have a set number of Vehicles and I want to allocate them by dragging and dropping them into...

Hi all, i prepared a VBA command by which i issue management accounts and it takes around 20-30 seconds when i run it. I would like to add a progress indicator in percentage into the above command, so that when i run it to appear this information on screen, e.g. Management Accounts in...

Sorry if this has been answered before I searched and did find some similarities but nothing quite the same and wasn't able to use what i found to fix my problem. I get a spreadsheet at the start of each month that has employee turnover by manager and department problem is that i want to be...

I am a self-taught excel user, and have tried to build a macros to do this, and failed! I am looking for every minute detail about how to do this (I have already added the developer tab but where to go from there, I need to clarify). I have three workbooks/tabs: Raw Data, Referral...

Hi guys, I am trying to count how many times a text appears next to a staff ID across 5 columns. I foolishly thought a countifs formula would sort it, but I'm getting an error so that's obviously not right :confused: Below is an example of the data I'm working from (I can't attach a...

Hi All, I have most my local Access databases stored on the desktop, however I prefer to work with SQL Server Management Studio. Is there any way of connecting to local Access databases without admin rights? Best regards Sober

Hi All, Thank you for taking time to look over my excel challenge. I have a compact data, which should be extended in a larger sheet. below are both charts. I have given first chart and I would like the second chart to be populated. Prefer formulas, but if it's VBA, that's fine as well...

Hi Guys, Could someone please help me. I have a spreadsheet called "Top Management" This sheet has a lot of data on based on the amount of management, their gender and race. On one side of this sheet I have summarized all this data, this data is hidden. I have created a command button called...

How do you track your production? I need to develop a method for tracking the location of the many spreadsheets that are developed daily for different projects and I'm at a loss. What method do you use?

I have 2 lists. One contains locations and the other contains items. Each item can be found in a few specific locations, and each location contains a few specific items. I'd like to create a user-friendly document where someone can mouse over a location and see a list of the items there OR mouse...

Guys I got one very annoying problem related to memory management of excel. I have one file of size 4.75 MB and it's a ".xlsm" file meaning it has some very basic general routines related to management of my various sheets. I got 275 sheets in the workbook. Whenever i am working on sheet (saving...

Hello! I recently was promoted at my job and am now in charge of scheduling our employee's shifts on a weekly basis. Rather than having a program for it, they still do it paper and pen style. This is slightly problematic, considering our employee base is rather large, has people who are...

However labor intensive, to what extent can Excel be utilized to effectively manage patient pre-operative clinic appointments (in a near automated manner) whilst also: * controlling the allotment of surgical clinic slots (as a percentage of total pre-operative clinic slots) *...

I would like to track the project status of several projects with a weekly report and keep track of all project history and status with a pivot table summing-up all the data from the weekly reports. The weekly report would be something like the following: <tbody> Date Project Activity Hours...

Hey everyone! I have spreadsheet that is basically a bank statement. here is what is looks like; A1 has the deposit or withdraw B1 a drop down menu of it either being a deposit or withdraw C1 Year To Date information On cell C2, all I am trying to do is getting all incoming rent to add up...

hi, I am new to the forum. I was wondering if people be kind enough to give me information on where i can get valuable information on how Excel can be used in such fields as forecasting, production planning etc for the manufacturing sector. Thank you:)

Any help or guidance would be amazing on this one: I'm wanting to use Excel as a project management tool. I have designed individual project sheets, with a cel per day. Each sheet is a 6 month snapshot of the project, and depending on the project there might be just one sheet (6 months) or 4...