Solved

Create Log sheet for data update

Posted on 2010-11-29
2
586 Views
Last Modified: 2012-05-10
Hi Experts,

I would like to request Experts help write a macro to record automatically  all activity that was performed in Out and In sheet at Log sheet. I have attached the sample data at Log sheet for Experts to get better view. Hope Experts will help me to create this feature in the attached workbook. The ID/password for userform login is  abc.



Log.xls
0
Comment
Question by:Theva
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 12

Accepted Solution

by:
sstampf earned 500 total points
ID: 34231851
Hi,

I have created a code and have inserted it into your file. Please test the file below and let me know if this is what you were looking for. I have created a new "sub" named "sstampf"
Log-v2.xls
0
 

Author Closing Comment

by:Theva
ID: 34258999
Hi,

Thanks for the great help
0

Featured Post

[Webinar] Code, Load, and Grow

Managing multiple websites, servers, applications, and security on a daily basis? Join us for a webinar on May 25th to learn how to simplify administration and management of virtual hosts for IT admins, create a secure environment, and deploy code more effectively and frequently.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article will guide you to convert a grid from a picture into Excel format using Microsoft OneNote and no other 3rd party application.
This code takes an Excel list of URL’s and adds a header titled “URL List”. It then searches through all URL’s in column “A”, looking for duplicates. When a duplicate is found, it is moved to the top of the list. The duplicate URL’s are then highlig…
The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

752 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question