Forum Discussion
Modifying a "sample" Excel "Movie List" spreadsheet
Yes, thank you for responding.
In the picture/screenshot you may see where I have created a Column labled "Date Added/Date Modified" (for some unknown reason to me, after trying to use a formula I got from an online source, it Auto Filled with the "# Name").
I would like to have the column "Date Added/Date Modified" field (for every individual New Row Entry)
OR
(IF there are ANY Additions/Modifications made to an Existing Row Field preformed, other than the date; i.e.: Adding--a Year released where none extisted before, OR changing/updating the Starring Actor field, OR adding a Director's Name, OR changing the movie Format, OR etc....) "Auto Filled" with the current Date of Entry OR Date of Modification.
(IF necessary I have no problem adding a seperate "Date Modified" column if there will be a conflict attempting an "Auto Fill" with/using two major conditions.)
Please forgive me if this is still confusing...I'm trying to be as detailed as possible so as to obtain the best result.
(My "background" so to speak)
I went through programming classes and received my Associates degree in Computer Information Systems about 15 years ago. I was required to take a Microsoft Systems class that covered Word, Access, Excel, and Powerpoint (not to toot my own horn but, I was pretty darn good at it).
But after receiving my degree (from a community college) I was unable to find work in my field, in my locale. So, as with anything, "If you don't use it, you lose it" applies to me. I can barely remember the basics of C++.net or Sequel or Java (or any of it really) anymore.
This is the reason I ask for a complete "cut and paste" Formula/s; I just don't have the knowledge for deciphering drawn out "code style", written explanations for my problem to solve it; I truly wish I still did! :) I really enjoyed writing code in my thirties.
ANY help you would be able to provide would very much be appreciated.
Again, Thank you.
Gary
Hi Gary,
Afraid that's not Excel formula but VBA script, example is here https://www.extendoffice.com/documents/excel/1895-excel-record-date-and-time-when-cell-changes.html. Some basic knowledge of VBA will be required to use it.
Sergei,
I checked it out and surprisingly quite a bit of it was familiar.
The only function that was't familiar was the "If Not" statement...looked really weird, seemed sort of counter productive if you know what I mean! lol...I'm used to "If", "Then", but I can't remember ever seeing "If Not", go figure.
I just don't know how to translate it to Excel
I really need to get my books out of storage and get back to the level of understanding I once had.
Thanks
simply google "VBA if not" and you'll find a lot of references. Here is almost complete guide for using If
Hello Sergei,
My coding skills are greatly depleted. However, VB 6.0 and VB.NET are two of the languages I learned about 15 years ago, along with C++, C++.NET, Java, Sequel (I'm not sure if either of the above VB languages will translate to VBA or not). But, as I say that was 15 years ago and I haven't had the opportunity to stay current with the languages because I was unable to find employment as a programmer after graduating from my community college with my Associates in Computer Information Systems. I will definitely take a look and see if anything looks familiar though. I would love to get back into programming in the sence that I need to re-read my old text books from college but, since there are no job opportunities in my area for me I would need a "supply" of tasks/challenges/assignments---whatever you call it these days to refresh and hone my skills. As well as a platform for writing code. I used to have a Microsoft Package for VB and C++ but those packages won't run with today's OS and have long since been lost or destroyed (recently moved)... Would like any info you can pass along about "free" coding platforms though?
Thank you for your time,
Gary
Hi Gary,
If you are not going to use VBA on day-to-day basis, quite basic skills could be enough to solve particular task. Of course, deeper knowledge the better.
You may start with short introduction of what VBA is, like Getting Started with VBA in Office, find on Web the sample which is close to task you are going to solve, and modify it using help and google for understanding what is what. Closer the sample less efforts required, if any if you are lucky with it.
Sure, you may ask someone to write the code, but without at least some understanding of it you won't be able to do even minor modifications.
