Register
Log In
Unanswered
Home
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
Members
Dashboards
Power Query
Power Pivot
Power BI
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
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?
August 26, 2017
Offline
Thomas, No I haven't figured it out. Do you have any suggestions? Thanks, Jim
Dashboards
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
Most Users Ever Online: 57
Currently Online:
11 Guest(s)
Currently Browsing this Page:
1 Guest(s)
Top Posters:
SunnyKow: 651
Frans Visser: 210
David_Ng: 96
mey tithveasna: 71
A.Maurizio: 60
rathanak: 58
yhooithin05: 54
Anders Sehlstedt: 47
julian: 46
PaulFogel: 37
Newest Members:
Md. Rahman
Lilian Vo
Jane Kumwenda
David Miller
Efe Onwochei
LynAnn Williams
Brandy Kriger
purna chandar
E K
velissa barr
Forum Stats:
Groups: 2
Forums: 18
Topics: 935
Posts: 4405
Member Stats:
Guest Posters: 1
Members: 42350
Moderators: 1
Admins: 3
Administrators: Mynda Treacy, Philip Treacy, Catalin Bombea
Moderators: Genevieve Tupas
