dynamic cell value

Here's a fun one! I have a gantt chart production schedule (Table 1) I use to show my team the schedule. Supply Chain also uses this tool to do material planning but it is a LONG process since they have to manually look at the gantt chart to see when jobs start or end. What I'm trying to do...

Hello, I'm trying to create a formula for column C in the examples below. Column B is static, it never changes. I included it in case there's a clever way to use it that I'm not seeing. Column A is input by the user. I've been at it for a while and can't find a solution. Basically I want...

Hi Experts, This is what I'm trying to do, I have three columns with the name as Zone, City and Sale respectively now I drew a pivot and put these things as following, Zone - In Report Filter City - In Row Labels & Sale - In Values Here I am able to view city wise Sale by filtering Zone. But...

Hi there. I need to get a sound alert (sound i want in wav. format) when value in cell meets the criteria. Notice value is dynamically changing. Details: In cell E1 i have entered the =NOW() function. I use a couple of codes to make this change every minute. First code in the sheet itself is...

Hi. I'm a very new to Excel and VBA I have been given a task to improve and automate the complex engineering calculation spreadsheet. The problem is to replace a hidden table values ( which are needed for a final calculation calculation) with on the fly , dynamic calculation ( more elegant...

I need to change the tab color based on the value found under the words "inception difference" in that tab. The tabs have between 1-10 numbers below "inception difference." If all numbers below "inception difference" are negative, make the tab red. If they are all positive, make the tab green...