Modifying a "sample" Excel "Movie List" spreadsheet

Question

I've attempted to look up solutions on the WEB but haven't found one that has worked for what I'm attempting to accomplish. Need help, I'm so confused, and it's been at least 15 years since I took Excel in college.Screenshot/diagram of what I want to do.

sergeibaklan · Answer

Hi Gary,&nbsp;If you are not going to use VBA on day-to-day basis, quite basic skills&nbsp;could be enough to solve particular task. Of course, deeper knowledge the better.&nbsp;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.&nbsp; &nbsp;Closer the sample less efforts required, if any if you are lucky with it.&nbsp;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.

sergeibaklan · Answer

simply google "VBA if not" and you'll find a lot of references. Here is almost complete guide for using If&nbsp;https://excelmacromastery.com/vba-if/

vignesh babu j.d. · Answer

Can you elaborate your question?

gary w · Answer

Yes, thank you for responding.&nbsp;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").&nbsp;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.&nbsp;(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.&nbsp;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.&nbsp;ANY help you would be able to provide would very much be appreciated.Again, Thank you.Gary

sergeibaklan · Answer

Hi Gary,&nbsp;Afraid that's not Excel formula but VBA script, example is here&nbsp;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.

Forum Discussion

Modifying a "sample" Excel "Movie List" spreadsheet

7 Replies

Resources