I am struggling to find a solution to capture cell data based on a specific date and then maintaining that data when the date changes. And I need to do this without scripting. I would like to capture this value and retain it once the month advances. This is what I have so far, but it clearly doesn't work as the value will change each month:Capture.JPG
What cell? What data? Do you have a table of data? Why no scripting?
Bernie Deitrick
Excel MVP 2000-2010
Thanks for replying. I attached a quick overview of what I am trying to do. Essentially, I want to capture the data in any cell [ =IF(MONTH(B1)>6,A1,"?")], based on a date and then I don't want that data to change again. I am not proficient with VBA, and I would prefer to do it with a formula.
Thank you for your help.
You don't need to be proficient: I need to be proficient (I amOriginally Posted by Davbad
), and you just need to follow instructions.
Copy the code below, right-click the sheet tab, select "View Code" and paste the code into the window that appears. Save the file as a macro-enabled workbook (.xlsm).
Then, whenever the sheet is calculated, any cell with a formula that is of the form
=IF(MONTH......)
and that does not return a question mark will be converted to a value.
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks