Re: $$Excel-Macros$$ कविता: अपने Excel-Macro ग्रुप का उम्र,अब 5 साल हो गया.****** FIVE YEARS COMPLETION******THANK YOU******

Dear Brother, I am really falling short of words to describe your dexterity. Your all poems are simply mesmerizing and exhibit your talent not only over IT, but in Literature too. Keep on charming all of us with your talent. Kalyan 2012/3/23 Venkat CV > Dear Noorain, > > Superb > > *Be

$$Excel-Macros$$ Is there any short formula for this result

Dear Noorian and expert, Plz see the attached file. Is there any short formula for this result Regards LAKSHMAN 9582279261 -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem,

$$Excel-Macros$$ RE: So is it common for even an easy question on the forum to not get answered?

Hi H., Not sure how you are determining that Excel knows or doesn't know your column headings are column headings. Do you mean it guesses correctly when you go to sort your data whether you have headings or not? Excel is not a database management system, so you have to get used to the fact that E

RE: $$Excel-Macros$$ Handling Large Blocks of Text in Excel

Hi Padre, Just enable Resize Shape to Fit Text in the properties. You might also consider using a userform and Active X Text Box, which has scroll bars available. See Debra Dalgleish's tutorial at www.contextures.com/exceltextboxformat.html for more on the worksheet Text Box. Asa From

Re: $$Excel-Macros$$ Excel formula help needed

Hi Maries The formula works perfectly for SIC, however for GCB and GGBL, it seems to pick the same figures for all the years. with FML , its picking the an incorrect figures. kindly verify for me. thanks On Thu, Mar 22, 2012 at 8:30 PM, Maries wrote: > GCB & GGBL Error Rectified. PFA latest. >

$$Excel-Macros$$ Re: Is there any short formula for this result

Hello, PFA! Good luck On Friday, March 23, 2012 9:25:33 AM UTC+2, lakshm...@yahoo.com wrote: > > Dear Noorian and expert, > Plz see the attached file. Is there any short formula for this result > Regards > LAKSHMAN > 9582279261 > -- FORUM RULES (986+ members already BANNED for violation) 1)

Re: $$Excel-Macros$$ Simple VBA to Fill in blanks

you can also assign the macro task 1 select column a 2 press f5 3 press special 4 select blank 5 ok 6 edit menue 7 press delete 8 shift cells up ok On Fri, Mar 23, 2012 at 7:04 AM, Jim Schug wrote: > Hi, > I'm nearly brain dead (tired) and can't think straight. I have a simple > issue. A macro

Re: $$Excel-Macros$$ Is there any short formula for this result

I would suggest a table such as with numbers in col 1 and d in col2 I col 3, etc (easier to change in future) then use match index Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com From: LAKSHMAN PRASAD Sent: Friday, March 23, 2012 2:25 AM To: excel-macros@googlegroups.co

Re: $$Excel-Macros$$ कविता: अपने Excel-Macro ग्रुप का उम्र,अब 5 साल हो गया.****** FIVE YEARS COMPLETION******THANK YOU******

From the comments, I only wish I could read it.?? Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com From: NOORAIN ANSARI Sent: Thursday, March 22, 2012 1:42 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ कविता: अपने Excel-Macro ग्रुप का उम्र,अब 5 साल हो गय

Re: $$Excel-Macros$$ Simple VBA to Fill in blanks

http://contextures.com/xlDataEntry02.html#Fill Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com From: Jim Schug Sent: Thursday, March 22, 2012 8:34 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Simple VBA to Fill in blanks Hi, I'm nearly brain dead (tir

$$Excel-Macros$$ SQL Query - Excel VBA

