advise

I try to set up Const C As String = 2019.2020 , but the will only accept 2019/202 Please advise on how to overcome this

Currently not at my pc but I would like a userform to only be shown if a specific cell is empty. Would this be correct ? Please advise. If Cell (“B1”) = “” Then Userform1.Show Else Exit sub

Hi I have a formula in a spreadsheet which i need help to understand This is the 1st part of a calculation. I understand the rest of the calculation except this natural logarithm =((LN(D5/10)*-0.5179)+2.66)*D6 This is then the following =((LN(temperature/10)*-0.5179)+2.66)*flow rate Values...

Dear Excel Experts I need urgent advise on how to do a custom search input text in combo box under protected sheet. The property of combobox is unlock as well as all the cells link to that box are unlock. Below are vb code for this combo box. Private Sub ComboBox1_GotFocus()...

I have a user form with several option buttons After selecting an option button and clicking on Ok, I would like the button to show the last option button selected it would be appreciated if someone could advise me how to do this

Morning, I see this code a few times on my worksheets but dont know what its actually doing,please can you advise. Private Sub Worksheet_Change(ByVal Target As Range) With Target If .Column = 1 Then Exit Sub If .Column = 7 Then Exit Sub If .Count = 1 And Not...

Hi , I have values across row 4 from col A to Col AA that I have to concatenate and separate by commas. I believe I saw a third party solution with a custom MConcat or something like that. Can someone advise best way to concatenate without typing out A4&","&B4 etc... Thanks

Hi, As per titlae i have a vertical button & would like to have text top to bottom as opposed the normal left to right. Is this possible ? Please advise Many Thanks

Hi, I have built a scrolling timeline to select a month, but I would like to get month that has been selected to incorporate into another formula - is there a way to do this? Would appreciate any advise. Many thanks Ian

I would like to know in one needs to import each file one by one into separate sheets and then merge these. If not please advise how to go about importing several CSV files into one sheet

Hi, I tired to post HTML code here to ask help. But I don't how to post the HMTL code here. Please assist.

Hi, I need to use VBA code to copy a line from the first worksheet to the second worksheet in the same workbook. the line would need to be pasted to the next empty line. I downloaded a fact sheet from called Range.Copy (Bill Jenson) dated the 06/08/2017 and copied the sample code verbatim...

Hi, I am wanting to have a one page Sheet so i can print it out on the A4 paper. What i am doing is coloring the cells yellow at present to show my the point at which my preview shows me 1 page of 2 I can then delete that row / column etc and then i have my one page template as such,with me so...

Dear Sirs Good afternoon , i m working on term loan sheet with moratorium period only the interest will be paid first and after couple of months will start paying Principal and Interest Kindly advise how can i use the excel to prepare a formula for that . Thanks & Regards Najib ABboud

Hi, Could you advise the code for the following please,i will then continue from there with the others i need to do. I will add this to a button to transfer cell vales to my end of month sheet. Worksheet called INCOME1 Copy cell value E32 & paste to Worksheet path shown below...

Good morning I have VBA to hide the formula bar/scrollbar etc on my spreadsheet. However, this seems to then replicate this action on any spreadsheets that are opened. I only need it in a specific workbook only, and I do not want it to affect any other workbooks. Can anyone please advise if...

I'm trying to write a macro that will open up all files in a given directory. That bits not an issue. However I want to loop through a specific row, outputting the following in to a Destination Sheet A & row = Workbook.name B & row = Cell.value C & row = value of cell 10 rows up from commented...

Hello, I have an excel sheet and I am trying to find the most secure way to protect it from being modified. I know that sometimes even if you lock the cells if someone save it as then the excel can be modified. Can somebody advise?

hi I have a date range in column A and I want to sum each of the values in H and I is the date in A matches Z so but my formula doesn't seem to like summing H and I. It work fine with one of the columns but not both. The formula I'm typing is =SUMIF(A:A,Z4,H:I). Seems straight forward but i...

Hi All, I want to type say 042/18 into any cell in column F and need to to automatically show as PRI042/18, can anyone advise how I go about this please. I have only basic knowledge of Formulas and Codes. Thanks Shazz x