closed

Hi experts I am new to vba and looking for a way to modify data in a large file (extract below) as explained below. <tbody> Record ref Date created Type Stage Status Department Client Cost Price AAM000001 01/04/2015 APP Closed - Funded Application v1 - Approved CEEEE FUN00023 487,993.00...

Hello, I need some help with the below code. I know its pretty messy, but hopefully someone can help me clean it up and get it working. The first portion works. The code is assigned to a checkbox. If the checkbox is ticked my activesheet (Status of Closing) range D5 value changes to...

Hi All I am wanting to count the number of cases we opened and closed the same day. My countif works for the closed part of the sheet, but struggling with the addition of days into the equation. Columns E and F on Daily Import sheet are the date but formatted from the data pull but...

Hi! I have an Excel spreadsheet where I have added macros attached to control buttons to filter the 1825 row list based on discipline criteria. See code below for 1 example. I also have a macro that hides rows that have a value in them (to hide rows where the item is closed - "C" in the cell...

Hi all, I want to vlookup from an closed workbook. i have the below code which pulls up the particular column data from an closed book. When i apply the formula(=VLOOKUP(B18,'C:\My Documents\Temp\[Demo.xls]Sheet1'!$A$1:$B$10,2,FALSE). the file size gets heavy. Is there an better way around...

I need to get values from another file on the server. I don't want to open the file. Is there a way to reference a cell in a closed file? Really appreciate any help that you can give!

Hello, I am trying to figure out how to calculate based on the following. The 'closed' date will be in Cell A2. If closed transaction on 7/27, pay on Friday 8/17 If closed transactor on 7/11, then pay would be on Friday 8/3. Any transaction that closed between the 1st and the 15th of the...

Hi all I'm really struggling here - any help would be great. I have a spreadsheet where I am trying to record (in cell F4) that actions are either open or closed off. Where actions are open it is automatically highlighted red. I have the following formula. =IF(E4<>"","Closed","Open") all good...

Hello all, sorry to bother you all. I am struggling here. Scenario; Column A (Created) in Data sheet contains 3000+ dates ranging from 01/01/2018 to 30/06/2018, there could be several instances of the same dates. Column B (Closed) in Data sheet contains 3000+ dates ranging from 01/01/2018...

Hi im trying to do a lookup in a list found in other workbook. The workbookname is a variable, in this example "Test3720.xlsm" When i write the function with the workbookname "hardtyped", it work fine, with the searched woorkbook both opened and closed... the code goes like this...

I have the following formula that works when both workbooks are open, but not when the one I'm pulling from is closed. This is a report for another team that won't be opening the workbook I'm pulling from. I've read to use SUMPRODUCT for closed workbooks, but struggling on writing it correctly...

Hello everybody. I'm coping with the following situation. I have to report values from sheet2 to sheet1. The condition are as follows: 1) not consider data that in sheet2 are in state open (column B); 2) if the state is closed (column B, sheet2), then report in sheet1 on the row...

Is there a way to get workbook connection properties (i.e. connection string, command text, etc.) from closed workbooks via VBA? Any direction on how to get this information is much appreciated. Thank you.

Hi, I am looking to copy values from a specific range in a closed workbook/worksheet into a specific worksheet in the main workbook. The closed workbook is not in the same folder path. I am looking for the user to select the file. The workbook name that has the values is named MTD with...

Alright, so this isn't (or shouldn't be) difficult, but it's just one of those things... I've already referenced several posts/sites along the same lines of this topic, but for whatever reason just can't seem to get this down. As the title suggests, I am (in VBA) referencing a dataset from a...

I have created a Risk Register, which lists the number of days a risk has been open for, using the formula below (Column AC), where G4 is the date the risk was identified / raised on the register. =IF(AA4="Open", TODAY()-G4, "") Column G - Date Originated Column AA - status, either Open or...

HI! I am fairly familiar with excel but I am really having a problem with the calculations below. The Approval History is formatted as General, the Closed as Custom but no matter what I do with formatting it won't fix the error. One thing that did work is adding the text, even just the " -...

Hi all! New and would like to get some info. My boss wants me to have a column on an excel sheet for date ranges. In this column, each cell (working independently) needs to be able to respond to two different cells. By this, I mean: Column F Origination Date Column G Target Date Column H...

Hi All, I have a workbook consisting of 6 worksheets (all with data referring to that location). I have a macro in place to loop through all the worksheets and look for the projects that are "closed" , it then cuts the rows based on the condition and transfers it to a worksheet called closed...

Hello Gents Could it be that with the help of vba programming, the data of a closed file is added to the main file. We call the closed file "Order.xlsx", which has two sheet. The main file has 3 sheet. Which on the second sheet is our table (file name: office.xlsx). When the user chooses the...