logging

  1. A

    Find value in worksheet, copy to new row of table in second worksheet

    Hi all, I'm new to the forum and VBA, so thanks in advance for the help! This is what I'm trying to do 1) import data from a text file into a data pane that will feed into a dashboard, 2) search for keywords in the data to find cell references, and 3) copy this data into a new row of an...
  2. G

    Sum with Index and Match or Vlookup?

    Hi guys, If you guys could help me it would be great. so basically I have a spreadsheet of Daily SLA that needs # of Cases and Cases Processed added. I couldnt figure out and I have searched google and youtube. Column A just has the name of the Task (i.e. Logging voicemail SLA#1) because...
  3. D

    Writing txt. logs during a loop

    Need the following code to produce a txt. log on an error, but return the loop interger it was using when the error occured, then retunr to the loop. Sub email() Dim OutApp As Object, OutMail As Object Dim strbody As String Dim cell As Range Set cell = Range("J1") For i = 1 To cell.Value...
  4. R

    Tracking and logging changes to values within one column.

    I have a piece of code (Which I got from this site) that tracks changes to cells within the worksheet. It works great except I'd like it to look a changes just within one column only, not the whole sheet. Anyone know of a way? Option Explicit Const intUsernameColumn = 1 Const intCellRefColumn...
  5. Z

    Attendance (In and Out) Capturing Using Excel Form

    Can you guys please help me with coming up with an Excel Form that captures logins and logouts with the following features: 1. To login and catch timestamp, the form will ask for a username and password (other stuff will also do, like just simply typing in employee ID, scanning QR code, etc.) 2...
  6. S

    excel workbook pulls data from another excel workbook

    Hi there, I currently have two excel workbooks. The first includes data on a worksheet. The second workbook I want it to update and log the data from the first workbook: So for example, I have a command button in the 2nd workbook and when pressed it searches for newly updated data from today...
  7. S

    Track User, Computer , Date When Excel Connection is refreshed

    Hi All, I am fresher to VBA.I need to track and store the data of the users who refresh my Excel Work books. These excel work books are typically connected to OLAP Cubes. I need to get the values - Username, Computer name , Date when refreshed/Accessed to be loaded into my SQL Server database...
  8. E

    MACRO: Saving clipboard data to a file

    Hey everyone, I am trying to build a log that will help my team do their jobs more efficiently. I've built a UserForm that correctly logs the information entered into it. I think I've come to my knowledge limit. What i need now, is when the user clicks "add" to submit the data, for excel to...
  9. K

    How to log daily data into a descending column

    I have a spreadsheet that I am using for budgeting and I want to be able to track my savings by logging data from one cell. If cell A1 represented my savings I want that copied to B1 then the next day when A1 changes the new value would be copied to B2 and so on. Any way that I have tried so...

Watch MrExcel Video

This Week's Hot Topics

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
Top