Re: $$Excel-Macros$$ Need mis in excel vba format must in search engine

2011-05-22 Thread Umesh Dev
Hi Kannan, To create a report in this format is not advisable. The data have to be in contiguous, there should not be merged cell in between them. Maintain listing productivity and broker productivity separately. if you maintain it this way the data can be pulled in a numbers of ways in seconds.

Re: $$Excel-Macros$$ Dynamic formula

2011-05-22 Thread Skanda
Ashsih, Format of file is attached but no data On Sat, May 21, 2011 at 8:29 AM, Skanda skanda.pokkun...@gmail.com wrote: On Sat, May 21, 2011 at 12:39 AM, ashish koul koul.ash...@gmail.comwrote: can you attach the sample file On Fri, May 20, 2011 at 10:07 PM, Skanda

RE: $$Excel-Macros$$ Re: Macro for Converting txt to xls using Text Import Wizard

2011-05-22 Thread Susan
Thank you Asish. This works great! From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of ashish koul Sent: Friday, May 20, 2011 10:36 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Re: Macro for Converting txt to xls using Text Import

$$Excel-Macros$$ Keep formula in cell

2011-05-22 Thread Bob
Is there a way to keep the formula in the cell when you enter your own value? Thanks in advance -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links :

Re: $$Excel-Macros$$ Copy paste data for dynamic data_need Excel Macro Solution

2011-05-22 Thread sagar aher
Hey Thanks Mahesh...its working fine for me...:) On Sun, May 22, 2011 at 12:07 AM, Mahesh parab mahes...@gmail.com wrote: Hi Sagar find attach, check whether its as per u r requirement. Thanks, Mahesh On Wed, May 18, 2011 at 9:42 AM, sagar aher sagara...@gmail.com wrote: Hi,

Re: $$Excel-Macros$$ Keep formula in cell

2011-05-22 Thread STDEV(i)
when you type a data ( event a dot ) in a cell, the old data (incl. FORMULA) in the cell will be removed and replaced with the new data. with macro you can automatically keep the old data (and stored in another place) and then enter the new value in the same cell cmiiw On Mon, May 23, 2011 at