Excel problem.

Closed
shovidya - Aug 13, 2010 at 10:50 AM
rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
- Aug 26, 2010 at 08:13 AM
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

rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
769
Aug 17, 2010 at 11:26 PM
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
0
hi the link for worksheet is : http://www.editgrid.com/user/shovidya/stocks
plz check and plz help me.
0
rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
769
Aug 25, 2010 at 08:38 AM
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
0
i did not got answer to my qestion sir,plz help me in this issue.
0
rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
769
Aug 26, 2010 at 08:13 AM
Explain you sheet how you are doing look up, where is the source data, where is the result etc
0