Re: $$Excel-Macros$$ Fwd: Help Required

Hello Dear, Study materials already provided by admin of this group. Please try to search in post. For your 1'st Program,u can try this Tools-->Macro-->Visual Basic Editor or Alt+ F11 This workbook 'Sample Code

$$Excel-Macros$$ Move from column a to b to c in loop

Hello again friends, I am cannot figure out how to make this work the way I want :( I need this to run in column a, then b, then c... but cannot figure out how to do it. Can someone please help with this matter. I'm sure it's a very simple solution! Sub Macro1() ActiveCell.Offset(-1, 0) = 1 Do

$$Excel-Macros$$ Re: qx() enhanced database function

I have included the file with the code and usage instructions for the database function qx in the group's files directory. QX_enhanced_database_function.xls Note the code is not password protected - feel free to mod or canibalize as needed. Nevertheless, citing myself as a source would be the 'ri

Re: $$Excel-Macros$$ Re: Convert to unique rows

Sorry, I have now found the group file section and will use it myself. Stephen, your problem amused me so much I wrote a new QFunction 'QSplit' that does the job. The file I am about to upload is called: manos_w_QSplit.xls It takes the following arguments: QString([ArrayIn],[HeaderIncl],[SplitC

$$Excel-Macros$$ Pivot Table - Prevent to add/remove fields except page field

Hi, I have a sheet with three Pivot Tables. I want to allow the user to select any value on the Page fields, but I don't want the user to: - Add more page fields - Remove the existing page fields - Add/remove any other field in the Pivot Is there any way to prevent the user to do it??

Re: $$Excel-Macros$$ Re: Convert to unique rows

Just to clarify, there is file in Group's file section. Have attached it herewith. AJ On Tue, Apr 13, 2010 at 3:39 PM, Dougie Excel wrote: > As Paul Willekens said, you've not uploaded anything. > > The easiest solution to your task *sounds* like it would be a pivot > table (just google 'excel

Re: $$Excel-Macros$$ Fwd: Help Required

Chk this link http://obp.math.vu.nl/edu/project-obp/VBA-intro.pdf On Tue, Apr 13, 2010 at 2:53 PM, Venkatesan c wrote: > Thank u Dilip > > Can i have any pdf with u > > > > On Tue, Apr 13, 2010 at 2:49 PM, Dilip Pandey wrote: > >> Hi Venkatesan, >> >> Up to Excel 2003, go to Tools-> Macro-> Re

$$Excel-Macros$$ Re: Convert to unique rows

As Paul Willekens said, you've not uploaded anything. The easiest solution to your task *sounds* like it would be a pivot table (just google 'excel pivot tutorial' or something and you'll find out all you need). The QX Function* can summarize databases on unique criteria as well, but being a VBA

$$Excel-Macros$$ Re: Need help on the below xl file

Hi Paul, Thanks a lot Paul. Its working amazing!! Regards, Vinod. On Apr 12, 11:18 pm, paulwillekens wrote: > Here it is... > > Greetings, > > Paul Willekens > '=== > Sub GetCenters() > > Dim cLevel1 > Dim cLevel2 > Dim cLevel3

Re: $$Excel-Macros$$ Fwd: Help Required

Thank u Dilip Can i have any pdf with u On Tue, Apr 13, 2010 at 2:49 PM, Dilip Pandey wrote: > Hi Venkatesan, > > Up to Excel 2003, go to Tools-> Macro-> Record New Macro. Now perform some > actions on excel spreadsheet. Press Alt + F11 when you are done. Select > modue 1 under your workbo

$$Excel-Macros$$ Re: Pivot Problem

Hi Chaudhry, I hate to commit sacrilege in the Excel VBA sight but its sounds like excel is probably not the right solution for such a massive task. Access can handle larger database queries. Even if you use Access to perform all your summerizing and then export it back to excel for the presentati

Re: $$Excel-Macros$$ Fwd: Help Required

Hi Venkatesan, Up to Excel 2003, go to Tools-> Macro-> Record New Macro. Now perform some actions on excel spreadsheet. Press Alt + F11 when you are done. Select modue 1 under your workbook's name in left pane and watch out for the code. These are the codes which excel has created as per your a

Re: $$Excel-Macros$$ : How to add the current month Date in the header

Hi Sundarvelan, For first of the current month, use following function:- =DATE(YEAR(TODAY()),MONTH(TODAY()),1) For current date, use following function:- =TODAY() -- Thanks & Regards, DILIP KUMAR PANDEY MBA-HR,B.Com(Hons),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com N

$$Excel-Macros$$ Re: Convert to unique rows

Hi Stephen, No upload in the picture... Greetings, Paul Willekens -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our Facebo

$$Excel-Macros$$ : How to add the current month Date in the header

Hi Group, Im doing a project in which i need to add date "From" date as first of the Current month and "To" date should be current date Please help me in this regard. Thanks, N.Sundarvelan -- -- Some important link

$$Excel-Macros$$ Fwd: Help Required

Dear Group. Iam the beginner for Excel macros. I want to know what is the procedure to write a macro and kindly provide some examples in excel files *Thanks & Regards,* *Venkat * -- -- Some important links for exce

Re: $$Excel-Macros$$ Pivot Problem

> Dear all group Members, > > I am also a member of your very good group. > I am very pleased to be in this group becasue i have learned a lot of excel > from here. > i would like to mention that in these days there is no mail i had received > that contains attachment file from where i can understa

Re: $$Excel-Macros$$ Wildcards with Instr FUnction

Hi Wht type Help u req in access (Query,Form.) On Mon, Apr 12, 2010 at 11:47 PM, anju wrote: > Can we use wildcards with instr function.If yes how ? > > > I also need help in MS Acsess ? Can u pls guide me to the right way > > -- > >

Re: $$Excel-Macros$$ Pivot Problem

Dear all group Members, I am also a member of your very good group. I am very pleased to be in this group becasue i have learned a lot of excel from here. i would like to mention that in these days there is no mail i had received that contains attachment file from where i can understand the proble