Excel problem.

[Closed]
Report
-
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
-
Hello,
i am having a worksheet (excel 2003)with the details as bellow:
coloum a: stock name
coloum b: high
coloum c: low
coloumc: close.
the problem is i downloads this from a website, and the stocks details dosenot come same ...i.e. one day "nifty_fut" comes in 5th row and onether day it comes in 3rd row. i am having 1500 stocks data with the abouve details from a2 onwords.
i wants to search a stock name i.e. "nifty_fut" and copy the "high"
value in onether sell ...i.e. d1.and copy "low" volue in e1, and copy "close" value in f1. i want a macro to do this hard work,i know this is a hard work, but if anybody helps me in this case i am very thankfull to him/her.
thnaking you,
shovidya,
india,
email: Deleted by moderator, not permitted

1 reply

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
Could you please upload a sample EXCEL file WITH sample data, macro, formula , conditional formatting etc on some shared site like https://authentification.site , http://docs.google.com, http://wikisend.com/ , http://www.editgrid.com etc and post back here the link to allow better understanding of how it is now and how you foresee. Based on the sample book, could you re-explain your problem too
hi the link for worksheet is : http://www.editgrid.com/user/shovidya/stocks
plz check and plz help me.
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
That seems to be the final product where you want the values to show up. But looking at it, it seems that you should be able to use VLOOKUP to get the information
i did not got answer to my qestion sir,plz help me in this issue.
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
Explain you sheet how you are doing look up, where is the source data, where is the result etc

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!