i am having a worksheet (excel 2003)with the details as bellow:
coloum a: stock name
coloum b: high
coloum c: low
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.
email: Deleted by moderator, not permitted
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