logs

Complete Macro noob here... I am working with a very large data set (5,000+ rows, 57 columns) of web server logs. These logs contain a great deal of noise I need cleaned out. The best column to do this from would be the Destination IP addresses. There are over 250 unique addresses. I need to...

Hi, I've been looking for a solution to my problem for a few weeks now. I've allready posted my question on Ozgrid, but I'm still stuck. Hopefully there's someone here to help me out... So here's my problem: I have a workbook containing two worksheets that should be allways visible. So a...

Hi, good day! I'd like to seek some help regarding how to make different formulas for the Daily Time Record of an employee. Situation: An employee logs in and logs out twice a day. Working schedule is 8:30 AM-12:00 PM then 1: PM to 5:30 PM with one hour lunch break. Now, my teacher wants us to...

Hello, I have a worksheet that track changes and logs into a sheet when cell changes. It logs the Sheet Name where the change happen. However, I have multiple data that needs to change in a single sheet. The problem is that it only logs the sheet name and not the column where I change the cell...

Hello, I want to have a macro that notes time of login and shut down in computer in excel sheet automatically without opening it. I have a common share drive for my team where I will place this macro enabled excel file. The excel file should record time for all the persons have access to that...

Hello! I'm having a hard time making formula for my reports. Can someone help me please!! I am working in logs industry, I have workbook with multiple worksheets, the other worksheet name PJan-PDec it means that was the logs we receive every month, and another LJan-LDec for the logs we used...

I have a 2 sets of logarithmic values, of which I want to find the average. Would using the arithmetic average be correct, or is it more complex than that? Please, help me with some guidance. Forgot to mention: the second set is shorter, but if extended no values woud have been recorded.

Hello World I'm trying my hand at error handling & printing the same to a log file Issue: If there is any error while extracting the report path of any file, print the error & file name to a log file Here's the current macro I have to extract file details <code style="margin: 0px; padding...

Apologies for the vague title but I'm not sure how best to describe this challenge. I have a log from our GPS tracking system for all of our company trailers. I am trying to work out how long each trailer stayed on site at a particular destination for. The first complication is that for each...

I have created a ID generator that will then need to be saved to a log in the next worksheet. I have created two command buttons, one to clear the form and another to save it to the log. I can not place a command that will identify the next open cell in a specific column for the log worksheet...