advise

  1. H

    Const will not accept 2019.2020

    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
  2. I

    Show userform based on cell value

    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
  3. J

    formula help

    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...
  4. S

    HELP - Custom search text on Combo box under protected sheet.

    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()...
  5. H

    User Form Option Button

    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
  6. I

    Could you advise on this code please

    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...
  7. M

    concatenate across row 4. Use comma seperator.

    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
  8. I

    Vertical text on command button

    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
  9. U

    Get date details from Timeline

    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
  10. H

    Import Several csv files into Power Pivot

    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
  11. S

    Please advise.

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

    Copy/Paste

    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...
  13. I

    A couple of simple questions for a simple user Ha Ha

    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...
  14. N

    Formula

    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
  15. I

    can you advise on code path please

    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...
  16. S

    Hiding formula bar/scroll bar in specific spreadsheet only

    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...
  17. P

    Loop through all cells in a row, action if cell.comment

    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...
  18. K

    Protect excel sheet

    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?
  19. K

    sumif (not working)

    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...
  20. Shazz

    PRI to show when entering text in a cell

    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

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top