Re: $$Excel-Macros$$ Interesting Question

2011-07-29 Thread Dilip Pandey
You are welcome. . . Regards, DILIPandey On 7/29/11, XLS S wrote: > Thnx Sir > > On Fri, Jul 29, 2011 at 10:31 AM, Dilip Pandey wrote: > >> Hi, >> >> I have used offset function to achieve the desired result. >> Refer the attachment and let me know if this works. >> >> Regards, >> DILIPandey >>

Re: $$Excel-Macros$$ Interesting Question

2011-07-27 Thread Dilip Pandey
Please share the sample file. Regards, DILIPandey On 7/27/11, XLS S wrote: > function > > On Wed, Jul 27, 2011 at 10:55 AM, Dilip Pandey wrote: > >> Ok... do you need solution in VBA or Function. >> Also it would be great if you can share a sample workbook. >> >> Regards, >> DILIPandey

Re: $$Excel-Macros$$ Interesting Question

2011-07-26 Thread ashish koul
try this http://www.vbaexpress.com/kb/getarticle.php?kb_id=454 On Wed, Jul 27, 2011 at 10:55 AM, Dilip Pandey wrote: > Ok... do you need solution in VBA or Function. > Also it would be great if you can share a sample workbook. > > Regards, > DILIPandey > > On 7/27/11, XLS S wrote: > > Hello

Re: $$Excel-Macros$$ Interesting Question

2011-07-26 Thread Dilip Pandey
Ok... do you need solution in VBA or Function. Also it would be great if you can share a sample workbook. Regards, DILIPandey On 7/27/11, XLS S wrote: > Hello Friend, > > > Suppose that, i have one excel sheet their is more then 50 columns and 100 > rows, i want extract data 20 rows and 41 colum

$$Excel-Macros$$ Interesting Question

2011-07-26 Thread XLS S
Hello Friend, Suppose that, i have one excel sheet their is more then 50 columns and 100 rows, i want extract data 20 rows and 41 columns (Different - 2 location), how to extract data Condition:- Don't use Copy and paste -- . -- -