Math New

yes presume the more data are column S to W
if yes then how you get these figures can you elucidate ?
gowflow

ok sure sir but need to confirm Math Old ....whole process understand?

not really ... but I can see that Find button triggers FindValues sub and can follow the routines there and presume the change needed is in routine
Calculate

gowflow

Step 1 L3:N3 data available in WS when opening of WB. need to find data for N3 Date which is Open High Low Close via VLOOKUP(O3:R3). As there is only one entry so for rest S3:W3 Start.

Step 2 Via running code we will get new data L3:N3 & old data shift one row down. so for Column O to W new data should be feed via formula which is prescribe in Math New WS. for range O to R i dint use VLOOKUP formula in Math New WS. so it is up to you use formula to get value or via code. i guess you have more logical thinking then me.

Thanks

or Sir you want me to start form very begging so ignore Math old & start with whole new?

if you open the NewMath file and activate macros and press on Find Values it will copy all the formulas you have till W down

what else is needed?
gowflow
Math-New.xlsm

One question arise how flicking disappear? Second question as even i participate formula based beginner questions but some time i lost what author is saying. how do u understand what author want. when you read question what first comes in your mind, how you analyze ? you go depth in question or you just stick to procedure?

Posting 2 Question in this series, if you wish to pls participate.

Thanks

hahaahh I like your comments !!! to answer,

1) How flickering disappear, put this in the beginning of a subroutine (but one should be careful as to where as many subroutine will act not correctly if this is put !!

With Application
     .EnableEvents = False
     .DisplayAlerts = False
     .ScrennUpdating = False
End With

Select allOpen in new window

then before the end of the Subroutine put this

With Application
     .EnableEvents = True
     .DisplayAlerts = True
     .ScrennUpdating = True
End With

Select allOpen in new window

You can check in the attached file this put in both
Calculate
ResetValues

2) Not sure I understood your question, but what I understood is that you ask yourself how I am able to understand what the asker wants ?? is it simply by reading the post or looking at code ??

Well if it is this what you meant is I do the following:
I read the question, if not clear I read again, if not clear I read again and again and again ... till I guess or understand
then If I still don't understand and there is code or file attached then I look at the file and code and read again the question to maybe try to understand more

and when I miss something then
I ASK a question and ASK more and more till I fully understand what the asker want and make sure I understand Exactly what the asker want ...

Then I provide solution.
Then,
I test the solution with the data given then test again
find bugs correct bugs ,,,
then test again and again and again

till no Error

THEN and only then

I post the REPLY !!!!

Did I answer your question ?
gowflow

i had made some changes in formula. looks perfectly working but just need your confirmation..is that ok see attached.

Part 2 Math G


Thanks
Math-G.xlsm

As i seen your solutions, you had solved most complex question not rate by code but by understanding what asker want.    :)

Sure it is the basis of everything. I believe that I succeed when I able to deliver what the asker wants !!

Thnak you for your appreciation it is the fuel I need to keep moving on !!! :)
gowflow