see the attached sheet
Regards
Gawli Anil
On Tue, May 29, 2012 at 11:18 AM, Amit Gandhi silkyro...@gmail.com wrote:
Hi Experts
I want to pick value in Cell C7, C8, C9 ………from List given in Column
L in attached file.
How it will be possible? Pls help me here.
Regards
Amit
--
Hello champ.,
This formula is picking up only first disit of cell only.
1001GANG 1
1002COL. 1
1002TEJI 1
1003SUDH 1
Regards
LAKSHMAN
From: Rajan_Verma rajanverma1...@gmail.com
To: excel-macros@googlegroups.com
Sent: Monday, May 28, 2012 7:12 PM
Subject:
Hi Mr. Anil
This is not the solution i am looking for. I need to pick this from some
LIST for every cell.
Regards
Amit
On Tue, May 29, 2012 at 11:41 AM, Anil Gawli gawlianil8...@gmail.comwrote:
see the attached sheet
Regards
Gawli Anil
On Tue, May 29, 2012 at 11:18 AM, Amit Gandhi
Dear Amit,
You can use it..
*=INDIRECT(ADDRESS(9+ROW(A3),12))*
See attached sheet
Hope it will help to you.
--
Thanks regards,
Noorain Ansari
www.noorainansari.com
www.excelmacroworld.blogspot.com
On Tue, May 29, 2012 at 11:18 AM, Amit Gandhi silkyro...@gmail.com wrote:
Hi Experts
I
Dear Noorain,
Your macro is working, but if there is any formula for this.?
And one thing more i think under formula is not working properlywhich was post
by buddy(MR. RAJAN)
Lakshman ( Deba ) - Rajan posted an excellent formula for extracting all
the numbers already.
Make sure to enter his formula with ctrl-shift-enter (it's an array
formula). It is for Excel 2007+ only because it uses the IFERROR function.
Here is a version modified slightly to work in
Thanks Noorain
But i need something else. Let me clarify more. I am attaching revised
excel file.
I have some BL numbers in 2nd sheet BL_list and I want to enter Invoice
details (INV#, INV DATE, INV AMT) against some B/L#s. I want to choose B/L#
in each cell C5, C6, C7 ... from available
Dear Amit,
Use the Drop Down list options which is available in the Data Validation. I
hope you know it. If not just google how to create drop down list you shall
get the desired that you are looking for.
Or revert to the group to help you out with this.
Thanks,
On Tue, May 29, 2012 at 10:18
Hi,
I have a drop down list which is created using menu 'data validation'.
Is it possible to get the items in the first line in the drop down while
start entering the letters of the items.
Eg: Item Pen, pencils, Notepad is there in my drop down list, if I start
entering P itself Pen and pencils
Hi anil,
How you placed the combo box in Excel?
On Fri, May 25, 2012 at 1:27 PM, Smitha S R sperdwo...@gmail.com wrote:
Is this possible in dropdown list as you have prepared using combo box?
On Tue, May 22, 2012 at 10:05 AM, Anil Gawli gawlianil8...@gmail.comwrote:
your attached file is
How we can place a combo box in excel work sheet?
--
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 Need Advice will not get
quick attention or may not
Goto file option and select customize ribbon and click on choose commands
from.
Then select All tabs and transfer Develper tab to customize ribbon.
Then goto insert combo box
Regards,
Gawli Anil
On Tue, May 29, 2012 at 1:41 PM, Smitha S R sperdwo...@gmail.com wrote:
Hi anil,
How you placed
On Tue, May 29, 2012 at 12:55 PM, Ahmed Honest ahmedhon...@gmail.comwrote:
Dear Amit,
Use the Drop Down list options which is available in the Data Validation.
I hope you know it. If not just google how to create drop down list you
shall get the desired that you are looking for.
Or revert
Dear All,
I want to learn MACRO's from basic so kindly give me some material for the
same.
Thanks Regards,
K SAGAR
--
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,
Hi Smitha,
Use data validation from Excel.
MAngesH
On Tue, May 29, 2012 at 2:01 PM, Smitha S R sperdwo...@gmail.com wrote:
How we can place a combo box in excel work sheet?
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread
how do u know abt this get function?wat it does?and plz let me know how can we
know abt these functions.?
Date: Tue, 29 May 2012 15:08:34 +0530
Subject: Re: $$Excel-Macros$$ regarding font color based condition
From: noorain.ans...@gmail.com
To: excel-macros@googlegroups.com
Dear Sanjib,
Hi Smitha,
MS Excel: Creating a combo box in Excel 2003/XP/2000/97
--
Question: I'm trying to create pull down boxes in Excel 2003/XP/2000/97
with selections to highlight and fill in the cell. How do I do that?
Answer: To create a combo box in Excel, the first thing
Dear Mansoor,
Please check below link..
*http://www.sulprobil.com/html/get_cell.html*
Thanks regards,
Noorain Ansari
www.noorainansari.com
www.excelmacroworld.blogspot.com
On Tue, May 29, 2012 at 3:10 PM, danial mansoor danial_...@hotmail.comwrote:
how do u know abt this get function?wat
Hi Guys,
This is pavan. here i need som info that is it possible to replace fill in
a cell with another specified fill through macro. here one problem is we
don't know which cells we have to replace. the range is not fixed. macro
have to seerch entire workbook and replace existing know fill
Dear Pavan,
Please use..
Sub Close_excelApplication()
Application.Quit
End Sub
--
Thanks regards,
Noorain Ansari
www.noorainansari.com
www.excelmacroworld.blogspot.com
On Tue, May 29, 2012 at 3:18 PM, Pavan Chowdary
pavansai.vall...@gmail.comwrote:
Hi,
This is pavan.
Here i had a
Dear Nooranin Ansari,
This is working fine. But would you explain the below mentioned formula.
You have mentioned the formula outside the date zone even. If i want to
use the formula
in another sheets how to use it?
Waiting for you reply.
Regards,
Sanjib
On Tue, May 29, 2012 at 3:08 PM,
Check mails of this group.
It has been already answered some days before.
ManGesh
On Tue, May 29, 2012 at 1:36 PM, Smitha S R sperdwo...@gmail.com wrote:
Hi,
I have a drop down list which is created using menu 'data validation'.
Is it possible to get the items in the first line in the
Dear Sanjib,
Please check below link..*
*Hope it will help you to use Get.Cell Function.
*
http://www.sulprobil.com/html/get_cell.html*
--
Thanks regards,
Noorain Ansari
www.noorainansari.com
www.excelmacroworld.blogspot.com
On Tue, May 29, 2012 at 3:23 PM, Sanjib Chatterjee
Dear Pavan,
Please share a sample workbook with group.
--
Thanks regards,
Noorain Ansari
www.noorainansari.com
www.excelmacroworld.blogspot.com
On Tue, May 29, 2012 at 3:23 PM, Pavan Chowdary
pavansai.vall...@gmail.comwrote:
Hi Guys,
This is pavan. here i need som info that is it
Hi Masters,
How to convert .xls file to .xlsx?
I have xls file of size of say 42 MB, but once i open it do save as to .xlsx it
gets saved with size of say 4 or 5 MB. Is there any shorter way to save it as
.xlsx without opening the file?
Best Regards,
Amit
how can we get excel 4 functions?any resource?
Date: Tue, 29 May 2012 15:31:25 +0530
Subject: Re: $$Excel-Macros$$ MACRO
From: noorain.ans...@gmail.com
To: excel-macros@googlegroups.com
Dear Sagar,
Please find attached study material of Basic Macro and follow excel-macro
group on regular
Dear Amit,
Please See attached sheet, I hope your requirement is this one otherwise
revert.
--
Thanks regards,
Noorain Ansari
www.noorainansari.com
www.excelmacroworld.blogspot.com
On Tue, May 29, 2012 at 12:48 PM, Amit Gandhi silkyro...@gmail.com wrote:
Thanks Noorain
But i need
Dear Danial,
Best Resource of Excel4 Function is :
*http://www.cpearson.com/excel/Call.htm*
--
Thanks regards,
Noorain Ansari
www.noorainansari.com
www.excelmacroworld.blogspot.com
On Tue, May 29, 2012 at 3:35 PM, danial mansoor danial_...@hotmail.comwrote:
how can we get excel 4
Dear Sir,
I have go through the below mentioned link. but i can not understand.
Would you
please explain why we need to use the *=Get.cell(24,indirect(RC[-1],))
function? Another how to use the formula in other sheet.
regds,
sanjib
*
On Tue, May 29, 2012 at 3:26 PM, NOORAIN ANSARI
2012/5/29 Anil Gawli gawlianil8...@gmail.com
Goto file option and select customize ribbon and click on choose
commands from.
Then select All tabs and transfer Develper tab to customize ribbon.
Then goto insert combo box
Regards,
Gawli Anil
On Tue, May 29, 2012 at 1:41 PM, Smitha S R
If Name of Range is rngRange then
Sub AddRowinNameRange()
Range(rngRange ).Resize(Range(rngRange ).Rows.Count + 1).Name =
rngRange
End Sub
Regards
Rajan verma
+91 7838100659 [IM-Gtalk]
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of
Sorry I forget that password L if you have any tool to break the password
will be good for you J
Regards
Rajan verma
+91 7838100659 [IM-Gtalk]
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Deba Ranjan
Sent: 29 May 2012 10:11
To:
Use this simpler function in a REGULAR module for only numbers. For only text
simply remove the NOT
It will work with all strings such as
12abc34de56fgh78ijk9
Function ONSAS(rng As Range)
Dim i As LONG
For i = 1 To Len(rng)
If Not Mid(rng, i, 1) Like [!0-9] Then
ONSAS = ONSAS
Good Logic, DON Sir
*If Not Mid(rng, i, 1) Like [!0-9] Then*
On Tue, May 29, 2012 at 6:08 PM, dguillett1 dguille...@gmail.com wrote:
Use this simpler function in a REGULAR module for only numbers. For
only text simply remove the NOT
It will work with all strings such as
Hi Noorain,
Send same for Excel 07 Please.
Thanks
MAnGesh
On Tue, May 29, 2012 at 3:31 PM, NOORAIN ANSARI noorain.ans...@gmail.comwrote:
Dear Sagar,
Please find attached study material of Basic Macro and follow excel-macro
group on regular basis.
--
Thanks regards,
Noorain Ansari
Try this:
=SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUT
E(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A1,1,),2,),3,),4,),5,),6,),7,
),8,),9,),0,)
Regards
Rajan verma
+91 7838100659 [IM-Gtalk]
From: excel-macros@googlegroups.com
Dear Mangesh,
File is heavy so, I have send u on your email ID
Please check.
--
Thanks regards,
Noorain Ansari
www.noorainansari.com
www.excelmacroworld.blogspot.com
On Tue, May 29, 2012 at 6:11 PM, Mangesh Dayne mangesh.da...@gmail.comwrote:
Hi Noorain,
Send same for Excel 07 Please.
I just study Excel 2003 Power programming with VBA by J-Walk when I started
to learn VBA
Regards
Rajan verma
+91 7838100659 [IM-Gtalk]
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of SAGAR KASANGOTTUWAR
Sent: 29 May 2012 2:28
To:
It's a best way what you are doing.
Regards
Rajan verma
+91 7838100659 [IM-Gtalk]
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Amit Desai (MERU)
Sent: 29 May 2012 3:30
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Convert .xls
Great J
Regards
Rajan verma
+91 7838100659 [IM-Gtalk]
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of vijayajith VA
Sent: 29 May 2012 6:49
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ How to collect only numeric value from a
But it's not giving correct answer
See the attached sheet
Regards
Rajan verma
+91 7838100659 [IM-Gtalk]
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of vijayajith VA
Sent: 29 May 2012 6:49
To: excel-macros@googlegroups.com
Subject: Re:
The link provided below has a lot to do with the CALL function which is not
supported in latest versions of Excel. If you want to learn about XLM
functions (Excel4), try this link which has an in-depth explanation of the
GET.DOCUMENT and GET.CELL functions
Noorain bhai,
Dhanyawad Kya kahu... Agar dhanyawad ki hi bat hai to hamesha yahi dil se
kahta rahunga...
U R SIMPLY OXYGEN OF THIS GROUP DEAR
with regards,
MangEsh.
On Tue, May 29, 2012 at 6:35 PM, Rajan_Verma rajanverma1...@gmail.comwrote:
*I just study Excel 2003 Power programming with
Only gets the numbers left of text
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
From: vijayajith VA
Sent: Tuesday, May 29, 2012 8:19 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ How to collect only numeric value from a
particular cell
Hi,
Hi Friends,
I need your help for Domain Codes search for file.
Please find the attached sheet.
With regards,
MAnGesh
--
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,
Hello
I currently have installed Excel 2003 on my machine. However would also
like to install 2010 now. If I change the default destination path, will
it create any problems? Will I be easily able to open any excel file
without any Version Clash issues
I understand that very recently,
Hello Ashish,
I had installed 2003/2007 excel versions and i haven't meet any crashes ,
now i have excel 2007 ver. and access 2003 ver.
to have both version installed on your machine , you need to change folder
destination.
On Tuesday, May 29, 2012 5:16:40 PM UTC+3, Ashish wrote:
Just install in a directory OTHER than the previous verion. ie: MyExcel2010
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
From: Ashish Pradhan
Sent: Tuesday, May 29, 2012 9:16 AM
To: Excel Macros
Subject: $$Excel-Macros$$ Multiple Versions of Excel
Hello
I
Can u explain with data?
Regards
Rajan verma
+91 7838100659 [IM-Gtalk]
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Mangesh Dayne
Sent: 29 May 2012 7:32
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Need help for Domain Codes
Hey
Thanks Don and CoRe for the prompt replies. Am going ahead with the
multiple installations. Hope all goes well. :-)
Thanks
Ashish Pradhan
On 29-05-2012 20:25, dguillett1 wrote:
Just install in a directory OTHER than the previous verion. ie:
MyExcel2010
Don Guillett
Microsoft MVP
Hi Rajan,
Please find the sheet consists of sample data on sheet2.
Thanks
ManGesh
On Tue, May 29, 2012 at 9:25 PM, Rajan_Verma rajanverma1...@gmail.comwrote:
Can u explain with data?
** **
* *
*Regards*
*Rajan verma*
*+91 7838100659 [IM-Gtalk]*
** **
*From:*
See the attached file, Just Type the domain Name and Hit enter
In worksheet Module
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Row = 5 And Target.Column = 2 Then
Application.EnableEvents = True
Call Extract
Application.EnableEvents = True
Hello Sam
Haven't yet installed this tool. I use Windows 7 (and I believe this
wouldnt be applicable for windows 7). Have seen the screenshot. Looks
good but have a couple of perhaps stupid questions.
1. Can this file history be cleared ?
2. Can this be un-installed ? (Which leads me to the
Ashish,
Yes this can be used for Windows 7. The only reason I thought Windows 7
users may not find it too useful is because Windows 7 start menu already
has similar features which helps in quickly opening recent files.
No I haven't added a feature to delete history. For the time being, I think
I
Hey Sam
Thanks a lot for the prompt clarifications. Hope to use it soon. -:)
Thanks
Ashish Pradhan
On 30-05-2012 00:23, Sam Mathai Chacko wrote:
Ashish,
Yes this can be used for Windows 7. The only reason I thought Windows
7 users may not find it too useful is because Windows 7 start menu
Please send it to me at josephcam...@yahoo.com
Thanks,
Joseph
Sent on my BlackBerry® from Vodafone
-Original Message-
From: NOORAIN ANSARI noorain.ans...@gmail.com
Sender: excel-macros@googlegroups.com
Date: Tue, 29 May 2012 18:26:24
To: excel-macros@googlegroups.com
Reply-To:
Hi
Can you pls send the files for excel 2007.
On Tue, May 29, 2012 at 3:31 PM, NOORAIN ANSARI noorain.ans...@gmail.comwrote:
Dear Sagar,
Please find attached study material of Basic Macro and follow excel-macro
group on regular basis.
--
Thanks regards,
Noorain Ansari
Hi Noorain
Please send the files for excel 2007.
thanks
On Tue, May 29, 2012 at 3:31 PM, NOORAIN ANSARI noorain.ans...@gmail.comwrote:
Dear Sagar,
Please find attached study material of Basic Macro and follow excel-macro
group on regular basis.
--
Thanks regards,
Noorain Ansari
I would recommend that the defined name be flexible to include
additions/deletions.
=OFFSET(Data!$C$3,1,0,MATCH(zzz,Data!D:$C)-3,1)
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
From: Bé Trần Văn
Sent: Tuesday, May 29, 2012 2:50 PM
To: excel-macros@googlegroups.com
Hi Noorain
Please send the files
thanks
Pawel
From: Aruna jayaram aruna2...@gmail.com
To: excel-macros@googlegroups.com
Sent: Tuesday, May 29, 2012 8:29 PM
Subject: Re: $$Excel-Macros$$ MACRO
Hi Noorain
Please send the files for excel 2007.
thanks
On
Hi Joseph,aruna,lupinskip and anjali,
I have send VBA Ebook 2007(O'Rellay) on your email ID.
Pls check and confirm.
--
Thanks regards,
Noorain Ansari
www.noorainansari.com
www.excelmacroworld.blogspot.com
FORUM RULES (986+ members already BANNED for violation)
1) Use concise,
Noorain Sir,
Can you please send me the file too in my mail ID, the file that you share
with Mangesh.
mail:- drdeva...@gmail.com
Thanks Regards,
*Deba Ranjan P*
On Wed, May 30, 2012 at 8:25 AM, NOORAIN ANSARI noorain.ans...@gmail.comwrote:
Hi Joseph,aruna,lupinskip and anjali,
Sir, i dont have any tool for breaking password. If you have any set up you
can let me know, or else, Please share the file without password. thank you
Rajan Sir.
Thanks Regards,
*Deba Ranjan P*
On Tue, May 29, 2012 at 6:05 PM, Rajan_Verma rajanverma1...@gmail.comwrote:
** **
Sorry
It is showing without manual extaction.
What do u want specify in brief
Regards,
Gawli Anil
On Wed, May 30, 2012 at 5:36 AM, pawel lupinski lupins...@yahoo.com wrote:
Dear All,
I have a problem with adjusting graph, if you can look inside the file and
advice I'll be appreciated.
Noorain Bhai,
Please send it to me, I'll be thankful to you.
With Best Regards
Anirban
--
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 Need Advice
Hi Noorain,
plz send me the files at ashwani.agniho...@gmail.com
thanks...
On Wed, May 30, 2012 at 10:48 AM, Anirban Roy excelanir...@gmail.comwrote:
Noorain Bhai,
Please send it to me, I'll be thankful to you.
With Best Regards
Anirban
--
FORUM RULES (986+ members already BANNED
66 matches
Mail list logo