closed

Hi, Sheet2 Row/col A/col B 1/2017-01-01/closed 2/2016-01-01/open 3/2015-01-01/closed 4/2014-01-01/open Sheet1 If col B in sheet 2= "open", then return value in col A= 2016-01-01, and if today's date > than this date 2016-01-01= count. In this example I have 2x open items with dates back in...

Hello All, I have a spreadsheet with 3 columns. What I am struggling to achieve is how to copy paste value from the column “Duration Limit” to “Duration Report” when the “Status” column’s data validation list is changed to Closed. The reason it has to be copy paste values is that the Duration...

I'm trying to get data from Cell A4 in a closed workbook named "Test1.xlsm" When I use the name "Test1.xlsm" it gets the data But when I put the file name "Test1.xlsm" into a string it doesn't return the data from Cell A4 Sub LoopThroughFiles_for_Total_Values() Dim Date2 As String Dim...

Hi Everyone, I have been able to find parts of the VBA for what I wouldlike to do, but not a solution that will work for my situation. I have a password protected spreadsheet with a projectlist. Projects are listed in Rows 10 – 200. Column D contains project status (Open, Closed...

Hello! I have a simple, yet not so simple problem to solve. At work we get hundreds of bank transaction files from the bank. We have an employee who has to go into each file and change the account number to the account name. This is not a value add task if you know what I mean. I know what...

Hi All, I have two columns of dates. One is support tickets opened one is support tickets closed. Each date entry on a new row represents a ticket. When I try to put a pivot chart together the opened and closed per month figure is coming out the same which it shouldn't be. What I would like...

Hi, I've Had a good search on this forum around this, I can see some things like it but not exactly what I'm after and I'm stuck I have a table below and I'm trying to count how many Unique values based on number of days I'm looking to COUNT UNIQUE Ref that have CHANGE DAYS between between...

Hey All- I believe I am looking for a simple index match function based on two criteria, but I must be missing something basic (typically rely on vlookups). I want to return the ticket number for a specific NPI that the Patient Services team is working on. The intent is to combine this weekly...

I'm creating a tracking document for the real estate team I work with. I'm in way over my head in excel skills (this is news to no one on the team, we just realized it's cheaper for me to spend the hours to make this document and have it as our own rather than pay for the one we've been using...

Hi, Im looking for a Macro or code to use, that would automatically to move a row of data when a criteria goes from 'Open' to 'Closed'. I want the data to move from one sheet to another sheet in the same workbook, but also want it to move down to the next row. The information looks like this...

These dates are UK format dd/mm/yyyy I've googled the $h!t out of this and can't find what I need. I'm looking to create a calculated column that shows Days and hours between 2 datetime fields. So for example I have Open Date and Closed Date: Open: 12/11/2018 19:10:43 Closed: 12/11/2018...

Hi there, I need to have a message box pop up so that I can select a CLOSED excel file where my data is located ( this file will not always be the same which is why I need to be able to choose it). I then need to copy data from the 1st tab in the CLOSED sheet( without specifying its name...

Hi, I have the following macro below. What this does is loads a specific sheet from from s separate closed excel file. The issue is, the sheet name has to be "Dynamic 1" in the closed model. Is there a way to create a cell with a named range, and whatever sheet name the user inputs, that is the...

Hi All I have a spreadsheet that has start dates (E) end dates (F) and a calendar style fields I - BU. Is it possible for fields I - BU to lookup fields E - F and fill then in. also I have another field G which holds conditional formatting on WIP (Amber), Closed (Green), etc. Can these be...

I have a lot of data in a workbook that i want to archive. the issue is i need to determine how many times a specific number appears on that to conduct a trend analysis. Is there a way to conduct a search of how many times a value appears in a different closed workbook? I do know that Vlookup...

Here's what I currently use (which works, but I'd prefer getting the data without windows flickering / files opening and closing, etc). I just want to copy columns A:N from the closed CSV and paste them to columns A:N in the sheet named "CSV_paste" of the active workbook. (It would also be fine...

Hi all, im self teaching myself vba and I have a problem trying to combine my 2 vba codes. Code 1 -This bit of code uses (H:H) as a drop down list, which then pastes a vlookup to the next cell to lookup data on a separate data worksheet (Supplier Details) It then copies the cell an pastes its...

I am trying to copy data from a closed workbook from a specific sheet and from a specific range and paste it into my active workbook but into a specific sheet starting at cell B7. I have the below code however it is only returning zeros. can anyone point me in the right direction? I will be...

I am using Excel 2016 and Powerquery I have a table of Open work called Open I have a table of Closed work called Closed I have a third table called Timekeeping that shows hours worked on open and closed work and they are merged based off of a unique work number to each of the two tables above...

Hi all, I get it that SUMIF(S) doesn't work with closed workbooks. Normally, SUMPRODUCT works fine in such scenarios. Except, if I have many lookup values. I can't figure out an easy way to resolve other than a very long/ugly SUMPRODUCT. E.g. <tbody> Stores to sum sales Location of sales...