status

Hi, can anyone advise what type of formula would be best if I wanted to create a dashboard that listed the last 10 transactions based on multiple criteria? In my case it would based on the account status, i.e., Approved, Declined, Pending and the second criteria would be the submitting broker...

Hello, I have a large data set in tab 1 and in column T there are statuses (Active or Retired). what I would like to do is create a new tab (tab 2) to only show those individuals with an Active status. So every time I change the status to Active in my first tab it would populate into my new tab...

Small spreadsheet with 3 columns - first name, surname and status. Status can be any of several options including “withdrawn”. Filter to hide rows with “withdrawn” status works fine. Rows disappear as intended and filter is still in place if workbook is closed and re-opened. Problem - i am...

Hi all, im a complete novice at excel, and literally have no clue what im doing but have a work issue im trying to resolve. I have a spreadsheet (Sheet 1) listing current relationships held with other institutions; Current Columns range from A to K (but could be expanded in future). Column H...

Hi All, I have a sheet that keeps track of tenants and their status. Data is kept on multiple sheets. I would like to have a pop-up come up requesting a date when the status of an entry in is changed to "notice" in table named tblTenants and the date is populated on in table tblUnits for the...

Can i have a table of conditional formatting color buttons that change as the color of the cell of other table changes Example : I have two tables (1). shift table and (2) status table 1. Shift table is the monday-friday table with 3 shifts of 8 hours each and each shift is divided into 4...

Looking for help with the below.... Basically, I want to track the status of an item. If i am to enter a date lets say in column C which is titled " Item setup date" i would like the status in column B to automatically change of i enter that date. But again, if i enter data further down...

Hi I need a smiliar vbs but with Sub, not function which able to update the status on Col J when i activate the macro. It will left a remarks Directory & Link Ok File was not found in folder The best if can differentiate which one is Folder, which is link :) <tbody> H I J FOLDER Path...

Hi all, So I've started working with VBA a bit and have figured out what I'd like to do and that it is possible, I'm just not skilled enough to be able to write it from scratch. I've always found it easier for me to work with existing code and learn what everything does by modifying parts of it...

This is hopefully a simple one. How can I count records based on criteria? So it would be a count of 'Active' ('Status' Field) for each 'Group'. I'm looking to go from something like this: <tbody> Group RecordID Status ABC 0001 Active ABC 0002 Closed ABC 0003 Active DEF 0004 Active...

I have 2 queries: Both Queries have the same fields and are based on the same table (tblBusinesses) but have different criteria <tbody> Query Name Criteria OpenBusinesses 'Status' field equals 'Open' ClosedBusinesses 'Status' field is not equal to 'Open' </tbody> Is there a way to find...

Hey everyone, I'm facing the following problem: I have a table where Column A gives me Names and column B gives me the status "done" or "ongoing". I have a ListBox that populates with all names from column A. I want to be able to select an item in the List and click a button to change the...

There are 5 candidates with 4 favorites sports. WD denotes weekday,while WE represent weekend. If the candidate takes part in a sports, the status will be "Y" and "N" if the participants did not take part in the sports. The tasks here is to write VBA code to extract data with status "Y" on...

Hey together, I am just aiming a pretty simple problem. I have the following table: <colgroup><col><col><col span="2"></colgroup><tbody> DOC UNIT DATE Status 40017280 A 02.05.19 00:00 15 40017281 A 02.05.19 00:00 17 40017282 A 02.05.19 00:00 5 40017283 A 02.05.19 00:00 5 40017284 A...

So I have this sheet. In J:J I have selectable lists to show a status (Open, Closed etc). When this status is changed I have the date of the change automagically entered into another cell K:K. I also want it to copy the new value of the changed cell and the date in the K:K Cell into a seperate...

Hi! :) First time posting so i apologize in advance if i don't explain the issue i am having as well i should. I have been asked to create a spreadsheet with gantt chart for the purpose of monitoring the status of a project. I've been told to keep it simple with the inclusion of a few visual...

Hi Excel Experts, I have 2 excel sheets (Sheet 1 and Sheet 2) which has ticket number and status of each ticket. Sheet 1 is having Old status and Sheet 2 is having new status. I just want to know all the tickets, which are the status changed from sheet 1. Please find the attached image for your...

Morning All, I'm currently just starting out using onedrive and am having trouble getting some of my documents on my computer syncing with the onedrive counterparts given that it seems to be taking a very long time is there any way of creating a message box to show the status of the sync and...

I am trying to send a progress message from a custom VBA function - I get no errors, just never see the messages on the status bar. I have stepped through the function and confirmed the display command is executing. I can run a SUB from this same workbook/module and see the status bar updated...

On a Form, there is a Combo Box Field which lists different Statuses (e.g. Open, Pending, Closed). Is it possible for the following to happen? When 'Status' is changed from 'Open', add the sentence to the end of the text field 'Comments' to be something like this: "05/05/19 - Closed - J.Smith"...