Search results

Hello, I have a Pivot Table challenge that I don't have the skill set for. The File is a sheet from a Google form Quality Assessment that we need to be able to measure by questions and responses in columns AX-BA. Further, the ability to measure the count and percentages by the employee per...

Hello, I am working on a project involving determining a factor based on a CPI table. The solution I am seeking involves 2 pieces of data, one of which I have worked out using match and index and some other formulas. The 2nd part is a little more challenging. I need to be able to select...

Hi I don't know if this is a common problem but I cannot get a tool that I am working on at home to function at work. I have been working on a tool using a little bit of VBA code at home and when I try to use the tool at work I get error messages referencing a missing library. I am not very...

Hello, I am attempting my first Dashboard and I need help with several aspects but I'll focus on one area at this time. I have a number of cells that contain zip codes such as: 85012,85013,85014 etc. Each block /group of codes belongs to an particular employee(s). I used this formula...

Hello All, I am working on a project that involves tracking a credit. The tool uses data validation to trigger certain functions within the formula that I am being challenged with. This is the formula...

Happy New Year to All. I have been searching the forum for a solution but to no avail. I am looking for a way to have a series of formulas in a row automatically fill downward was data is entered into a subsequent row. I am working on a tool that will track payments(see attached). The data...

Hello Friends I have a question about controlling the tab order in a protected worksheet. The cell order is non-contiguous. I would like the user to tab in this order; "B13", "B14", "B15", "B16", "B17", "B18", "B19", "B20", "B21", "B22", "B23", "B24", "B25", "B26", "B27", "B28", "B29"...

Hello Friends, I am looking for a solution that automatically expands merged cells for multiple sheets; 1,2 I am working on a project that requires user input on sheet 1 in merged cells;C14:G14. My 1st challenge is to have the merged range expand automatically as the text expands. Part 2...

I am asking for help with a VBA solution. I have researched this forum and the interweb in general, and cannot seem to find the exact solution. The short version of my problem is I have a workbook sheet that is filled out by co-workers. I would like to hide rows that are left blank. Below are...

Hello Group I recorded a macro and assigned it to a button that clears cell contents in a excel sheet. The sheet is protected except for the cells that allow entry. The macro works fine, but I was thinking it would probably be a good idea to have the user confirm they want the cells...

I have a problem. I have a project that consists of 3 columns and 5 rows. The 1st 2 columns contain dates ( 5 rows) from and thru, and the last column contains currency. The 1st row will contain a date period less than 365 days whereas the subsequent rows will contain from and thru dates...

Thanks in advance for any help that is provided. I have a project that I am working on that requires several things to happen The format is set up to when a date is entered in a primary cell, up to 5 rows below which represent up to 5yrs( if applicable) should populate but of course this...

I have a problem that I have been puzzling over for a week or so. The goal is to create a chart to compare data from 2 sheets. Each sheet in column A contains sequential dates. The 1st sheet has 2010 dates in 01/01/2010 format thru 12/31/2010. The sheet for 2011 has dates up to 05/12/2011...

I have used the following dynamic named range formula for quite some time to accomplish a dynamic range. The only problem I have is I can't leave an empty cell between occupied cells. If I do the range is not accurate. Does anyone have any recommendations apart from converting to a table...

A co-worker and I have been working on this problem for a while and only achieved marginal success. Here' the issue. The sheet requires the user to provide the Date of Birth or (DOB), to arrive at what their age will be at MMI( a date in the future. Here's the twist. There is a term called...

I have a spreadsheet that returns the number of times a nurse(s) performs a particular activity. There are about 5 nurses. The activities as well as the nurse’s name are listed on a sheet called list. named ranges; RN and activities are used. I use data validation to populate a separate sheet...