1. M

    Save As Worksheet with date

    Hello, I'm trying to 'save as' a worksheet to a specific folder with date in the name. So, my filename is going to say "081921_Bill_Review", what I'm trying to do is if I run this Macro the same, I want excel to create another filer with maybe an additional letter with the date (for e.g...
  2. mamady

    Lookup information from another sheet using VBA

    Hi All, I have a list of information in sheet 1, like the following table Country Month Subject Item and in sheet 2, I created a layout with a drop list for Country and Month attributes I want a VBA code that will retrieve/lookup the subject and item based on select...
  3. P

    VBA- Making Log/History

    Hi Guys! I have a sheet that is going to be used every day and i want to press a button and cut today's data and copy in a history sheet. Im kinda new to VBA but was able to cut and paste the data of the day successfully but when i press the button to log another day, the data overwrite the...
  4. 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...
  5. 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...
  6. 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...
  7. 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...
  8. 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...
  9. 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
  10. 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")...
  11. Akbarov

    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...
  12. 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...
  13. 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...
  14. 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...
  15. 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...
  16. 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...
  17. 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
  18. 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...
  19. 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...
  20. 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...
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

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