Stock Data function

[rsd007]

Hello,

I have EXCEl 365 workbook, and consolidating and (removing duplicates) all stock tickers on 1 page in column B
(Column A is blank ) then using another formula =IF(B14<>"",B14,"") transfer tickers to column C.
From column C ticker i will like to get Stock Name using EXCEL 365 Stock function in Column D.
Can someone help me please.

 

[MARK858]

IN column A my tickers are changing based on selling some stocks and then buying new stocks

As I stated record yourself a macro and run it each time (see my edit in the previous post for a non recorded version that is dynamic)

 

[rsd007]

Thanks
it did work Can i request a modification
after copying the ticker in column B it runs the stock option automatically.
currently i have to hit refresh in Data tab

 

[MARK858]

Thanks
it did work Can i request a modification
after copying the ticker in column B it runs the stock option automatically.
currently i have to hit refresh in Data tab

It updates automatically for me every time that I run the macro, did you change the LanguageCulture to match your locale?

 

[rsd007]

Sorry mark,
I am not very familiar with macro and VBA.
I am in Canada i did not change anything copy the code and pasted in sheet ( in the project VB script sheet )
but need to run every time was trying to make automatic update as new tickers added or removed

 

[MARK858]

Should be in a regular module really, Canada is en-CA or fr-CA (I assume based on which part of Canada you are in).
You'll still need to run the macro each time.

 

[rsd007]

Thanks Mark

 

[MARK858]

You're welcome

 

[rsd007]

IS it possible to Run this Macro automatically. if a new ticker is added in the column B