Solved

Create Log sheet for data update

Posted on 2010-11-29
2
587 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

SharePoint Admin?

Enable Your Employees To Focus On The Core With Intuitive Onscreen Guidance That is With You At The Moment of Need.

Question has a verified solution.

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

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…
This article describes how to use a set of graphical playing cards to create a Draw Poker game in Excel or VB6.
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …
Graphs within dashboards are meant to be dynamic, representing data from a period of time that will change each time the dashboard is updated with new data. Rather than update each graph to point to a different set within a static set of data, t…

630 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