closed

Column A = "Status". Values: Unassigned, In Progress, Rejected, Not Proceeding and Complete Column B = "Date Closed". Values: Date I need a statement where I get a 1 value when all the following conditions are met: 1. Date Closed is not blank AND 2. Status = "In Progress" OR "Unassigned"

Hi! I am seeking for a help on how to stop aging when status changes Assumption: A32 - DATE ACQUIRED G32 - AGING (# of days) I32 - STATUS (with drop down: Successfully Closed On Hold Inactive...

Hello my fellow colleagues, I for the life of me cannot figure out how how to get this done. I have a Row where the cells in column A will contain Words such as Open, In Transit, Received, Scheduled, Delivered, Closed. That row will stretch with columns from A - W. When the Word Closed...

For i = 9 To LastRow If UCase(Cells(i, "F")) <> "CL" Or UCase(Cells(i, "F")) <> "CLOSED" _ And Cells(i, "B").Value = 100 Then Cells(i, "B").Value = 99 _ And Cells(i, "E").Formula = "=(E-.3)" End If Next i Hello All... I have a little problem here. What I'm trying to accomplish, is for the...

Hi dear members, Let's assume there is a workbook project where an API timer (SetTimer) is started in the workbook open event... This timer is supposed to be running thoughout the life of the workbook until it is closed. In the workbook before_close event, the timer is cancelled by calling the...

I'm doing a pivot table. There are rows for each person on my team. Column B is "Total Tickets", Column C is number of those tickets per person that are closed - field name is "Status". I need column D to show each person's % of closed tickets. I can manually enter =C10/B10, etc but I want...

Hi, Ref Excel 2016. I've been trying to use an IF statement to reference the data in column C, which in turn will change the text in column E. So, if column C shows the word "Closed", then the text in column E needs to then display the word "Blue". The difficulty I'm finding in using an IF or...

I have accounts which have sub accounts and each sub account is a separate row in my data. I need the "closed" percentage of each department in a Pivot Table. ACCOUNT and STATUS are the column headings in my data ACCOUNT, STATUS acct#1, closed acct#1, open acct#1, closed acct#1, open acct#1...

I have a rather convoluted question. We are now running Excel 16 (365). I am building from a VBA driven workbook, a new twist. A beginning GUI will provide 3 buttons to represent 3 Tabs(worksheets) in a closed workbook on the network. I want to draw a copy of certain rows from the chosen tab to...

How can I tell when an excel file was opened and closed and the session time?

Hi Guys. I have a worksheet on which I keep my sales accounts. It looks something like this:- <tbody> A B C D E F G H I J K Name Created Project Type Date for Action Current Action Status Status Changed Value Commission Turnaround Smith 4 April 2018 ******* Retail 4 April 2018 Call Active...

Is there a way I can get the BuiltinDocumentProperties of a closed file? The path to the file itself is stored in a Textbox...

Hi, I'm having a problem using the SUMIFS function with ranges from closed workbooks. I have read in internet that the #REF ! problem is caused because this function can't work while the referenced workbook is closed and found that it can be done using the SUMPRODUCT function or with SUM and IF...

[/IMG] Kindly help me, I'm looking for a formula if multiple cells (D54 to D61) contain the same text (Closed) D53 should show as Closed if one of the columns (D54 to 61) has a value other than Closed (Such as pending or in progress) D53 should show "pending"

Hello All, Hoping someone can help me, I have tried several codes and searching the internet and I feel my request is not complicated but I cant seem to figure it out. I want a worksheet_change macro that checks column H on my worksheet("Tracker") for values. If column H equals...

Hi All, I have a pivot table with data, one column captures text (Open, Closed) entries. I want to create a calculated field that will do a count of closed. I know I could just drop the field into Column as well as rows to filter this way but my pivot tables contains a number of other columns...

I have a workbook that creates another workbook on opening using Set Freshwkbk = Workbooks.Add I have this as a Public Variable. If I close the Freshwkbk workbook, when code is run on the original workbook I am unable to tell that the Freshwkbk has been closed. If I put ?Freshwkbk is nothing...

Hello, I am new to the thread and relatively new to Excel. I have a job log spreadsheet and I have created a drop down menu to indicate whether the job is open or closed. As we have a fair amount of jobs, once the closed option has been selected I want to hide that row. I have researched it...

i have two cells A1 can be selected for open or closed A2 is the days counter that counts how many days an item is open i want to be able to select close and make the days counter stop so that i can see once its closed how many days that item was open for before we closed it. is that...