Friends Please help me.
This will save manual work and save time.
On Wed, Aug 7, 2013 at 10:26 PM, Bé Trần Văn betnmtdongna...@gmail.comwrote:
No you do not mind that right?
2013/8/7 KATHIRVELAN N nkathirv1...@gmail.com
Dear Friends,
Please find my requirement details.
1. I'll have
Hi Don, try this
Sub x()
Dim Dtx As Range, dDtx As Integer, dYear As Integer
For Each Dtx In Range(D2:D Range(D2).CurrentRegion.Rows.Count
+ 1)
If Left(Dtx, 3) = 0 Then
dDtx = Mid(Dtx, 6, 3) * 1
dYear = 20 Mid(Dtx, 4, 2)
Dtx.Formula =
Respected Kathirvelan,
Please check the following link for your solution.
http://chandoo.org/wp/2012/05/07/displaying-text-values-in-pivot-tables-without-vba/
Regards,
Vijaykumar
On Fri, Aug 9, 2013 at 11:29 AM, KATHIRVELAN N nkathirv1...@gmail.comwrote:
Friends Please help me.
This will
Replace line
*Erow = Me.Range(A1).End(xlDown).row + 1*
with this one
*If LenB(Trim(Me.Cells(13, 2).Value)) = 0 Then Me.Cells(13, 2).Value =
DATES*
*Erow = Me.Cells(Me.Rows.Count, 2).End(xlUp).Offset(1).row*
If it will not work then you need to share your database as well so that we
can run
Dear Masters,
I wants to get certification on MS Excel by Microsoft.
Kindly help me with below query:
1) Do we have any training for Exam Preparation?
2) Contents for Exam?
3) How where to register for Examination?
4) How much would be the cost for examination?
5)
dear any one,
I need generate the no on installments based on paid amount m file attached
--
*J.Mothilal : **Universal Computer Systems : # 16, Brindavan Complex
:Otteri, Vellore-2*
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join
Try This !
Sub x()
Dim Rng As Range, Str() As Variant
For Each Rng In Range(A3:A Range(A3).CurrentRegion.Rows.Count)
If InStr(1, Rng, Days) 0 Then
Range(B Rng.Row :D Rng.Row) = _
Split(Replace(Replace(Replace(Rng.Text, Days , ), Hrs
, ), Mins, ), )
good day
i have a source sheet and a resultant sheet. i have a form with comboboxes
on which gets it data from the source sheet.
i have 3 dependant combobox on the form. combobox 1 is populated on
userform_initialize, combobox 2 is then populated by a unique list of
values based on combobox 1,
Dear sir,
Thanks a lot for the same . It is working fine .
Can you Please, explain the below code which is underline line in Red
color as i am not able to understand
*Sub x()
Dim Rng As Range, Str() As Variant*
*
For Each Rng In Range(A3:A Range(A3).CurrentRegion.Rows.Count)
firstly, Str() as variant is an array that we need to pass splited
result from this function Split(Replace(Replace(Replace(Rng.Text, Days
, ), Hrs , ), Mins, ), ), but since i has change the code,
we dont need that variable declared, just deleted it, i forgot to do that
If InStr(1, Rng,
Dear Sir,
Thanks a lot...understand the same.
Sir,
Below code is for data A1 to A10 . is it fine? will ans will get correct?
I have checked and ans getting correct ..Is there any further changes need?
This code is created by using your code . I have deleted the same code.
Sub prafull()
For Each
That is, you've almost done with it, just need a little code to prevent
error result
You have a header data In your attachment on cell A3that contain words
RESOLUTIONS TIME, that will also splited by your code, that why i add
data checking therelike as i know you only need to split data that
Dear Sir,
Yes.You are Right ,Sir..
for preventing error you have added the minor code. I got it.
Finally i got my output ...Thanks a lot...
Have a Great Day ..
Regards,
Prafull Jadhav.
On Sat, Aug 10, 2013 at 7:35 AM, De Premor d...@premor.net wrote:
That is, you've almost done with
paste this on macro Sheets2
Private Sub Worksheet_Change(ByVal Target As Range)
Dim iRow As Integer, Dst As Range
If Target.Address = $B$3 Then
[A6].CurrentRegion.Clear
Range(A6:E6) = Split(sno,Amount,int,monthly pay,int +
monthly pay, ,)
For iRow = 1 To [E3]
Hey,
Use the Attached one... I can see the code written here a little bit
slow... it can be made faster if I could get your database
structure...
Thanks,
Anoop
Sr. Developer
On 8/9/13, Lalit Mohan Pandey mohan.pande...@gmail.com wrote:
Replace line
*Erow = Me.Range(A1).End(xlDown).row + 1*
Cross-posted at
http://www.excelfox.com/forum/f2/extract-unique-values-based-on-dependant-combobox-selections-1353/
Please read http://www.excelfox.com/forum/f25/message-to-cross-posters-1172/
Regards,
Sam
On Saturday, 10 August 2013 02:18:19 UTC+5:30, Ricardo Fourie wrote:
good day
i have
hey
pl share sample data!!
Cheers!!
On Sat, Aug 10, 2013 at 2:18 AM, Ricardo Fourie ronin...@gmail.com wrote:
good day
i have a source sheet and a resultant sheet. i have a form with comboboxes
on which gets it data from the source sheet.
i have 3 dependant combobox on the form. combobox
Thanks its working . Mothilal.J
On Sat, Aug 10, 2013 at 9:07 AM, De Premor d...@premor.net wrote:
paste this on macro Sheets2
Private Sub Worksheet_Change(ByVal Target As Range)
Dim iRow As Integer, Dst As Range
If Target.Address = $B$3 Then
[A6].CurrentRegion.Clear
18 matches
Mail list logo