Re: $$Excel-Macros$$ Useful Link ( Excel, Access, Word, Powerpoint ) VBA

2011-03-31 Thread raafi barey
Hi Dilip, Below mentioned link mght also be a help to you, it has a pictorial view to understand... http://www.techonthenet.com/index.php Thanks Raafi On Thu, Mar 31, 2011 at 10:41 AM, Dilip Pandey wrote: > Thanks Ashish...!! > This is awsome site. > > Best Regards, > DILIPandey > > On 3/30

$$Excel-Macros$$ Re: Excel-Help

2009-04-26 Thread raafi barey
that is sent from someone else (you don't have control of the source) > and > c) it has a million lines that are broken into 1,000 columns > > is a COMPLETELY different answer than if the data is coming from MicroSoft > Access and your QUERY is returning the same million rows. >

$$Excel-Macros$$ Excel-Help

2009-04-24 Thread raafi barey
Hi, I have a data which is more than the capacity of excel 2002..how can i retrieve the complete data..ny possibilty of loading into seperate sheets.. Regards Raafi --~--~-~--~~~---~--~~

$$Excel-Macros$$ Re: doubt

2009-03-31 Thread raafi barey
et.com/excel/questions/referencing.php > > Hope it helps. > > Regards, > Andy > > On Tue, Mar 31, 2009 at 4:38 AM, raafi barey wrote: > >> Hi.. >> I am back again with another doubt.. >> what is the difference between >> A$2 >> $A2 >&g

$$Excel-Macros$$ doubt

2009-03-30 Thread raafi barey
Hi.. I am back again with another doubt.. what is the difference between A$2 $A2 $A$2 .. what is the significance of this dollar sign..pls reply.. --~--~-~--~~~---~--~~ - Some impor

$$Excel-Macros$$ Re: Reg. Output to be more viewable

2009-03-23 Thread raafi barey
wrote: > > Hi Raafi Barey, > > You need to use Pivot Tables. The output you required is perfectly > obtainable through them even for 10 lac rows of data(not just 5000 > rows). I've seen your file and only after that I've made this view for > solution. Please reply, i

$$Excel-Macros$$ Reg. Output to be more viewable

2009-03-22 Thread raafi barey
Hello Team, Can anyone please help me to make my output more systamatic and viewable, I have attached an excel sheet which has two tabs 1.output, which shows the output format which i pull it from DB. 2. Required Output, is the output which I wanted so that it is more presentable, Can anyone plea