log

  1. L

    log date when the file is open

    Hi I want to log the date that a file is opened. For example, If I open the file today and I entered case#2 then the date should be today date in date column but if I open this file tomorrow for case#3 then tomorrow date should be in date column at the same time case #1 and 2 date should not...
  2. B

    Purchase Order Generator

    Afternoon... I have created a Purchase Order Generator, and now I need to log the entries on the purchase order to another sheet before I clear the purchase order for new data. I can get it to update and copy to the log, but it keeps over writing what I did rather than creating a new row and new...
  3. S

    Subtracting 30 minutes only if parameters are met...

    I have a time sheet calculator that i developed to calculate summations for me in respect to total hours worked for an individual. I stumped myself and believe I am over thinking the equation. Essentially i need it to subtract 30 minutes for a break if certain conditions are met, 8 hours or...
  4. J

    Countif Formula

    Hi all, Looking for formula please In Column C I have 2 options In Process and Awaiting Process In Column D I have 4 options Repaired, Cannot be repaired, Awaiting Part, Log No. Below I have 2 In Process = Repaired, 1 In Process = Cannot be repaired. 2 Awaiting Process = Awaiting Log No...
  5. E

    Copy cell data from one workbook to another workbook based on date range in a column

    I have a worksheet on a server called "PO Log 2019.xlsx" In that workbook I have a sheet named "PO Log" that I enter data into when creating Purchase Orders. I would like to create a VBA to extract data from certain cells in that work book based on the date they were entered. The workbook I want...
  6. R

    Activity Log - Excel

    Hi Everyone, I have an excel contains value and embed objects. I Want since open, all activity should be track in excel (Edit, Add, add/delete embed docs etc) log should be password protected on excel. is it ppossible? let me know for further questions
  7. H

    Sort A to Z Ignore blanks

    this code below will Sort the Columns However, It puts the blank cells on top Sub SortRampLog() ActiveWorkbook.Worksheets("RAMP LOG (2)").AutoFilter.Sort.SortFields.Clear ActiveWorkbook.Worksheets("RAMP LOG (2)").AutoFilter.Sort.SortFields.Add Key:= _ Range("A2:A1000")...
  8. A

    Sumifs to find minimum ad maximum.

    Hey Dear community, I have a login details which i need to report. i can't figure out how can i ask excel to find first login and last log out data for each day of month for each person from table? Can anyone help me with VBA or formula please? B - DATE C - Name surname F - Client id J - login...
  9. willow1985

    Generate next sequence number from data in another sheet

    Hello, I am creating an excel spreadsheet that has 2 tabs: Log and New Data On the Log tab there is a list of logs currently numbered 1-832. On the New Data tab I want to create an area where people can key new log information and then I will add an update button complete with a macro that...
  10. J

    VBA Code to set up an audit trail in a separate sheet of a workbook.

    Hello all, I have the task of setting up an audit trail for all changes that are made to a spreadsheet. Suppose the spreadsheet has Sheet 1 and a log sheet. I want the log sheet to record all changes made to Sheet 1 by displaying the user name, the change, the old value, the new value, the...
  11. E

    VBA to Hide Tabs based on Cell contents located in a "Log" tab

    Hello All: I have a workbook that has a tab named "Log". The workbook also has many other tabs as well. In the "Log" worksheet, range A3:A200 contains tabs names. Range D3:D200 contains either "Yes" or "No" or "...". I would like to add VBA to hide tabs where (for example) if D3 contains...
  12. S

    Extract unique values from multiple columns based on a set criteria to create a running list

    Good day, I have been working to simplify a log that is used by a lot of people I work with. I originally built it years ago with helper columns and need to get rid of them. I have 2 items I need to solve but will post the second one in a different post. Item 1: I have a massive log, column B...
  13. R

    A lookup with a SUM function?

    Hi all. A col has Dates in them this sheet is called "Log" Col A Col B Col C Wed, 19 Jun 19 5:30 6:40 Fri, 21 Jun 19 1:49 1:23 Fri, 21 Jun 19 1:11 Fri, 21 Jun 19 1:33 3:12 I have another sheet that has dates for JUNE sheet name...
  14. J

    Website log in

    I have spreadsheet with the following columns: 1. Vendor name 2.website link 3.user 4.password How to write a vba code to log in website and get user/password from cells. Any sample Please. Thank you
  15. F

    A log of when an Excel document has been opened

    Hi, I have a document of someone else's that I check daily and it was made aware to me that the individual whose document it is, knew that I was doing this. And I wasn't sure how this was possible. As far as I know, there's no way to log when an Excel or Microsoft document has been opened...
  16. J

    How do I copy multiple cells from one workbook to a master workbook onto the next row every time submit button used

    Hello, I am very new at writing vba. I copied a code that takes information entered from one workbook by hitting the submit button it then takes my data, opens the master log, transfers the data onto the worksheet horizontally, saves and closes both workbooks. example below of code being used...
  17. K

    Help with VBA to Save as PDF

    I want to save certain sheets as a PDF file with a specific path, have a default file name with the option to edit the file name which also opens the PDF file. Seems to work with desired path and option to change default file name, but the PDF file is never saved and the code continues to the...
  18. S

    VBA to extract data from notepad to excel

    Hello all! Have been a lurker for sometime and have found an incredible amount of useful threads here! However I can't seem to find anything that may help me with a notepad to excel macro ( I know theres a few but can't seem to get them to work :( ) So what I am trying to do is pull out Time...
  19. P

    Help

    Hi All, any help on this would be greatly appreciated. The data below refers to a Used car stocklist advertising changes. Each line represents a log of a price change on the internet. I need the following data retrieved from this list. 1 - Total number of internet changes for each car 2 - The...
  20. I

    Small amendment needed in code

    Hi The below runs with a Workbook Open event to allow VBA to modify a protected sheet without unprotecting the sheet: Private Sub Workbook_Open() With ThisWorkbook Call UnprotectWorksheet(wks:=.Sheets("Training Log")) Call ProtectWorksheet(wks:=.Sheets("Training Log")) End With I...

Some videos you may like

This Week's Hot Topics

Top