if and then

Hi all, I am new to using VBA and new here as well with my first post, but hoping someone can help solve an issue I'm running into. Please forgive any omission errors and explanation shortfall. In a worksheet, I am pulling data in from an outside source into columns I:M (with varying...

Hello, I'm looking for a formula that would turn a cell a certain color (the intricate part is I need it to read a code from another formula where the name that will be placed which will be in a different spot everyday will look up a certain code like AA. If the name does not have an AA beside...

How do i create if/then using multiple cells? For example, I have data that i want to compare from D50 to D55 and i want to create and if and then statement saying that if all the values from D50 to 55 are greater than a number, then it passes. I wanted to do this for multiple groups of cells...

Hi guys, New to the forum, and also pretty much a newbie when it comes to Formula/VBA for Excel. I'm trying to get some VBA code working (as I know I would be unable to do what I need with a formula, due to the size of it) but I'm not sure where to start. Basically, I'll lay it out logically...

I am struggling with a formula and have read (and benefitted) from some earlier threads. However, looking for the elegant solution that may not exist... I'm building a scheduler for a team of 200+ individuals. I have 50K rows of data with a large number of columns. I'm trying to build a...

Hi there I wonder if anyone can help me with this. I need VBA code for: If Range(F2)greater or equal to 90000 and (H2) = 90000 the (J2) ="Gold' else if (F2) = smaller than 90000 but greater or equl to 70000 and H2 = 90000 the H2 = Silver Hope this makes sense and that someone can help me...