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...
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...
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...
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...
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...
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?
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.
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...
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...
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...
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...
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...
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...
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
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...
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...
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...
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...
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...
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...
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.