code & formula

Dear all, This is my first time here. Could you please advice me with this question? I already try to search but couldn't find the answer. Each worksheet called "Project 1, 2, 3, ...., 10" and have 5 questions which each question has drop down to choose 3 variables (YES-2, PARTIAL-1, NO-0)...

Dear all, This is my first time here. Could you please advice me with this question? Each worksheet called "Project 1, 2, 3, ...., 10" and have 5 questions which each question has drop down to choose 3 variables (YES-2, PARTIAL-1, NO-0). And I want to sum all of 15 questions in another...

Good Morning All, As always I like to start off my posts with saying thank you to everyone who responds and provides assistance. I have a tough one to crack...I need to create a code/script that sorts 5 columns of data. First column is (A) last name, first name (exact format). Second column (B)...

Hello all, Please help. So I have one column of information that is inconsistent to say the least. It has different spacing, hyphens, wording. Essentially it is a comment box filled with different information. What I need is a script or mechanism to only search certain numbers and text 1) 2...

I’m working on a VBA formula for a weekly schedule that will fill in cells with the current date and time when clicked. That part I have figured out with the formula below: Private Sub CommandButton3_Click() Sheets("Event Scheduler").Range("K20,K35,K50,K65").Value = NOW The Command...

I’m working on a VBA formula for a weekly schedule that will fill in cells with the current date and time when clicked. That part I have figured out with the formula below: Private Sub CommandButton3_Click() Sheets("Event Scheduler").Range("K20,K35,K50,K65").Value = NOW The Command...

From Columns AN to BB (15 columns in total), I have a match/index formula that needs to be inserted every 11th row. Does anyone know of a VBA code to perform this? Note: each of the 15 column is a unique match/index formula catered to that specific column cell. Thank you in advance, Kim

Hi, I'm having two issues with my code: the first is, I'm trying to match part numbers I pull in from a database to excel with a part description master; the second is I'm now receiving an error that my procedure is too large to compile. Background on the first issue: I receive a text...

Hi Does anyone know how to remove (Blank) from a tile when no data is present and replace with a zero? im new to the tool so any help will be greatly appreciated Rosco

I am a pharmacy student in serious need of help for my internship. I need a macro/vba code that auto generates when there is cell content in a row of a worksheet. this number is going to be an invoice number. I current have a 'masterfile' that records all finalized orders for each facility...

Please help; I have 7 lines of code setting a variable to a formula, first 3 which vb accepts and the last 4 are rejects with the runtime error 13 type missmatch. Can anyone please help me understand what I am missing here with the last 4 lines of code? All are variables are dim as...

Hello, I have the following function: Function Fun(z) Fun = z - x - (((((z - Dato1) * Dato1P) + Dato3) - (((((z - Dato1) * Dato1P) * Dato2) + Dato4) * R)) - Dato5) End Function There are several varibles within it, the thing is that it just does not work, for example: Fun(20) returns 20 What...

Hi all, I'm new in forums, so I apologize if I do something wrong. I have a question about using VBA for setting a formula. I have to do this: 1-Save a result from a formula in the file "Macro" in a variable called "var" 2-In the file "model" save the formula in a variable called "pivote"...

I would like someone to help with writing a code to be able to enter a number in one text box and have the program use that number to search find it in column A and then display the correlating column B data in another text box. If this is not possible please let me know. Ian

Hello, I'm currently building a disciplinary report log for work. The design of the log is simple; I have a table in Sheet 1 with rows corresponding to employee names. Each column represents a general category of possible infractions (e.g. safety; cell phone usage; failure to comply with...

Hello, Im making an invoice and need some help! How can I create a formula that automatically calculates the 'Total' considering that the prices (Price 1 and Price 2) are in the same cell, separated by rows, and in a 'number/text' format (50EUR)? Also, how can this formula calculate new prices...

I have an issue which i can't solve.I wrote this code: <code>Private Sub CommandButton2_Click() Sheets("sheet2").OLEObjects("CheckBox1").Copy Sheets("sheet3").Range("V7").PasteSpecial End Sub</code> This code copy a checkbox from (sheet 2) to (sheet 3) starting from V7 cell. Now I want...

Hi Guys, Is there a way we can filter list based on the number of character in a cell from lowest to highest using code alone? Sample Below Sa1 Sample 23 Samepl Samples Output Sa1 Samepl Samples Sample 23 Thanks,

Hi everyone, Good day to you all. A couple days ago, a kind sir by the name Mike Rickson gave me a macro to extrapolate a set of random numbers from a given range of numbers from column A:1 all the way to A:49 sitting on 49 rows. At the moment i am concerned for his wellbeing because he...

Hello! I am fairly new to this level of excel and any constructive applicable help is greatly appreciated! I am trying to create a form, that once the row is completed, it will create a new blank row, but which contains all the formulas of the previous row. My form, has date formatting...