Hi Ayush,
There is a sort of a workaround.
If you have xl2007, but others using the sheet only have xl2003:
Create the worksheet in XL2007, insert the 2 filters using the 'Format as
Table' thingy, then save it as a .xlsx file.
Now open the file in XL2003, (with the microsoft file conversion updat
Thank you Dave fro your inputs.
This is good workaround and weird too. But difficult for those who
have only XL 2003. isn't it ?
Best regards,
Ayush Jain
Group Manager
On Apr 11, 12:41 pm, Dave Bonallack wrote:
> Hi Ayush,
> There is a sort of a workaround.
> If you have xl2007, but others usin
Yes you can put filters to 2 or more times in Excel
The Trick is first time you put the normal filters.
and 2nd and onwards choose the data you wanna put filters and go to insert
table select the range click on "My Table has Headers"
and it is done.
Example attached
Regards
Hemant Koranne
On We
Agreed.
_
View photos of singles in your area! Looking for a hot date?
http://clk.atdmt.com/NMN/go/150855801/direct/01/
--
--
Hi Group,
I want to know, how can we call a macro stored in Module1 in other modules
Example:
Module1 has "test1" stored as a public sub
and i want to call this Sub in a Commandbutton created on Sheet1
Example2:
Module1 has "test1" stored as a Private sub
and i want to call this Sub in a Co
Hello.
Private Sub CommandButton1_Click()
test1
End Sub
Regards.
Daniel
De : excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] De
la part de harpreetgujral
Envoyé : dimanche 11 avril 2010 15:08
À : excel-macros@googlegroups.com
Objet : $$Excel-Macros$$ Calling a
Hello dear
You can call function in any of event...
i.e
workbook open
button click
sheet active
..
...
Most important is Calling the function.
Private Sub CommandButton1_Click()
call test1
End Sub
Hope it will Help
Happy to Help
:)
Prashant Tripathi
On Sun, Apr 11, 2010 at 6:59 PM
1 > Booking 5546935512 adfafasjfahf
2 > PONU022439-0 tonnes of instant full cream milk powder with 28
percent butter fat.
3 > cont TTNU942301-1 full cream milk with 28 percent butter fat.
i want to pull specific string like
from line 1 nos 5508556545 (it can be anywhere)
from line 2 PONU02243
Hi Praveen,
Siti's formulae for column D and E are fine and should be applied
first. But then I suggest to run this macro, because the SUMPRODUCT is
not working for me...
Feedback please.
Kind regards,
Paul Willekens
'===
Sub
Hi Anju,
Of cours, you give too few examples, but at least for the two formats
following macro shoud do the job.
Give some feedback.
Kind regards,
Paul Willekens
'===
Sub PullNumber()
Dim cChar
Dim cContent
Dim cNumber
Dim lF
Hi Paul,
Yeah its working fineU did a great Job...Thanks for ur time.
On Sun, Apr 11, 2010 at 9:20 PM, paulwillekens <
paul.johan.willek...@gmail.com> wrote:
> Hi Anju,
>
> Of cours, you give too few examples, but at least for the two formats
> following macro shoud do the job.
>
> Give s
Anyways m using the below code for it...let me knw if there is any
flawsAlso can i use wildcards with instr function.
Sub Test()
Dim i As Long, sTemp As String
Dim stext As String
stext = Range("A1").Value
i = 1
Do
sTemp = Mid$(stext, i, 15)
sTemp = Repla
I'm surely there are several workable solutions, but I would think the
easiest would be to apply the first filter, copy the resulting visible
rows to a new tab/sheet and apply the second filter there.
On Apr 7, 8:53 am, Jai wrote:
> Dear All Members.
>
> How can put the filter 2 times in One Exc
Just for fun (or for a different approach), here is a third way:
Public Function WsIndex(WsName As String) As Integer
On Error Resume Next
WsIndex = ThisWorkbook.Worksheets(WsName).Index
End Function
Public Sub test()
If 0 <> WsIndex("Budget 2011") Then
MsgBox "Budget 2011 exi
Thanks everybody for your responses.
The trouble is the most, when the subroutine is defined as Private
Sub. Any solutions to this:
Example2:
Module1 has "test1" stored as a Private sub
and i want to call this Sub in a Commandbutton created on Sheet1
Thanks
Harry
On Apr 11, 6:43 pm, rf123
Anju,
Your query requires a special effort to achieve. However, there are many
macros available who will extract text or numbers from a given cell but I am
afraid they will not work for you without being edited as per your specific
requirements. For example, a simple number extract macro will extr
Thanks Ayush.
My tuppence:
Extracting unique vales from a range with a function or formula is missing.
Using Advanced Filter every time is a bit lengthy process. It should be
something like =UNIQUEVALUES(A1:A100).
I got a workaround for the above though ;-) but I think it should reside in
Excel
Harry,
Have you tried either;
Application.Run "Test"
Or
Application.Run "Book1!Test"
Both work for me...
PS: Hope you created you commandbutton from Visual Basic Toolbar and not
from Forms Toolbar. Yes! both are different. :-)
Cheers!
AJ
On Mon, Apr 12, 2010 at 8:16 AM, Harpreet Singh Gu
18 matches
Mail list logo