if-statement

I'm new to coding, but i have an excel map with a list of attributes of employees. Now i got the task to create an excel map, that, if the cells value are above a certain value, the cell is colored green. My code works fine if i only have one condition, but with three conditions it doesn't seem...

Hi I would like to know if it's possible to have a formula that says If column C has "&" then add the values of the respective colors from column B to column D. So basically if I did it manually, it would look something like in column D. It has to dynamic in a way that no matter how many "&" a...

I need some help with do an "if" statement. I want to have vba look at a column and to see whether or not there is a value in that column. If there is, remove all the blank cells above it so that it moves to the top. If there is no value then this code doesn't need to run. If not running the...

I am exporting an excel file from a software, and the following is the picture of it: Here for some fruits there is both In and Out where 1 represents In and 0 represents Out. Here is what I want to have: 1) Delete all the rows the first two times they appear for a particular fruit. For ex...

Hi, I have a list of "Customers" in column A (A2-A270) in my first tab. In columns B-G (listing "Item name" in B1-G1) I have listed a year slash a number: e.g. 2018/1000 (years ranging from 2017-2020. What I want to do is to be able to form a table per customer in a secondtab depending on which...

Hello, I'm trying to catch a weekly task in a vba code: calculating the work days between date of delivery and date of return. Sometimes, I do not have a date of return and in this situation the code should loop to the next y. The error I got back is 1004: "Application-defined or...

Hi, Have a big problem - don't know If its possible to solve it with VBA. If the socialsec, date, fruit is same then save it into a temp or something sum quantity and print out as 1 line else different rows. Have a sheet with following data: SocialSec Date Fruit...

Hello, Have an question abort mycket dateadd function. X = 7 If DateAdd("h", 1, sheet1.cells(i, 6)) * 24 - x) > "" Then ... ... ... Can't get it work :(

Image codes: Screen Shot 2014 05 29 at 10 15 06 PM So, this is what I have [above] (not exactly, but an example) in sheet 1 of my excel doc. I want to be able to get the value for say D3 of the above sheet from the following sheet [below] (sheet 2 of my excel doc). Image codes: Screen Shot...

Hi, I have an big problem! When I want to read the time from an time formatted cell it instead of 07:45:00 it Excel reads it as 0,322..... This is the script I use: If Range("Z1") > "" Then ............... .............. .............. ............. I'm greateful for all help I can got! Thanks!