logic

I am looking for a logic/macro/vba code that will automatically delete certain entries that are older than todays date. At the moment I collect data using the below code: Sub upload() Sheets("Input").Range("C2,C3,C4,C5,C6,C7,C9").Copy Sheets("Data").Range("C" &...

Hello, I’ve been working on this VBA code for a while and since I’m a complete noob I feel like I haven’t gotten anywhere. I’ve been researching a ton, but can’t seem to combine answers to help with my scenario.</SPAN> Essentially what I’m trying to do is grab data, line by line, from one...

How do I obtain this desired result: If M5 contains a date, P5 displays 0; if M5 is empty, P5 displays the number of days passed in the current month (ex. if M5 is empty and N2 displays 3-May-13 then P5 displays 3) N2 displays today's date M5 may or may not display an end date Thank you,

Tracking output quality of two-step process performed on various items. On one worksheet have created command buttons for 1. Employee Name for 1st step of process 2. Employee Name for 2nd step of process 3. Item type process is performed on 4. Quality of item with corresponding reason if...

Hi I want to complete this style of logic in Excel but am not sure how. \\ values in a table B2:M2, they will contain either 3 types of values M100, H100 or NA. After M there may be any different number result between 0 and 100. So (M80, M82, M64 are valid). H stands for Home and M stands for...

Background: I'm trying to help some of my associates keep track of a particular account. There are four primary types of customer interactions they can perform (Activations, Upgrades, Accessory, Maintenance). What I would like to be able to do is have the Consultant choose their name, enter in...

Hello, I am trying to fill in the Net height in the below table based on the Net assignment located next to species. If Net=A then Net height should = 2.6 for MYLU but should be 10.4 for MYSO. I've tried a nested IF function =IF(B1="A",C1 IF(B1="B", D1)) but it returns an error. I could do it by...

I would like to make the if/then formula as follows, but I have no idea how to: IF column C is equal to "15.5g" THEN divide entire column E by 124 AND IF column C is equal to "5.17g" THEN divide entire column E by 43. I would like these numbers to appear in column F. Please help! Thanks -Adam

I am looking for the most simple way to reflect "Y" in C3, from the indication that "Y" is displayed in both A3 and B3. I am very new to lookups, if statements, and all similar functions. I basically want to tell it "if A3 AND B3 are "Y" then C3 should be "Y"". I apologize if the title of the...

Hi, I am looking for some suggestions on why this string isnt working. Background: This code used to be three nested if statements that sepperated people out by thier shift when searching for them using a id (this searched for shift was in a different file, "welder Database") Then I...

Can someone help me with the formula the following please with the SUM Logic function; I am trying to put prices in - so if they select (for example) apple, banana or orange from a drop down list, the price will be $1, but if they select anything else, the price will be $1.15 So, is there an...

Right now I am working with a project management in Excel. On the left, I have a column for the name of the task, a column for the start date, a column for the end data, and a column for the status of the project (Completed, In progress, overdue, etc). To the right of all of these columns I...

Can you use And/Or easily in VBA I.E. Could you say if(And(A1 = 10,B1 =10),or(C1=5,C2=6,C3=7)) So A1 and B1 have to be true, and either of the "C" ranges could be true, for the whole thing to be true? Cheers

Hi, I have a spreadsheet with a set of dates and rent charged on certain dates. Rent changes on certain dates, I would like to automate the spreadsheet so I do not have to manually go in and spread out the rent based on the dates. Essentially this is a rent schedule and I want the total rent...

Hi I am currently trying to get my head around using Excel VBA, and have made good progress over the past year. However, I still struggle tremendously with Loops within Loops, whether they are For Each, Do Until, Do While etc... I have read various books, but still struggle. Does anyone...

I'm trying to come up with a weighted average formula for commodity futures curves. The end goal is to produce a confidence band for where future commodity prices will be. If I simply use a formula that rolls off each futures contract at expiry, the confidence band looks jagged on a graph...

Hi everybody, I am trying to find a way to calculate the amount of hours worked by every employee. Each employee must chek in and out 2 times a day (we get one hour to lunch). The trick here is to find a way to calculate the amount of hours worked during the morning and the afternoon, but I...

Our old system outputs text files of invoices showing the Invoice# in Column C and the various part order lines in Column D. If there is only one part per Invoice the data is fine. But if there are multiple parts being ordered the Invoice# in column C will appear ONLY in Line 1 and not in any...

Hi good morning, I'm almost in the way way to "finish" this spreadsheet. I have 69 codes and each one can have two conditions, this conditions are going to be subtracted from the original operation, the issue I have a large formula (16 rows), I can't place there. I don't wish to place it in...

I am working on a spreadsheet that allows me to manipulate the payroll expenses for the sales force of a portfolio company and the formula does not want to behave. I created a logic statement with absolutes that produces a value of $3000. When this statement is carried over to the five...