stopped

Hi, Using the following function among others for my searchable drop down lists: =IF(ISNUMBER(SEARCH(INDIRECT(CELL("address";Forecast!$F$5:$F$1048576));'Master data'!C2));MAX($D$1:D1)+1;0) For some reason it stopped working. I have no previous versions. 'Forecast'!$F$5:$F$1048576 I can see...

Hi all, I'm having a bit of a brain explosion over this so should I would register for some help. I have a spreadsheet which has 3 columns. Column A contains a list of computer names, Column B contains a list of services, column C contains the status of the service. What I want is to count...

greetings every one, i hope you are well and safe. This web helped me a lot so, thank all of you for your support. i have a small problem that might be solved here of course. i have 4 types of equipment listed in the excel sheet using the PI add-in tool to extract the running hours for this...

Current formula is =A1*B1 and in C1 is the total. A1 contains a number and B1 contains the word "included" but sometimes it is a number value and not text. I formatted column B as a number so the formula was calculating the word "included" as a number but now it has stopped and it's giving me...

Been using data validation with a drop down list on a column in a worksheet for months with no issue. Today I have noticed that there is no longer a drop down list on any of these cells, and instead all I can do is enter text manually. I've check the data validation rule and it's still set to...

Hi, I have a master documents that takes data off approximately 20 other workbooks, however some of these workbooks are password protected. Is there was way (coding or macros) that entering the passwords can be stopped - as its a pain having to click several boxes to either input (or not) the...

Hi All, I'm using an auto save feature to save a document prior to the user exiting. Private Sub Workbook_BeforeClose(Cancel As Boolean) On Error GoTo Error1 MsgBox "AUTOSAVED !!" ActiveWorkbook.Save Application.AutoRecover.Enabled = False Application.Quit...

Hi, For dyslexic people like me reading text that is mixed case is difficult so I found this script that was working great. All of a sudden the script saved in my sheet(s) stopped working, on my main computer. When running on other computers the script still works. I received an error after...

Hello Everyone, After running a sub that transfers information to another workbook, I occasionally get this error message generating that: Is there a way that I can clear this message out in a similar way that: Application.CutCopyMode = False 'Clear Clipboard Clears the Clipboard...

Good afternoon Excel gods I have an issue with an excel spreadsheet...which I did not create. There are 5 check boxes [on the joining tab]. When a check box is selected it increases/decreases the columns that are in a table by 1 based on the number of crew that are currently onboard the vessel...

Hi All, It has been while I'm using MS Excel 2010 and generally use some MS 2003 excel shortcut like paste special, series.. etc. I don't know why it stopped working but I can use MS Excel 2010 shortcuts without any problem. Anyone has ever had this strange issue? Thanks, Mukesh Y

I have a table as follow on fees and wanted to use the nested IFs to find the accumulated fees depending on which month it is. <tbody> A B C D E F G H I J K L M Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Fees 640 500 800 500 650 420 410 550 220 440 160 180 </tbody>...

Hi. I've had a look on line but all the Macros are too complicated. I am looking for the following Looking for an email with the title West Availability Report – 0500hrs Tuesday 25th July 2017 ( the date changes daily) to extract information in it (a table to be exact) and move it to Excel...