Dear all , I need to retrieve EPS information that will be date wise from news of the "input" sheet to the "output" sheet. i have explained it in the attached file, please check the attached file. Thanks.
Dear all , I need to retrieve EPS information that will be date wise from news of the "input" sheet to the "output" sheet. i have explained it in the attached file, please check the attached file. Thanks.
Clear the OUTPUT sheet of all except the header row1. Then try this:
Please Login or Register to view this content.
Last edited by JBeaucaire; 07-28-2013 at 12:17 AM.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use the icon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
Hi JBeaucaire, thanks for replay, here I am getting compiler error “ variable not defined” for the following line
Please Login or Register to view this content.
http://www.excelforum.com/excel-prog...tock-news.html
Please Login or Register to view this content.
My apologies, don't now how that went missing from the top. I added the missing NR declaration at the top of the macro in post #2.
@ Jindon , It works perfectly , it saved my many times , many thanks ..
@ JBeaucaire , thanks for updating it, many thanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks