I have sheets detailing inspection plans and am trying to include a log of the inspection checks into the same sheet. When characteristics in column A are changed I'd like the sheet to automatically highlight and record this in the log section. I was previously doing this with 2 separate sheets but I now need to combine the 2.
I've included a before & after to show what I'm looking to do.
Hi -
I don't know if this is helpful, but have you tried turning on Track Changes and have Excel highlight cells that have been changed, what the original content was, and what the new content is? It also shows who made the edit and the date and time the edit was made.
Otherwise, I think this will take some VBA programming to continually monitor each change.
____________________________________________
If this has solved your problem, please edit the thread title to add the word [SOLVED] at the beginning. You can do this by
-Go to the top of the first post
-Select Thread Tools
-Select Mark thread as Solved
If I have been particularly helpful, please "bump" my reputation by pressing the small star in the lower left corner of my post.
Try this? See if it does the trick...
Please Login or Register to view this content.
Looks like this is working. Thanks!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks