required

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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