cheers

Hi All I'm have a problem combining two columns into one. The code below does what I want Sheets("Calculations").Range("K2") = Sheets("Calculations").Range("J2").Value & Sheets("Calculations").Range("I2").Text J2 contains a value and I2 contains the time and works as in it displays:-...

Hi all, Please could someone advise me what code I need in VBA to centre all cells (both horizontally and vertically) on an active worksheet? Cheers Chris

Hi Is there a simpler & neater way to write this in a For Each loop With Sheet3.Shapes .Range("Picture 7").Visible = msoFalse .Range("Picture 9").Visible = msoFalse .Range("Picture 4").Visible = msoFalse .Range("Picture 5").Visible = msoFalse .Range("Picture 6").Visible...

Dear All, Just wondering about the new function in Excel for Co-Authoring, is it possible to Co-Authoring a file in the local share drive rather than cloud like onedrive? Or we need to use the old way to do the share workbook? Cheers, Peter

Dear All, We have data entry from one spreadsheet (A) to another (B) as below: (A) <colgroup><col width="64" span="5" style="width:48pt"> </colgroup><tbody> a b c d 1 99 99 81 54 2 67 69 66 94 3 50 64 91 57 4 62 59 91 57...

Hi I have excel at work and we use the office 365. Is it possible for me to sign up to be an office insider does anybody know because I can't work out what I need to do and if it is even possible? Cheers Joe

Hi, I have a named range, "DataSource". I need to check if that named range = "Graphs!$B$1:$C$2" I have another macro' that change the range, hence the question. Cheers. S

Hi All, I need help on the following VBA code. I need to amend the formula below into a VBA code. I need to amend the 'O2:O662' section to show O2:O" & lastrow (used in previous VBA) or something that will work. =CONCATENATE("Number of Cases"," ",COUNTIF(O2:O662,">=£0.01")," ","out of","...

Hi I need a sumifs formula that has a dynamic sum range (it moves based on a criteria). Cheers

Hi I have tried to look up the thread but the solution =IF(ISNUMBER(SEARCH("CR",Cell_Format)),a2*-1,"") doesn't work. Cheers Michael1965

Hi, Has anyone else on here experienced the issue described on the thread below? :eeek: http://community.powerbi.com/t5/Desktop/Each-data-refresh-gives-different-data-results/td-p/60989/highlight/false If so, are you still having issues or have you managed to work out what the cause was...

Hi, My apologies in advance if this is a dumb question. I begin with a figure of, say, $500,000 (eg Cell E8). I take $70,000 at a rate of 2%. The balance is rated at 4% and added to the above. My formula now looks like this......=(70000*2%)+(E8-70000)*4% The result is $18,600. Using the above...

Hi guys Could somebody please help me translate the following function into VBA code: =IF(W8<>"UTG_o", INDEX(UTG_o!B3:B171, MATCH(W7, UTG_o!A3:A171, 0)), "") I want the VBA code to perform in cell V3. I've tried using the macro recorder and it doesn't quite get the job done. Really...

I have a text in an Excel worksheet that contains "1a" and "3b" and i want to change the letters to uppercase with out changing the rest of the text case Cheers Clive

Hi, Been struggling with this for a few days and given up. Hopefully you guys will help. Basically, I want a column to recognise if another cell in the same row contains x then it will display Y For instance, if B contains one of the cities, I want E to auto-populate the number for each A...

Hi, I was hoping if someone could help me for the following: <tbody> Column A Column B P 3 P 1 Q 3 P 3 Q 1 S 1 Q 3 S 3 P 1 P 3 Q 1 </tbody> If the cell in Column A is equal to P then count cells containing the value 3. So the above table consists of 5...

Hi, Does anyone know if its possible for excel to do the following? EG: 9.9+0.1=10.0 Id like a cell to show the 0.0 instead of the 10.0. Cheers, Alex

In excel 2016, I am trying to concatenate text with a number but decimal point but will not show, i.e. "test"&C2 where C2 contains 3.0. I just get Text3 instead of Text3.0. what am i doing wrong? Cheers Clive

Hi, and thanks for all help in advance. I down load date and time information and it comes in a relatively difficult format. 2017-11-17T09:18:00 Could you please show me some good formulas to extract specific parts - ideally so I can get a separate date and separate time column? Cheers Cam

Hi All, I need help to group rows with the same description A A A A A A Total B B B B B Total I want to group all the rows with A, with B etc... Can you help me? Cheers, Alf