closed

  1. C

    Formula issue - ideas?

    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...
  2. M

    Macro to Copy paste Value to cell adjacent to it

    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...
  3. J

    Get data from closed workbook

    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...
  4. R

    Protected Sheet - Hide/Unhide Rows based on user input and other cell values

    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...
  5. M

    Updating closed workbooks based on table data

    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...
  6. M

    Help with simple pivot table

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

    Count Unique actions based on selection criteria

    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...
  8. M

    Index match with multiple criteria

    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...
  9. A

    Totalling and Tallying Sales by Month

    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...
  10. O

    Moving a row that goes from Open to closed to a seperate sheet

    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...
  11. T

    Days and hours between 2 datetime fields in PowerPivot

    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...
  12. S

    Select and import Data from multiple tabs in closed workbook VBA

    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...
  13. T

    Quick VBA Questions

    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...
  14. H

    Excel Dates and conditional formatting

    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...
  15. J

    Countif function with a closed workbook

    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...
  16. D

    Copying data from a closed CSV on my desktop *without* opening the file?

    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...
  17. R

    Combining 2 Worksheet_Change

    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...
  18. S

    How to copy from a closed workbook to active workbook using vba?

    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...
  19. C

    Combining two tables Power Query

    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...
  20. J

    SUMPRODUCT with closed workbook

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

We've detected that you are using an adblocker.

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.
Go back
Back
Top