i.e

Hi MrExcel, I created a generic userform which can work with multiple worksheets. I have a macro in a module that will execute some code to export the sheet to another workbook. (i.e. macro name = Export_BOM_CostSummary() , or Export_BOM_PcsPc() etc.) The sheet that I want to export has a...

=IF(ROWS($A$28:A28)>COUNTIF(Utilisation!C62:C68,"Paid Breaks"),"",INDEX(Utilisation!A62:A68,SMALL(IF(Utilisation!C62:C68="Paid Breaks",ROW(Utilisation!C62:C68)-ROW(Utilisation!C62)+2),ROWS($A$28:A28)))) Is there any way to amend this formula so that it searches all of column "C" for the word...

Hi all okay - hoping you can help with some VBA here... at the top of 52 columns I have the date of the first day in each week - as per attached screenshot; I want to group all past date columns together and all future date columns. Obviously I can do this manually, but I'd like to automate it...

I have a worksheet that has column A (state) and column B (individual ID #). I need to review 100% of AZ, FL, IA, TX. But only a random 15% for every other state (i.e. 15% of HI, 15% of NY, 15% of TN, not an overall 15% if the remaining states). Can someone help me to write a formula for this?

I have a form with about 10 check boxes on it that are ticked when answering the questions. I want a button that someone can press that checks all the boxes at once - i.e. a "yes to all" button. I also want one that clears them all as well. Can anyone suggest how to do this? Thanks :confused:

Is there a way to set up a userform where it will show one option (i.e. a dropdown list) when one factor is selected but show another option (i.e a pure text box) when another factor is selected? Or do I need to create two separate userforms and then depending on which factor is selected that...

<colgroup><col style="width: 25pxpx"><col><col><col><col><col><col><col><col><col></colgroup><thead>#DAE7F5[/URL] "] A B C D E F G H I </thead><tbody> 1 #FF0000[/URL] , align: center"]ID #FF0000[/URL] , align: center"]Stage #FF0000[/URL] , align: center"]Country #FF0000[/URL] , align...

Hi all Firstly thanks for everyones help previously. Greatly appreciated and helps my knowledge no end. In Range"C16" - if it contains a value i.e. - "XXX" then y screen resizes. There is code of Application.ScreenUpdating = TRUE After this, I do not want anything updated if cells C17:c20...

Hi guys, I am trying to create a sample timesheet. How do I copy the exact same content (i.e: date or number that's on A4 - if it has data) to another cell (i.e: H4) automatically? Is there any formula that does this function? Thanks in advance. Much appreciated.

Hi, I am new to VBA and trying to get to grips with it. I have a large list of phone numbers that are in different formats i.e. 01234 456 789, or 01234 456789 ect. I have managed to clear all spaces out to leave continuous numbers, now I want to insert a space after 5th digit of the area code...

Dear Gents, I've got a data prepared by dates since 5 yrs back till today. I'd like to analyse the first year and the second year...etc. and from the inception to 5 yrs. i.e: <tbody> 08/01/2017 <tbody> 09/01/2017 . </tbody> </tbody> . . <tbody> 11/07/2018 Hope is clear...

Hello there! I have several forecast models linked to various source files (i.e. sales volumes) and some linked to each other (i.e. staffing model pulls actual from finance model and finance model pulls forecast from staffing model). If I open two files at the same time from Windows Explorer...

Hi everyone! Pleasure to have become a member of the community. I hope to become a net contributor to the board in the future. Alas, now I will posting (hopefully) pretty basic stuff. I mostly self-taught myself Excel and became pretty proficient from my former job in benefits (typical basic IF...

Hi I have a formula : =sum (E106: E108) i wish to copy this function to the cell below and add three rows i.e the formula should no read: = sum (E109 : E 111) i.e just as if i copied it dowm three rows. Any ideas , I have many cells to copy down. Thansk Mark

I want to do an index match, with the ARRAY being dependent on what the user selects from my dropdown box in cell B3. Depending on what they select (it will be days of the week, i.e. Saturday, Monday, etc.), I want the named range reference to change (i.e. if they select Saturday, I want it to...

Morning, I need a little bit of help please. Simply, I have a start date/time and an end time/date, and I need to split out the total number of hours (or decimal days) in the range so that they are apportioned to each day that they fall in: Data: A2) arrived date/time 01/02/2018 09:00...

Hoping someone can help! In Columns A2:A1000 I have dates. The column is ordered by most recent date first (i.e. A1 being todays date). In Columns B2:B1000 I have a series of numbers labelled with column heading 'High' (in B2). In Columns C2:C1000 I have a series of numbers labelled with column...

Hi, I had a formula which worked out the sumproduct large for a range of cells which excluded the highest figure. =SUMPRODUCT(LARGE('Stableford scores Summer 2018'!B5:AG5,{2,3,4,5,6})) The problem I have is that I don't want to include the value in every other column i.e C5,E5,G5 etc. Does...

Is it possible to have a tick box (or alternative?) in a cell so when it is ticked it scores a number specific to that cell in an overall score. For example, if I have questions in column A and then 3 answers in column B, C and D that are tick boxes (i.e. with heading above them bei9ng Yes...

Hi all, I have tried a couple of formulas for this problem but the "variable" part is causing an issue. I have two columns with variable data, duplicated data in. I need a formula to look at one of these columns and pull through a unique list (i.e only one of each value) based on a...