find date

Hello everyone, I’ve workbook with data (range A to M) sorted in chronological descending order, around 100k rows. The aim is to create code that copies all rows with the same date (dates in column B) to workbook Results.xlsm, adds sheet with name equal to that date and then does the same thing...

Hi. New to VBA. I have looked and as of yet have not found a solution to my query. I have an excel workbook with 2 sheets: Date Ref = sheet containing Date reference (today()-1 i.e. yesterday) in cell F8. Data Sheet = contains Date in column B and remainder columns containing formulas which...

Thanks in advance and I will post feedback for proposed solutions. Here is my code thus far. Sub FindDate2() Dim DT As Date, VR As Variant, CL As Long DT = Sheets("Sheet1").CDate(Cells(5, 1)) Set VR =...

Any help to solve this problem would be greatly appreciated, thank you in advance! From an injury log for several departments, I would like to calculate the days since last injury for each department, on a separate sheet within the workbook. I need a formula to pull the the latest injury date...

Hello and thanks for reading. I have a dashboard that i made and it has a daily tasks button that goes into my manual calendar that I made and finds "today's" date, goes two rows down and copies the space and pastes it onto my interface page. I will post the macro for it. All I would like to...

Hello, I'm looking for an Excel macro solution. I'm using Excel 2013. I want to determine if today is the last day of the month. If yes, do something. If no, do nothing. Could you show me the code please? Thanks.

Ok I really need help with the following issue that I have</SPAN> I have a sheet called DATA which contains lists of data , like name, title, dates, etc… , ROW C contains lists of dates</SPAN> My User Interface asks users to select two dates</SPAN> Date 1, and Date 2 , and then hit submit...

Please help - I've tried various options found online and nothing is working: I have a large spreadsheet with a long date range from A:3 to A:900 what would be the best way to jump to today's date? I have seen formulas, Macro's, Active X controls, Hyperlinks? I would prefere a Macro if...