closed

Hi All: I've got a worksheet that includes a running list of To Do items for various projects. Right now it shows both closed and open items in the same list. I use filters to hide closed items. I close an item by putting an X in column A, which then puts the date closed in column K. How...

Hello, I am using the below code to update links Sub update() ActiveWorkbook.UpdateLink Name:="\\192.168.0.100\itex share\ITEX\DATA ENTRY.xlsm" _ , Type:=xlExcelLinks End Sub The code works fine when the source file is closed. but gives a debug msg when the...

Hello Mr. Excel gurus! I've searched for hours for a solution with no luck. Sometimes I can cobble a macro together but this is out of my league. I have a file with a value in cell A4 that I need to lookup on tab "Sch H" in a closed file (X:\Folder\file.xlsx) and return the values in that...

I am using index match to fill in a form from data on a closed workbook. It works perfectly 99% of the time. However, it starts retrieving wrong data out of no where. Nothing changed with the formula. Just out of the blue it decides it will not pull the correct information. If I open the...

Scheduler will not work on our network. Can a macro open a closed workbook? Thanks

OK - here is the scenario: Main macro opens a selected workbook to be 'worked on'. This workbook is then closed by the user using the standard 'X' (NB Not by a macro code line) I want to suspend macro execution in the main macro while the new workbook is 'worked on' until the new workbook is...

Hi Can I copy a sheet from ThisWorkbook to another workbook which is closed but in the same folder. Is that possible or the second workbook has to be open. I know how to move/copy a sheet inside same workbook or to another opened workbook but my code below failed to copy a sheet to second...

Below, Once the button is activated...it searches for "Y" in "A2:A" in all worksheets specified. It means that line is closed... Someone will enter a Y for yes Its Closed and transfer to Sheet "Closed PS" (This Person is not familiar with PC concepts) So we have to be gentle . A quick report is...

Hello, I am trying to setup a spread sheet where 1 cell (A1) equalsa cell in another spreadsheet. In theformula bar it looks like =[Book1]Sheet1!$B$1. This works perfectly well, however when the value in Book1 at B1 needsto be updated we copy the column, insert the copied column over top of...

I am trying to count the occurrences of a Status column that has the number of "Open", the number of "Closed", and the number of "In Process". I entered the formula to count the number of Open, but it returns #N/A. The format is General and there are a number of Opens but it does not count...

Hi, I was wondering if somebody could help me work out how to do a formula to lookup data within a closed spreadsheet where the date of the file changes each day with the suffix of todays date. I have been searching and trying to do this myself with the below formula but I don't seem to be...

All records in my mdb are assigned 1 of 3 statuses: Pending, Active or Closed. In the header of one of my main reports, I have 3 unbound textboxes to display the count of records for each status. For example, =Sum(IIf([RecruitmentStatus]="Closed",1,0)) and so on. Here's what I am trying to...

Hi Everyone, OK So heres what I need, I need two macros, 1 when the document is opened it creates a new document in the same folder called "Used" When the document is closed it deletes the docment called "Used" how can I do this. Thanks Tony

I have a workbook named "Results" with a row containing the weeks in a year 1 through 52. There is another closed workbook named "Daily Stats" that I would like to dynamically reference a particular sheet name based on the week (each sheet is named W1, W2, W3, etc) and return a value from a...

Hi gurus, I would like to delete rows that contain the text "Off" in column C (under SSG). Is there a way to do this without macros? <tbody> Time Engine SSG Hatch RPM 0700 Off On Open 0 0800 On Off Open 1200 0900 On On Closed 1600 1000 On On Closed 1600 1100 On Off Closed 1200...

I need your help writing an if/then statement in a pivot table - I need to write if c5 is = 1 and d5 is equal to 0, then "closed" otherwise "still open"

I have 2 date columns, "Opened" and "Closed". I would like a formula as part of my query that would say "If Closed is null, subtract today's date from Opened. Otherwise, subtract Closed from Opened." Any help in doing this? I am a complete Power Query noob! :(

Hi All Hope everyone is well I have the below data and i am trying to answer the question : what is the overall average length of days for open status for each manager ALi and MAX. <tbody> A B C D 1 Manager Start Date End Date status 2 Ali 15/02/2019 17/02/2019 Open 3 Ali 18/02/2019...

Hi, I currently have a workbook that when opened updates a Notepad with the users name, date & time opened. using the below code... Private Sub Workbook_Open() Sheets("Select Handler").Select Open "myfilelcation.log" For Append As #1 Print #1 , Application.UserName, Now Close #1 End...

I am trying to pull data from another excel spreadsheet while it is closed using drop down menus to change the year and month. The reason for the drop down is to change the file that is referenced as I will be saving the files with the correct year and month. Here is what I have...