Hi Team, Here I am posting a request for running sql queries in excel macro. I have listed my queries below. Currently am running these queries manually. I want these queries needs to be run automatically. SELECT distinct AMRCostCtr FROM [SRT1].[RequestToolDev].[dbo].[vReqsocs] a,[SRT1].[Request

Re: $$Excel-Macros$$ कविता: अपने Excel-Macro ग्रुप का उम्र,अब 5 साल हो गया.****** FIVE YEARS COMPLETION******THANK YOU******

Here, Don... Where the population of excel lovers is very high Where complete freedom is given to ask and reply Following the posts of which many careers were happily told That excel-macro group, my friends, is now 5 years old.. Be it dusk, dawn, day or night... Posts keep raining jus

Re: $$Excel-Macros$$ Need a small help, related to the Date and Time macro.....

Glad to help Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com From: Indrajit $nai Sent: Thursday, March 22, 2012 5:59 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Need a small help, related to the Date and Time macro. Thanks @ dguillett1.

$$Excel-Macros$$ Re: Insert rows with missing data

Hi, Based on the explanation you provided. I've created a workbook which is attached herewith. Below are some of the requirements for this to function. 1. There is a sheet called "Time Groups" which contains all the time groups in the data once. And they should match the time groups in the data

$$Excel-Macros$$ Re: Simple VBA to Fill in blanks

Hi, Try the following code Sub Fill_In_The_Blanks() Dim i As Long For i = 1 To 1 If Cells(i, 1) = "End" Then Exit For Else If Cells(i, 1) = "" Then Cells(i, 1) = Cells(i - 1, 1) End If End If Next i End Sub The above code would require you to specify where the data en

$$Excel-Macros$$ Re: Simple VBA to Fill in blanks

Hi Sub kTest() On Error Resume Next Columns(1).SpecialCells(4).FormulaR1C1 = "=r[-1]c" Columns(1) = Columns(1).Value On Error GoTo 0 End Sub Kris -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Pl

Re: $$Excel-Macros$$ कविता: अपने Excel-Macro ग्रुप का उम्र,अब 5 साल हो गया.****** FIVE YEARS COMPLETION******THANK YOU******

Dear Abhishek, Excellent, Mind blowing translation... Thank you very much dear. Now Don sir can comment. -- Thanks & regards, Noorain Ansari *http://noorainansari.com/* *http://excelmacroworld.blogspot.com/* 2012/3/23 Abhishek Jain > Her

Re: $$Excel-Macros$$ Excel formula help needed

Hi on Sheet1 In D2:D5 FML SIC GCB GGBL and define the range *'ShtName*' Define B2 '*SheetSelected*' In A12 and copied down & across on P&L(2) =IF(COLUMNS($A12:A12)<=$H$6+1,INDEX(INDIRECT("'"&INDEX(ShtName,ShtSelected)&"'!A5:i120"),ROWS(A$12:A12),COLUMNS($A12:A12)),"") Kris > > -- FO

Re: $$Excel-Macros$$ Excel formula help needed

Kris, this solution is spot on. thanks working to perfection On Fri, Mar 23, 2012 at 3:33 PM, Kris wrote: > Hi > > on Sheet1 > > In D2:D5 > > FML SIC GCB GGBL > and define the range *'ShtName*' > > Define B2 '*SheetSelected*' > > In A12 and copied down & across on P&L(2) > > > =IF(COLUMNS($

Re: $$Excel-Macros$$ Excel formula help needed

i think i get excited over the first few trials but i just realised a few bug .the figures doesnt match the years when you for instance select a year to view On Fri, Mar 23, 2012 at 3:41 PM, hilary lomotey wrote: > Kris, this solution is spot on. thanks working to perfection > > > On Fri, Mar

Re: $$Excel-Macros$$ कविता: अपने E xcel-Macro ग्रुप का उम्र,अब 5 स ाल हो गया.****** FIVE YEARS COMPLETION******TH ANK YOU******

After reading the translation I just want to say... 3 cheers for Excel macros group, Noorain for his original master piece and avishek for ur spellbound translation!! Hip Hip Hurrah!! Sandeep Chhajer. Sent on my BlackBerry® from Vodafone -Original Message- From: Abhishek Jain Sender: e

Re: $$Excel-Macros$$ Excel formula help needed

OK. In B12 and copied down & across, =IF(COLUMNS($A12:B12)<=$H$6+1,INDEX(INDIRECT("'"&INDEX(ShtName,ShtSelected)&"'!A5:i120"),ROWS(B$12:B12),MATCH($H$4,INDIRECT("'"&INDEX(ShtName,ShtSelected)&"'!A4:i4"),0)+COLUMNS($B12:B12)-1),"") Kris > -- FORUM RULES (986+ members already BANNED for violati

$$Excel-Macros$$ Re: So is it common for even an easy question on the forum to not get answered?

I determine it by sorting the column. If the first row is left out of the sort then it is treating it as a header. You say you can override excel on this. How is that done? On Friday, March 23, 2012 12:41:57 AM UTC-7, Asa R. wrote: > Hi H., > Not sure how you are determining that Excel kn

$$Excel-Macros$$ Re: So is it common for even an easy question on the forum to not get answered?

I determine it by sorting the column. If the first row is left out of the sort then it is treating it as a header. You say you can override excel on this. How is that done? On Friday, March 23, 2012 12:41:57 AM UTC-7, Asa R. wrote: > > Hi H., > Not sure how you are determining that Excel know

Re: $$Excel-Macros$$ Excel formula help needed

Thanks Kris its working great. 100% THIS time around Maries thanks a zillion too your formula is also working 100% i just realised that you made cell B11 an absolute reference, i just changed it to B$11 and its now working 100%. thanks both for you assistance =IFERROR(CHOOSE(index,INDIRECT("AL

$$Excel-Macros$$ date should be today's date in calendar in user form of excel

hi group, i want date in calendar in user form should be today's date automatically. Thanks & Regards -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and

Re: $$Excel-Macros$$ कविता: अपने Excel-Macro ग्रुप का उम्र,अब 5 साल हो गया.****** FIVE YEARS COMPLETION******THANK YOU******

Thanks Brother...and really superb 2012/3/23 NOORAIN ANSARI > जहाँ Excel के दीवानों की, है बहूत घनी आबादी. > जहाँ Question,Answer करने की,है खूब आज़ादी. > जहाँ के पोस्ट को follow कर-कर के,कितनो का Career खुशहाल हो गया. > दोस्तों उस अपने Excel-Macro ग्रुप का उम्र, अब 5 साल हो गय

Re: $$Excel-Macros$$ macro vba coding for html file search and paste the path as hyperlink

hi venkat, appreciating for your assistance.. actually i have stored some html files in a particular folder and i wants to search and hyperlink the path of that file in the sheet. Thanks & Regards On Fri, Mar 23, 2012 at 9:49 AM, Venkat CV wrote: > Hi , > > See below link.. > > http://www.pcr

RE: $$Excel-Macros$$ कविता: अपने Excel-Macro ग्रुप का उम्र,अब 5 साल हो गया.****** FIVE YEARS COMPLETION******THANK YOU******

Fantablus!! From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of xlstime Sent: Mar/Fri/2012 10:07 To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ कविता: अपने Excel-Macro ग्रुप का उम्र,अब 5 साल हो गया.** FIVE YEARS COMPLETION**THANK YO

$$Excel-Macros$$ Re: date should be today's date in calendar in user form of excel

Hi, In the workbook open module please write the following code Private Sub Workbook_Open() UserForm1.Calendar1.Value = DateTime.Date End Sub Regards, Damimkader S. Meeran On Friday, March 23, 2012 10:03:44 PM UTC+5:30, Raj Mahapatra wrote: > > hi group, > > i want date in calendar in user form

Re: $$Excel-Macros$$ कविता: अपने Excel-Macro ग्रुप का उम्र,अब 5 साल हो गया.****** FIVE YEARS COMPLETION******THANK YOU******

Thanks Noorain... you are awesome and multi - talented.. regards, DILIPandey On Fri, Mar 23, 2012 at 10:56 PM, Rajan_Verma wrote: > Fantablus!! > > ** ** > > *From:* excel-macros@googlegroups.com [mailto: > excel-macros@googlegroups.com] *On Behalf Of *xlstime > *Sent:* Mar/Fri/2012 10:07 >

Re: $$Excel-Macros$$ Excel formula help needed

Hi Kris Pls why is it that when you select ALL YEAR from cell H4 it seem to give a error? Sent from my BlackBerry® smartphone from Airtel Ghana -Original Message- From: Kris Sender: excel-macros@googlegroups.com Date: Fri, 23 Mar 2012 08:52:30 To: Reply-To: excel-macros@googlegroups

RE: $$Excel-Macros$$ SQL Query - Excel VBA

Hi Sharma, I replied two weeks ago when you posted this question with a detailed response with tips and requesting more information if you still needed help. You didn't reply, but here is my post again. I can help more, bnut please review what I already said and let me know what help you stil

Re: $$Excel-Macros$$ कविता: अपने E xcel-Macro ग्रुप का उम्र,अब 5 स ाल हो गया.****** FIVE YEARS COMPLETION******TH ANK YOU******

Thanks for the translation so I could also enjoy this wonderful poem. Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com From: chhajersand...@gmail.com Sent: Friday, March 23, 2012 10:50 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ कविता: अपने E xcel-M

$$Excel-Macros$$ Show Image on Form

hi forum, Is it possible to show an image on the userform based on the selection of a check box.Say for example i had four countries like Australia,Newzealand,England & West Indies.I had created four check boxes for these four countries.I want to show their Country Flags based on the selection of

Re: $$Excel-Macros$$ कविता: अपने Excel-Macro ग्रुप का उम्र,अब 5 साल हो गया.****** FIVE YEARS COMPLETION******THANK YOU******

Congrates for fice year... And thanks Regards Ram On Mar 23, 2012 12:12 AM, "NOORAIN ANSARI" wrote: > जहाँ Excel के दीवानों की, है बहूत घनी आबादी. > जहाँ Question,Answer करने की,है खूब आज़ादी. > जहाँ के पोस्ट को follow कर-कर के,कितनो का Career खुशहाल हो गया. > दोस्तों उस अपने Ex

$$Excel-Macros$$

Dear Mr. Ayush congratulations for successful completion of 5 years of tenure in helping the others it's a remarkable achievement that cannot be taught by teachers, lecturers & their successors in any of the circumstances in our future life. Our teachers have done! their job to keep the

$$Excel-Macros$$ ****** FIVE YEARS COMPLETION******THANK YOU******

Dear Mr. Ayush congratulations for successful completion of 5 years of tenure in helping the others it's a remarkable achievement that cannot be taught by teachers, lecturers & their successors in any of the circumstances in our future life. Our teachers have done! their job to keep the

Re: $$Excel-Macros$$ Excel formula help needed

Hi In B3 on Sheet1 =IFERROR(MATCH('P&L (2)'!$H$4,INDIRECT("'"&INDEX(ShtName,ShtSelected)&"'!A4:i4"),0),2) Define B3 '*MatchCol'* * * Now in B12 and copy down & across, =IF(COLUMNS($A12:B12)<=$H$6+1,INDEX(INDIRECT("'"&INDEX(ShtName,ShtSelected)&"'!A5:i120"),ROWS(B$12:B12),MatchCol+COLUMNS($B12:

Re: $$Excel-Macros$$ Simple VBA to Fill in blanks

Hi Jim Please always reply to group for prompt response of your query & better solution. someone else may find the solution helpful. HTH Mahesh On Fri, Mar 23, 2012 at 11:12 PM, Jim Schug wrote: > Hi Mahesh, > > Thank you very much. I works perfectly. > > ** ** > > I’m new to posting

Re: $$Excel-Macros$$ कविता: अपने Excel-Macro ग्रुप का उम्र,अब 5 साल हो गया.****** FIVE YEARS COMPLETION******THANK YOU******

Thanks all for their encouraging comments. 2012/3/24 Ram Naresh Verma > Congrates for fice year... > And thanks > > Regards > Ram > On Mar 23, 2012 12:12 AM, "NOORAIN ANSARI" > wrote: > >> जहाँ Excel के दीवानों की, है बहूत घनी आबादी. >> जहाँ Question,Answer करने की,है खूब आज़ादी. >>

$$Excel-Macros$$ Help on Chart

Respected All, Please find attached sheet I want help to make chart. I want to make a bar chart of 2 different thing having the difference very vast for an example reading of one graph is 13,13.5 13.8 14.5 and another reading is 0.98,0.97,0.91,0.87 If I make it on the samoe graph it looks odd . I

$$Excel-Macros$$ Service Count problem

Dear Experts In the userform of the attached workbook contains Date of Joining text box and Date of Retirement textbox. The difference of both the values should come to 23 yrs 01 mth 29 days but it is showing as 23 yrs 01 mth 01 day In my office procedure resultant date should be given 1 bonus

Re: $$Excel-Macros$$ creating hyperlink on userform

Dear Shankar, Please find attached the solution you want. Change the path of your file in the code of the form. I have used a hand shaped cursor file to give a look of a hyperlink to the label. For this I used a cursor file which is also attached. If you are not seeing the "hand-shape" while hove