kelly

  1. Dazzawm

    Formula To Randomise Names

    I have a list of names layed out like below. I need a formula please to randomise them so no name is next to each other in the list. Thanks. <colgroup><col></colgroup><tbody> Louis Pearce Louis Pearce Louis Pearce Louis Pearce Anthony Ray Clive Kelly Clive Kelly Clive Kelly...
  2. P

    INDEX/MATCH Issues

    <tbody> Name Type Clean Data DOGS CATS FRANK -DOG DOG FRANK JEFF JEFF -CAT CAT AMY KELLY KELLY -CAT CAT AMY -DOG DOG </tbody> I'm trying to grasp index, match to work on a spread sheet. All of the other questions I find are not helping all that much...
  3. B

    Extract Value that appears >=N times based on a criteria from a different column.

    I have tried searching and google with minimal luck. I am trying to help someone who is not excel savy at work. I am trying to extract a value that appears x times or more based on a criteria that is in a different column. For example, the report below has data on all the cost centers (column A)...
  4. kelly mort

    Summing with vba

    Hello Geniuses, I have a challenge here and I need some bailout : I have used this to sum up some data in my worksheet . But now I want to add more than one column. Me.TextBox1.Value = _ WorksheetFunction.SumIf(Sheet1.Range("B7:B1007"), _ Me.TextBox2.Text, Sheet1.Range("F7:F1007"))...
  5. kelly mort

    How to calculate only selected sheets

    Hi, My workbook is growing and the calculations is slowing me down. Is there a way to calculate only some sheets in the workbook? I will be glad to know about that. Thanks in advance Kelly
  6. kelly mort

    Display workbook name

    Hello All, I need a macro to show me the name of my active workbook in a message box. I want to use that to do something Else that's very complex I can't explain here. So I just wanna know how to get the message box display that then I implement it. Thanks Kelly
  7. kelly mort

    Adding only positive values with sumifs

    This is the formula I have now: =Sumifs(p2:p10,g2 :g10,"x",f2:f10, "male") How do I add only positive values in p2:p10? Thanks in advance Kelly
  8. kelly mort

    count formula needed

    I wanna count with these criteria: Col A Col B Col C Type Sex X M X F Y F So I want to count how many F are there for X How many F for Y. How many M for X etc. Thanks in advance. Kelly
  9. kelly mort

    issue with multipage userform

    Hello all, Is there a way I may restrict access to a page on a multi page userform? Thanks Kelly
  10. kelly mort

    Auto completion in textbox

    Hello all I have a challenge here: I want my textbox to behave in such a way that when I start to enter data in it, it should look at a range in a worksheet and then suggest words or names as I type the letters. So say I have a name "Kelly" in that range, when I start to type "K" , it should...
  11. K

    Index Match to count occurances

    Good Morning, I am looking for a formula which will match name to name and count how many occurrences of 'x' within a certain range. I am thinking it will be an index match with a count if but i'm struggling to put it together. I have a list of names and I want to know how many holidays they...
  12. kelly mort

    OptionBox challenge

    Hello All, I am having issues with how to select an optionbox when I change the content of a combobox. If there is a way out then let me know. Thanks. Kelly
  13. kelly mort

    Multiple Image Format On UserForm

    Hello All, Me.Image1.Picture = LoadPicture(fPath & "/" & Me.ListBox1.Column (0 , i) & ".jpg") How do I get other formats to work in addition to the jpg files? Thanks Kelly
  14. kelly mort

    save workbook when userform is closed

    Hello all, I wanna save my workbook when I click the close button on my userform form. How do I code it? Thanks Kelly
  15. kelly mort

    prevent screen pop up

    Hello All, I want to stop excel from showing MsgBox when I double click on locked cells. Thanks in advance. Kelly
  16. S

    <VBA> Looping and Copying

    Hello All, I've been trying to figure out how to write a VBA macro to loop through the cells of a column, matching cell(s) with a criteria, copy a cell from that row to a different sheet, and then print a specified selection. This table is located on Sheet "Data". I need to loop through Column...
  17. S

    Looping, Copy Cell, Paste Cell, Printing

    Hello All, I've been trying to figure out how to write a VBA macro to loop through the cells of a column, matching cell(s) with a criteria, copy a cell from that row to a different sheet, and then print a specified selection. This table is located on Sheet "Data". I need to loop through...
  18. kelly mort

    Macro to hide Ribbons

    Hell All, I need a macro that will hide the ribbon tabs and show only the working area when i open my workbook. If this is possible then somebody should help me out. Thanks Kelly

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