excel 365

OK, so bit of a tricky one for me anyway. I have a list of data that has zero blank rows separating different values: <tbody> 100 100 200 200 300 300 </tbody> Now I've found this code to compare the cells above and...

How do I configure the File drop down menu from the ribbon on Excel in Office 365. My colleague has suddenly found that some of the shortcuts are missing after the last update. For instance, she no longer has the Save As shortcut but it seems to have been replaced with something called Save...

I want to change the background colour of a column header (cell C2) to Green only if one of the cells in the column (C3-C12) has the character C in it. Any other characters, or more than one C, etc. should not change the colour. Can SKS help out as I just can't seem to get a formula that works...

Hi All Something I cannot get my head around. I have a worksheet (Analysis1) that contains numeric data in columns 'D' to 'lastCol'. Each of these data columns has a header label in row 2. There can be anything up to 30 different column headers, but these fall into only three 'types'. The...

Dear All, I currently dispose of a working sheet which I use to keep track of my working hours. We recently have upgraded our Microsoft Office 2010 to Microsoft Office 365 and this particular sheet has stopped working correctly: it shows a lot of #value! errors. I have found how to correct the...

Hello, I am having some trouble with code I am trying to write. I need the variable LR to be redefined on each worksheet the code works on. I keep getting an error on the line underlined below. Hoping someone can help. Sub Update_Actuals() Dim LR As Variant, i As Long, NUM As Long, ws As...

Good day everyone. First I want to say that I have been working on this for a while and have not online looked through this forum but several others as well as Excels own help file at no prevail. So I greatly appreciate your help. To simplify things I will just use A1 as the cell I am trying to...