status

I first need to find a value in a cell and then store the range of that cell. the below code in VBA stores the email NOT the range of the cell. thank you for any help - Eileen Dim occurRange As Range Windows(CARDfile).Activate 'cardholder summary file With Range("Z:Z") 'EMAIL Do...

Hello all! MrExcel newbie here. I'm trying to create an If statement, I'm assuming an If statement, that can define a cell based on where it falls in a range of numbers. It's for housing development project. I'm attempting to solve for the Status As shown below, if the resident earns above...

I am trying to write a VBA that will take info from 1 document that has employee/current status/time started status. I have a second sheet that has all employees and their listed start time. I need the vba to check if the employee is in another status other than Loggedout and check them as being...

Hi - I am trying to create a stacked bar chart to show the life cycle of the status of a job. Say the job changes between 3 different status' multiple times. eg: 1 day 'with customer', 1 day 'with support', 2 days 'awaiting information', 2 days 'with support', 1 day 'with customer' When using...

Hi all. For a workbook I'm building, I'm displaying some information on the status bar, so the user can always see it, no matter what worksheet they happen to be on. I updated my Excel 2016 (for Windows) the other day for the first time in a long time. (I had Office updates turned off for the...

Hi friends Brand new to coding. In a VBA class as we speak so be easy! I have pieced together code that checks if a long list of website links that are managed by external parties are still working. If there's an error code associated with the site, it returns the code and puts it in the...

Hi All, I've written the following script: So what I want to do is to loop this through all cells with a value in it. For example where it currently says ws.Range("a4") it must move to ws.Range("a5") and when it currently says ws.Range("b4") it must move to be ws.Range("b5"). Also the...

Hoping for a little help with the updates to this code indicated below. Really appreciate your time and input and sending the most positive karma your way! - The Cat Ladee Sub ValidateURLs() Dim Cell As Range Dim Rng As Range Dim RngEnd As Range Dim Status As String Dim...

Hi Forum Hope all is well. I have a question on how to populate a selection filter from a column in a another worksheet Sheet 1 I have three columns Name Type Status Sheet 2 I have three lists List of Names List of Types List of Status In Sheet 1, When I select the first cell...

G'day Everyone, I hope you can help me with a counting issue. I have a spreadsheet that tracks project status changes that's updated weekly. Every week project managers show their overall project status using a RAG status. The colours correspond to numbers as below. Green Amber Red I want...

As you can see from this screenshot, the status bar in Excel for Mac is not showing the sum or averages. I've been using Excel for Mac 2011 for years and the sum has always been there. I also refuse to upgrade to Excel for Mac 2016 because I tried it for about 3 weeks and discovered that it was...

Hi Everyone,:cool: I am in urgent need of vba code for my reports Attached is the sheet of my documents I get it from different vendors. Column AA contains the different status (e.g. Pending from vendor, Pending for OGC response, Pending for OGC submission etc. etc.) I want to have a...

Hello all, I need your help in making of my file tracker sheet. My sheet is looks like below: ******** width="450" height="270" frameborder="0" scrolling="no"...

Hi all! Can someone please help me adjust the underlined below to include the equivalent of <>"200 - OK" or "301 - Moved Permanently"or "302 - Moved Temporarily" or "302 - Found" Then Thanks so much for your time! - The CatLadee:) ----- Sub ValidateURLs() Dim Cell As Range Dim...

Happy Monday! Hoping this is a quick and easy one for you all. I have four fields: Column AE: Order Status Column AF: Order Status Date Column AG: Billing Status Column AH: Billing Status Date I need to write a formula that returns the days between the Status Date and today IF the Order...