Yes it is possible but it is not a great project for the faint of heart.
There is a lot to it. You essentially need to write to a storage location (a
blank sheet) all of the changes as they are made (run from the change event).
Your macro then reads that data and inserts it where appropriate (If i
understand what you are trying to do). Like I said though this is NOT a great
project for a first timer or someone who has no experience writing macro's
from scratch...
--
HTH...

Jim Thomlinson


"eagle_eyes" wrote:


All of my macros have been recorded so I don't have a clue how to write
one from scratch but I haven't been able to record this one.

I would like a macro that does the following things upon execution:

1. Check to see if there is any data in the row above it.
2. If there is, insert a new blank row.
3. Beginning in that blank row, list the date, the values for all
changed data, and the username of the person who made the changes and
continue to insert rows and list that information for all the changes
that have been made since the macro was last run.

Is this possible?




--
eagle_eyes
------------------------------------------------------------------------
eagle_eyes's Profile: http://www.excelforum.com/member.php...o&userid=35259
View this thread: http://www.excelforum.com/showthread...hreadid=550318