Hi Seti, Thanks for responce but i know that formula but i need here vba code for same.
On 5/20/11, STDEV(i) <[email protected]> wrote: > (1) > Array formula: > > =SMALL(IF(('[Row data.xlsx]Sheet1'!$D$3:$D$105>=C2)* > ('[Row data.xlsx]Sheet1'!$D$3:$D$105<=C3),ROW(1:103)),ROW(1:103)) > > (2) > Formula > =IF(ISERR($A6),"",OFFSET('[Row data.xlsx]Sheet1'!B$2,$A6,0)) > > check the attachments and see if it helps.. > > -siti- > > > > On Fri, May 20, 2011 at 5:39 PM, Umed Singh > <[email protected]>wrote: > >> Hi Gurus, >> >> please help me to write vba code in attached report file. >> >> Actully i want to extract data from one file to onother file. as >> selecting start date and end date. >> >> Regards, >> Umed Singh >> >> > -- Umed Singh -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to [email protected] <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
