support

Hello all, I was tasked with creating a summary page for a workbook with about 25 sheets. I accomplished this used VBA, only to find out that the file is stored and accessed on a SharePoint site which doesn't support Macro use. Is there any other way to combine data from multiple sheets in an...

Translator Spread sheet is not support Arabic Language 1-From Ar to Eng not OK 2-from En to Ar Ok Help PLS See Link Below https://www.mrexcel.com/forum/excel-questions/677976-translating-spreadsheet-7.html THX

Hello Friends, I have to get some office systems ready for Excel therefore, i need to know the compatibility of all the windows version with Excel versions. May i request your kind support here to update the table below, pl also suggest in case i have missed any of windows version between 98...

Hello all. I can get the modify sintaxe correctly to AppliesToRange as below but I can't get to ModifyFormula1. Sub CFTest ActiveCell.FormatConditions(1).ModifyAppliesToRange Range("$L$2:$L$115") 'this works properly ActiveCell.FormatConditions(1).ModifyFormula1 "=$I2=1" 'this...

If I enter the following code into the ThisWorkbook object in a newly created Excel document: Sub Clean (ws as WorkSheet) MsgBox ws.Name End Sub Sub test() Clean (WorkSheets("Sheet2")) End Sub I get the error "Object doesn't support this property or method". What do I need to do...

I have a workbook with multiple sheets. One named TSA Daily & another one called TSA Support. In cell "B1" has a date and in the column on TSA Support (Column A) that has dates & time stamps. I want "C5" on TSA Daily to count how many times the Column L has something in it if the date is...

I have an spreadsheet with 40+ columns that are support hubs, and 1400+ rows of support sites. I have distance data for all contained in a matrix format. I want to be able to use a drop down menu to select one of the support hubs, and then have list/match to select all entries within the hubs...

Is there any reference on the Internet or on this site that lists Excel functions that support Array formula and any functions that can not be used in an array formula? It's always tricky to get a confirmation if a function shall work in an array formula. Thank you.

Hi gang, I'm a long time excel user but novice VBA writer. I've been working on this VBA and have cobbled together something that works when the data is in a range (for test purposes). Now I need to make this work within an Excel table for regular use. The table syntax is tripping me up. I'm...

Hi All, I posted a question earlier but one tip led me to my newest sticking point. How can I use a {=index(list,match(0,countif(uniques,list),0))} type array when I want to pull the data from a pivot table? Below is the pivot table I'm working with. <colgroup><col width="94"...

Needing to create a line graph showing oil production data for each month across several years. The way the data was logged included Jan-Dec as column headings and years 1986-2015 as row headings. How can I graph this data starting with January of 1986 and ending with December of 2015 across the...

Hi there, I have a taqble that I am getting from the internet through a web query (you can probably already telll I have pretty much no experiance with excel) and the table has a field which contains a set amount of choices, seperated by a question mark, example: hello?world?how?are?you I...