Log In
Register
Home
Active Member
August 26, 2017
Offline
Hey Ya'll from North Carolina,
Two questions:
Q#1 - My scenario: I have a stock daily price look-up macro that populates Col C with the daily price and Col D with the "Today's Date" on rows 4-21 (each row a different Stock Symbol). Row 3 has the "date of record" at the top of my "storage columns" H, I, J, ... Z.
I need a formula in the cells (H4:Z21) along this line: "=If(J3 [today's date] =D4,C4, [what can I put in the 'else' / 'false' argument so that the formula won't erase the current value in the cell with the formula that was entered on the previous day when D4 equalled I3=yesterday?])
Q#2 - Do you know of a trusted downloadable macro that will do this?
Please see attached workbook.
Thanks for your help, Jim
VIP
Trusted Members
December 7, 2016
Offline
Hi Jim,
I don't really have a solution to offer for you, as I am not to much of a big fan of using VBA, even though it is handy from time to time. But in my view you would need VBA to achieve what you want. On the other hand, I would use a database to store all my data and then use Excel to work with the data.
I hope you find a solution.
Br,
Anders
Active Member
August 26, 2017
Offline
Anders, I like the idea of a database. In my continued digging, I discovered that I'm trying to use a 3rd party Excel Add-in and not a function or a sub. Now, I'm looking for the way to link the add-in to my macro. Have a great day, Jim
New Member
October 27, 2017
Offline
Were you able to figure this out?
Active Member
August 26, 2017
Offline
Thomas, No I haven't figured it out. Do you have any suggestions? Thanks, Jim
VIP
Trusted Members
June 25, 2016
Offline
Hi Jim
See if this helps.
The problem is the Date in column D is text while the date in columns H and after are true dates.
Not too sure if it is caused by my date format dd/mm/yyyy and yours in mm/dd/yyyy.
Sunny
1 Guest(s)
