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 venkat1@gmail.com
Dear Noorain,
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
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
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
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 talk2mar...@gmail.com wrote:
GCB GGBL Error
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) Use
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 sch...@gmail.com wrote:
Hi,
I'm nearly brain dead (tired) and can't think straight. I have a simple
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:
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 साल हो
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
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]
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
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.
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
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 ends.
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
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 PL(2)
=IF(COLUMNS($A12:A12)=$H$6+1,INDEX(INDIRECT('INDEX(ShtName,ShtSelected)'!A5:i120),ROWS(A$12:A12),COLUMNS($A12:A12)),)
Kris
--
FORUM RULES
Kris, this solution is spot on. thanks working to perfection
On Fri, Mar 23, 2012 at 3:33 PM, Kris krishnak...@gmail.com 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 PL(2)
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 resp...@gmail.com wrote:
Kris, this solution is spot on. thanks working to perfection
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
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 violation)
1) Use
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
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 knows
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
Thanks Brother...and really superb
2012/3/23 NOORAIN ANSARI noorain.ans...@gmail.com
जहाँ Excel के दीवानों की, है बहूत घनी आबादी.
जहाँ Question,Answer करने की,है खूब आज़ादी.
जहाँ के पोस्ट को follow कर-कर के,कितनो का Career खुशहाल हो गया.
दोस्तों उस अपने Excel-Macro ग्रुप का
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 venkat1@gmail.com wrote:
Hi ,
See below link..
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
Thanks Noorain... you are awesome and multi - talented..
regards,
DILIPandey
On Fri, Mar 23, 2012 at 10:56 PM, Rajan_Verma rajanverma1...@gmail.comwrote:
Fantablus!!
** **
*From:* excel-macros@googlegroups.com [mailto:
excel-macros@googlegroups.com] *On Behalf Of *xlstime
*Sent:*
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 krishnak...@gmail.com
Sender: excel-macros@googlegroups.com
Date: Fri, 23 Mar 2012 08:52:30
To:
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
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
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
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
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
Hi
In B3 on Sheet1
=IFERROR(MATCH('PL
(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:B12)-1),)
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 sch...@gmail.com wrote:
Hi Mahesh,
Thank you very much. I works perfectly.
** **
I’m new
Thanks all for their encouraging comments.
2012/3/24 Ram Naresh Verma rnverma2...@gmail.com
Congrates for fice year...
And thanks
Regards
Ram
On Mar 23, 2012 12:12 AM, NOORAIN ANSARI noorain.ans...@gmail.com
wrote:
जहाँ Excel के दीवानों की, है बहूत घनी आबादी.
जहाँ Question,Answer
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
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
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
40 matches
Mail list logo