Search results

r1c r1c1 I love this site! Thank you very much for your fix on this. I was initially trying to use a formula in the monthly data to tell me the FY and Qrt, but when I would try to use the output of the formula I would always end up with 1905 as a year. After doing some research, I learned...

Hello Gurus, I have read multiple threads regarding this issue, but have not figured out what to do when our fiscal year starts in October instead of January. I have a data table that monthly data is entered into and would like to be able to calculate sums based off a specific unit, fiscal...

Thank you for the response. I ended up doing something similar to your suggestion. StarMusk10

Good morning excel Gurus! I hope that you're enjoying your first cup of coffee this morning as much as I am. Nectar of the Gods!! Anyway, I'm struggling with a formula and can't seem to figure out how to have it reference a table in a different worksheet. I have tried the limited tricks that I...

Thank you herofox, Peter, and Chihiro for the help. Problem Solved!!

herofox, Thanks for the response. Here is the example you requested.

Hi all, I'm trying to figure out how to use custom formatting of a number to show "No Change" from the previous entry. This is what I'm using for the Increase and Decrease, [Red]▲ 0;[Color10]▼ -0. What I want to do is add a "No Change" part to this. Right now if there is no change to the number...

Sorry for the delayed response. Thank you guys very much for the suggestions. It helped!

Thank you bosco_yip! I had been struggling for a few days with this.

Hello, I would like to extract text from a table based on criteria. I have attached a sample workbook for you to view. In my workbook I have a data table containing unit names, quarters and positive and negative comments. Based on the selection from the drop down lists I would like the positive...

Good morning Guru's. I have an excel sheet (Org Target Dashboard) that has and Active X list box in it to control a chart. Before protecting the sheet I select a cell behind the chart to hide it after protection. Unfortunately, when I protect the sheet excel will select a cell at the bottom of...

I think I solved the issue. I had to switch the Display settings for that workbook from "Optimize for appearance" to "Optimize for compatibility". Suddenly it works. I guess it had to do with screen resolution. I have multiple monitor screens at my desktop and they are low-DPI vs my laptop...

Good morning, I have a excel sheet with a button to open a form for data entry. My laptop is connected to my screens by a dock. When I remove the laptop from the dock and try to click on the button the form won't open. Then, sometimes the more I click on it the smaller it gets. I started to...

:)

vletm, I have attached the file for you to view. The drop down list is in the tab labeled "RN Nurse Indicator", in cell B1. This is the only tab that has the issue.

I have a dynamic chart that is controlled by a drop down list. When I select the drop down arrow and try to select from the list my pointer changes to this. The other drop down menus in separate sheets are fine. Any help would be appreciated. Thanks, Starmusk10

Belleke, Now its working! Thank you for the help, now if I can figure out how to build it again! LOL

Thank you, I'm still learning how to understand the VBA Macros. I have been working with the form and found that when you add a new entry with the form it deletes the row below it in the Data set and then adds the data instead of adding a new row. Its causing me to loose data for the unit below...

This works great! Could you give a tutorial on how you accomplished this or point me to some resources. I want to learn how to do this so I can utilize it in some other areas. Thanks again.

Thank you for your response

In my data table, column "A" is organized by Unit name. Right now to enter data into the table for a specific Unit, I have to add a row under the last entry of that unit and then enter the data. Is there a way to build a entry form that will automatically add the data under the last entry of the...

vletm, Thank you very much for your help. I will look into the instructions. Thanks again

I have my dashboards in Excel 2016. When I try to use One Drive and then Excel Online it will send the selected sheet but not allow any of the dynamic drop downs list or charts to work. I understand now that Share is very limited, but how can I do this?

Good afternoon. With the help from this forums members I have developed some nice dashboards. Now when I try to share these dashboards and allow users to interact with it I'm finding that I can't. How can I share the dashboard with users, allow them to use the drop down lists and on the back...

I ended up adding a table in the Quarter Tab with a list of the Quarters and using the formula from bosco_yip =INDEX(Data!$A:$A,MATCH("zzz",Data!$A:$A)+COLUMNS($A:A)-5). I think it works.