true;

I am trying to total project amounts that we have "WON" On tab BID STATUS in column "D" I have the salesperson ID "FRE102". In column "F" I have the status "WON, LOST or WAITING" and in column "G" I have the $ value. On the TOTALS tab I have a cell I want to give me each salespersons total is...

This is my Current line of Code on my sheet. Its purpose it to autofill a blank cell with a remaining value. My goal is to apply this same code two more times for two other independent range of cells. The Second range of cells is K4, N4, and P4, and the Third Range of cells is V4, AC4, AG4, AK4...

Hello, I'm using Excel 2010. I use dynamically named ranges to grow and shrink as the data grows and shrinks. An example is here: =OFFSET('All PO''s'!$C$9,0,0,COUNTA('All PO''s'!$C:$C)-3,COUNTA('All PO''s'!$9:$9)-2) When opening a workbook linking to another workbook with one of these...

Hello, I have a macro that will duplicate the value cells C3:C10 to the cell in column B directly next to it. So, if C4=Bacon, then it will automatically put "Bacon" into B4. Awesome... now, I need to find a way to have this be triggered by ANY checkbox on the sheet being checked. I can link the...

Hello, I can usually find the answers I need online and modifying to suit my needs, but I'm just getting started in VBA and I have not had success finding a solution for this issue and would appreciate any help. I have a range of cells in column O that I want to compare with the values in...

Hi, I am a novice to vba. I am trying to create a custom function to compare a given date with today's date and if the difference between the given date and today's date is more than 14 days then display the difference in dates in the worksheet cell and highlight it. else...