required

  1. Q

    Object required error

    MREXCEL Can you please help on this. I've got a combobox in a userform. I'm trying to assign a variable called shtRB to different worksheets depending on the cb selected value. Private Sub CommandButton1_Click() Dim shtrb As Worksheet Dim namecell As String Dim datecell As Date If...
  2. P

    Cel.Offset with InStr

    I am trying to not include cells which contain certain strings in my For Each Loop. I have the following: For Each Cel In Rng If Cel.Offset(, -5).InStr(1, Cel.Value, "Part of" Or "NOT REQUIRED" Or "Need breakdown for") Then GoTo Skip 'the -5 is trying to Offset to the left rather than...
  3. C

    Using VBA to create VBA

    Hi everyone, So i have a workbook which is a tracker for FSR visits to various sites, as well as support log to collect customer questions or issues. Within the workbook the first thing you'd see is a homepage with buttons which will open only the required sheets for the buttons selected -...
  4. Sean15

    How to fix formula returning "FALSE"

    Hi: In column I, for example, All values for "Alice" needs to be summed or grouped together to the first occurring "Alice". All duplicates of "Alice" need to show 0 but formula is returning "FALSE" Could you fix formula please? <b>Excel 2010</b><table cellpadding="2.5px" rules="all"...
  5. R

    Need concatenated data as

    Hello, I need the output from given information: Here is the data information: <tbody> No Mar May Sep Dec 20 5 11 7 20 8 21 9 2 21 5 7 </tbody> The output required: 6 digit unique number for each row i.e 100011 + No + 2017 + Month Number(3) + 31 + amount (5) so for all...
  6. N

    [SUMIFS] Counting number of occurrence within a time period

    Data <colgroup><col span="3"><col></colgroup><tbody> START END VEHICLES REQUIRED JOB 1 1:00 2:10 2 JOB 2 1:00 2:10 3 JOB 3 0:55 2:05 2 JOB 4 0:35 1:45 2 JOB 5 0:25 1:35 2 JOB 6 0:20 1:30 2 JOB 7 0:00 1:10 1 </tbody> Required end product (Sheet2) How many vehicles...
  7. O

    Run time error 424 (Object Required)

    Hey all, I am having trouble with this code.The red highlighted line is giving me a Run Time Error 424 (Object Required) Private Sub Workbook_SheetChange(ByVal Sh As Object, ByVal Target As Range) Application.EnableEvents = False Worksheets("HSheet").[B3] = Worksheets("HSheet").[B2]...
  8. M

    Object Required

    Hi all, It could be that I've been at this for too long and I now can't see the obvious errors. I cannot get past the "object required" error - by the autofilter line- Any help will be greatly appreciated. [Code] Sub copysubpanel_NTC() Set FPNTC = Sheets("Full Panel NTC check") Set SPNTC =...
  9. R

    DATEDIF Months

    I have the formula for the duration of months between 2 dates. However, I need to add 1 month if the end month days is greater than the beginning month. See below for example; I tried using EOMONTH, but that doesn't seem to do what I need it to. The following Code goes in the Months Required...
  10. T

    Update a Named Range from a Drop Down Box

    I have a sheet that contains a Data Validated drop down. There will be occasions where the drop down does not contain the required value. So, I want to give the user the ability to type the required value into the drop down and it will then add it to the named range. I have already set up a...
  11. M

    OR statement producing N/A

    Hi, I am expecting the result to produce "NO APPROVAL REQUIRED", but it is coming up with N/A. is there something wrong with the formula? the VLOOKUP result of F16 does match Q4 =IF(OR(VLOOKUP(D16,'Approver Data'!O:R,4,0)=Q4,VLOOKUP(F16,'Approver Data'!C:F,4,0)=Q4),"NO APPROVAL REQUIRED","")...
  12. R

    Required VBA Code to calculate between different table

    hi all, i was looking for a vba code to calculate between two table's by using user form to select between table's Sample: Table1 Table2 ..... ..... Table 10 in user form required Table name 1:{Drop down list of tables}table4 Table name 2:{Drop down list of tables}table6 calculation i...
  13. U

    TextBox entry required. How to code?

    TextBoxes 4 thru 21 require a numeric value to properly process the procedure. Instead of inserting 18 instances of this code, how can it be written to loop thru the 18 textboxes and set focus on the appropriate TextBox? Even better, MsgBox would indicate the missing value (i.e.: "Value Required...
  14. C

    Multiple Worksheet_Deactivates

    Hi Folks I have the following code that basically does not allow someone to leave the sheet they are on unless all required field are complete. It works perfect for my needs My question is is it possible to have more than one worksheet_deactivate say for Range A2 with a different message...
  15. S

    Calculate required % by month to achieve target

    Hi Excel Masters. I'm working on a spreadsheet and i'd like some guidance how to build the formula. I have an end of year target of 5% (average) across 12 months. I want to create a table so when i input each month actual % it should tell me the required % for the remaining month in order to...
  16. Y

    Macro to calculate budget required to achieve productivity target

    Hi everyone, I run a factory team of 20 members and I am trying to put together a sheet that can calculate the budget required for each employee to hit a certain productive target. We do this exercise twice a month (mid and end of month) I have uploaded the initial draft of the template I have...
  17. B

    Option required

    Suggestions on how to add code to require Option? UserForm1 includes 2 OptionButtons If neither OptionButton is True Then MsgBox "Option Required" Private Sub CommandButton1_Click() With Sheet11 Sheet11.Unprotect Set ws = Sheet11 PName = UF1.ComboBox1.Value Set CLoc =...
  18. jim may

    CSE Formula Required

    I have below range of Text Values - I wish to have a formula in Cell B85 as follows emtered with CSE to produce({}): to get result of: 190.51 <tbody> ={SUM(LEFT(B72:B84,FIND(" ",B72:B84,1)-1)+0)} But I'm Getting #VALUE ! How do I need to Adjust above existing Formula? </tbody> Excel 2010...
  19. M

    Excel Corrupted file

    i have an excel file which was protected. somehow it got deleted. i recovered back the file using a software but i can not open it now. it gives the error file is corrupted. is there a way to recover the data?? i can mail the file if required. pls help...!!!
  20. A

    Formula required

    If B3 contains text and F3 is blank, I want F3 to be counted. Could I have a formula that enables this?

Some videos you may like

This Week's Hot Topics

  • VBA (Userform)
    Hi All, I just would like to know why my code isn't working. Here is my VBA code: [CODE=vba]Private Sub OKButton_Click() Dim i As Integer...
  • List box that changes fill color
    Hello, I have gone through so many pages trying to figure this out. I have a 2020 calendar that depending on the day needs to have a certain...
  • Remove duplicates and retain one. Cross-linked cases
    Hi all I ran out of google keywords to use and still couldn't find a reference how to achieve the results of a single count. It would be great if...
  • VBA Copy and Paste With Duplicates
    Hello All, I'm in need of some input. My VBA skills are sub-par at best. I've assembled this code from basic research and it works but is...
  • Macro
    is it possible for a macro to run if the active cell value is different to the value above it
  • IF DATE and TIME
    I currently use this to check if date has passed but i also need to set a time on it too. Is it possible? [CODE=vba]=IF(B:B>TODAY(),"Not...
Top