status

  1. L

    Change Status When Column Filled

    Hello, i have a data need to be fill when ever i made a progrees. Each column are fill with date the progress made. Is it possible for me to made the last column to state the current progress based on the last column that has been filled with the date? i wanted at the current progress column...
  2. M

    VBA Expiry date with entire row Color highlight & new column with status

    I'm trying to write a VBA CODE example mentioned below. Help on the below-mentioned example A B C D SL NO PRODUCT MANUFACTURING DATE EXPIRY DATE 1 ABC 01-01-2021 01-01-2022 2 XYZ 29-03-2021 29-03-2022 3 CDA 04-05-2019 04-05-2020 4 TWC 23-03-2021 23-03-2021 I want my output as...
  3. P

    Send an email when a cell says something specific

    Hey! This forum has been a huge help thus far, and I am coming here again with a potentially tough one. Here's what I would like to do: When a cell says the word "Active" or "Service Active" it sends my coworker an email letting them know to add it to quick books. Here is what it looks...
  4. F

    Deleting Rows In a Table Based on Data From Another Worksheet

    I have a file with three worksheets. Sheet1 is a summary of all clients. Sheet2 has a table that copies only clients with "active" status from Sheet1, Sheet3 has a table that copies only clients with "buyer" status from Sheet1. Is it possible to write a vba code that will delete rows from...
  5. M

    Best way eliminate rows with multiple status from a count?

    I receive data from our ERP system on vouchers that create errors. I want to have a measure that tells me how many voucher lines were closed within the last week. But... a voucher can create multiple errors - one might be closed during that week, but if the same line has an open error I don't...
  6. K

    display the comments from referenced cell in cell of different sheet in same workbook

    I have a multi page work book and one of the sheets is for marking the status of personnel I reference their status in another sheet, but I would like not only that info to show but any comments that are attached to the referenced cell. Any ideas?
  7. L

    Copy Data From Sheets

    I have a Sheet Named NEA Status and a sheet Named Inventory Stats I want that if Column D in Sheet named NEA Status Matches Column D in the sheet named Inventory Stats move the data from Column H in the sheet Named Inventory Stats to Column H in the sheet named NEA Status.
  8. N

    View active cell value in status bar

    I think I might be going mad. I'm sure that in my previous version in Excel for Mac (2008) I could view the value of an active cell in the status bar. Since upgrading to Excel 365 I can no longer see this info in the status bar. For the sake of my sanity, will someone please help me?:confused...
  9. E

    "Saving" Notification/Status window not closing after VBA Save

    Though currently on Office 365 I have experienced this issue in earlier versions as well. I am using the ActiveWorkbook.SaveAs command to save a new workbook. The save is successful; however the Saving status window does not close. In order to continue processing I must select Cancel...
  10. F

    Reference cells from source worksheet to destination if condition are met

    Good day, I have the following sample data(excerpt from a large dataset) below and name it as Sheet1: <tbody> </tbody> <tbody> NO DATE BRAND ORDER MODEL QTY 1 21/8/2019 <tbody> CATHAY </tbody> <tbody> C123456 </tbody> <tbody> AIRBUS </tbody> 200 2 21/8/2019 SILKAIR...
  11. D

    VBA Code to Track Status Changes to a Separate Sheet

    Hi All, We are seeking assistance in creating a VBA Code to track Status Changes from Cell Range A3:A1000 - G3:G1000 this is coming from Sheet Name "Status Changes" and be tracked to a separate Sheet called "Status Update Tracker" and will display a value in Column H3 WB (Our week starts every...
  12. willow1985

    Drop down box value to trigger macro

    I have drop down lists in column O where you can toggle the status from "blank", to "open" to "closed". What I would like to do is have a certain macro run every time the status is changed in any of the cells in column O. the following vba code that I currently have (that I inserted under...
  13. L

    Pivot Table

    Can a pivot table calculate two items under one category? Here's an example of what I want to do. I've provided a table of what I want the pivot table to look like when it's calculating the data. I don't know how to add/include actual excel cells into my message so I apologize about that...
  14. L

    Out Date "OUT" or Return Date "Return"

    I want that if Out Date column has a date, on the Status Column it will have the words OUT but when there's a date is Return Column it should say Return in the Status Column
  15. C

    Show SAP Status bar while SAP is executing through a script

    Hello, I wrote a macro to automate the extraction of data from SAP using SAP GUI scripts. What I want to achieve now is to add a status bar in a form which shows the actual text on the SAP status bar while the report is being produced. I know how to read the SAP status bar, but I just can't...
  16. V

    Custom sort order

    I have a list of products that need to be sorted in a very specific manner - the final sort order should be as described in the column titled "Overall Rank". The problem I have is that I need to first sort the products by the column titled "Date". Then, for a subset of the products (namely E...
  17. H

    Excel VBA: List Files of Folder/Subfolder & Rename Files with new filename

    Hi need some help, i try to search around the forum but seen not able to find one i want. Step 1 (list filename of Folder & SubFolder), there will be a POP-UP and ask user to select the path Step 2 (rename filename base on col C) & Status update on Col D Isit gd ideal to display ext...
  18. G

    VBA code to hide a range of cells based on cell value

    Hi, I am not sure if i am close but i am attempting to hide a range of rows based on the value of another cell. To be more clear A11 value is "Status" and i need to evaluate B11 and if it is "Open" then hide 11 rows up. This repeats in a dynamically lengthed document that i run weekly...
  19. P

    Conditional formatting question on multiple rows

    How do I use the conditional formatting option for "Use Formula" option on a per row basis? In my example I have a status field as Closed, once the status is set to Closed it will Strike Through all the text in the next 5 columns in that row. How do I drag this Conditional Formatting...
  20. D

    Looking for a formula to show last 10 transactions based on multiple criteria

    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...
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top