kelly

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

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

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

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"))...

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

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

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

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

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

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

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

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

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

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

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

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

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

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