Active Member
August 26, 2017
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
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
1 Guest(s)