Dear Sir,
thanks for help. i am already woking with index/match fourmula.
i want macro function to solve.
On Fri, May 4, 2012 at 10:49 AM, Deepak Rawat wrote:
> Hi
>
> Pls find the attached. I used formula instead of Macro.
>
> Regards,
> Deepak Rawat
>
>
> On Thu, May 3, 2012 at 9:3
hello,
i am using a form as a user interface for an employee to enter the off day
of their choice week on week.
i want to update the tracker based on the entries from the combobox.
Attached is the sample file with the entry format.
Any help is highly apprecaited.
Regards
Seema
--
F
Hi noorain,
really useful one.
Regards,
venkat
Chennai
--
Sent from my Nokia phone
--Original message--
From: NOORAIN ANSARI
To:
Date: Thursday, May 3, 2012 11:53:00 PM GMT+0530
Subject: Re: $$Excel-Macros$$ Require VBA examples and notes on VBA 2007
Dear Aruna,
Please find a
Mr. Rajan congratulations dear, keep it up
Regards,
Muneer,
CC.
--
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 ge
Dear Sir,
grade calculated on weight age and weight age calculates as
(obs total/total no)*10
(27/40)*10=6.75
then grade will be b2
On Thu, May 3, 2012 at 10:28 PM, Rajan_Verma wrote:
> Hi
>
> Can you please more explain.Like where we need to match Grade Bucket
> Criteria for C
Hi Vaibhav,
You got some other good responses.
Here are versions that should be faster for large ranges, since it does not
have to loop through every cell in column A.
It has an important limitation, though: It will only work correctly if
there are at least two of every unique value in colum
Hello,
I have a file needs to import data from another spreadsheet, that sheet
will have different file name everyday, I want to a macro to populate a
window to open the file and use the full path of the file in further macro,
example:
ChDir "C:\Users\twu\Documents\Database\Item Master"
Hello,
I have 2 sheets in one file, one sheet "A" has less part numbers than the
other sheet "B", would like to have a macro to verify the part number in
"A" vs. "B", anything missing in "B" will be added to the bottom of sheet
"A".
My logical is trying to use "iserror(vlookup(...),0) to see i
Yeah, I don't see how you can avoid a loop (with many files to create).
However, you could do some optimization to avoid copying the whole table to
another range, removing the duplicates, then having to clean all that up,
along these lines:
SRC_RANGE.AdvancedFilter xlfilterinplace, unique:=tru
Is there any videos also available by which can learn.
On Thu, May 3, 2012 at 11:55 PM, Aruna jayaram wrote:
> thank you Noorain
>
>
> On Thu, May 3, 2012 at 11:53 PM, NOORAIN ANSARI
> wrote:
>
>> Dear Aruna,
>>
>> Please find attached Basic note of VBA with example.
>>
>> --
>> Thanks & regard
thank you Noorain
On Thu, May 3, 2012 at 11:53 PM, NOORAIN ANSARI wrote:
> Dear Aruna,
>
> Please find attached Basic note of VBA with example.
>
> --
> Thanks & regards,
> Noorain Ansari
> www.noorainansari.com
> www.excelmacroworld.blogspot.com
>
>
> On Thu, May 3, 2012 at 11:41 PM, Aruna jayar
Hi
I would like to learn VB.net from basics. Can anyone please provide me with
notes and example programs, source code which can help me learn easily.
Thanks
Aruna
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Pleas
Hi
I would like to learn VBA from basics and Macros. Can anyone provide me
with notes and examples, macros examples for 2007.
Thank you
Aruna
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need
Hello Rajan,
Please find the file attached.
Regards
Seema
On Thursday, 3 May 2012 19:48:38 UTC+5:30, Rajan_Verma wrote:
> *Hi Seema,*
>
> *Can you attached the file for Exact Answer? **J***
>
>
>
> * *
>
> *Regards*
>
> *Rajan verma*
>
> *+91 7838100659 [IM-Gtalk]*
>
>
>
> *From:* excel-ma
Hello Gurus,
For some reason when i right click in the attached file(bar chart) and
click on format data series and i want to turn on the secondary axis
option(from the plot series on) in the series option it looks faded out,
pls how do i turn it on? thanks
--
FORUM RULES (986+ members already B
Congrats Rajan !
--
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 be answered.
2) Don't post a que
But not manually if you have many unique values.. Macro is only for saving
time
Regards
Rajan verma
+91 7838100659 [IM-Gtalk]
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of dguillett1
Sent: 03 May 2012 19:55
To: excel-macros@googlegroups.com
S
Please attach file with sample data for understanding.
*Regards,*
*Lalit Mohan*
On Thu, May 3, 2012 at 7:45 PM, Seema wrote:
>
> hi,
>
> I want to have an application which enables the employee to select the day
> to mark as off. i have started with and excel sheet with Names in a column
> a
This is a a better approach than looping
Filter>copy visible to new workbook>save as >close
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
From: Rajan_Verma
Sent: Thursday, May 03, 2012 8:27 AM
To: excel-macros@googlegroups.com
Subject: RE: $$Excel-Macros$$ Split file i
Hi Seema,
Can you attached the file for Exact Answer? J
Regards
Rajan verma
+91 7838100659 [IM-Gtalk]
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Seema
Sent: 03 May 2012 19:45
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Updat
Hi
Please find with solution , Code used as below:
Sub ShowDifferenc()
Dim ArrTabel1
Dim rngTabel2 As Range
Dim ArrResult()
Dim lngRecordCOunter As Long
Dim lngFillArrayAs Long
lngFillArray = 1
ArrTabel1 = Range("rngTable1").CurrentRegion
hi,
I want to have an application which enables the employee to select the day
to mark as off. i have started with and excel sheet with Names in a column
and days on the rows. the days are grouped under week1, week2, week3 etc..
i have a userform with 3 combo box , one for selecting a week
Congratulation bhai
*Regards,*
*Lalit Mohan*
On Thu, May 3, 2012 at 6:21 PM, Rajan_Verma wrote:
> Thank you all. J
>
> ** **
>
> * *
>
> *Regards*
>
> *Rajan verma*
>
> *+91 7838100659 [IM-Gtalk]*
>
> ** **
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.c
Try This
Sub lmTest()
Dim test(50) As String
With ActiveSheet
test(0) = .Cells(1, 2) ' cells(1,2)= "LT12"
test(15) = .Cells(1, 3) ' cells(1,3) "121"
.Cells(1, 10) = CDbl(test(0)) + CDbl(test(15))
End With
End Sub
*Regards,*
*Lalit Mohan*
On Th
copy and paste the below formula in cell T41 and see if it works. I have
just compared the formula in cell T7 with T41 and made them consistent.
=INDEX($D$35:$O$35,MATCH(MIN($R7-($R7>=OFFSET($D$35:$O$35,MATCH($Q7,
$C$36:$C$58,0),0,1))*(OFFSET($D$35:$O$35,MATCH($Q7,$C$36:$C$58,0),0,1))),$R7
-($R7>
Dear Prabhat
Try this
Sub sendEmail(EmailSubject As String, EMailSendTo As String, EMailBody As
String, MailServer as String)
Dim objNotesSession As Object
Dim objNotesMailFile As Object
Dim objNotesDocument As Object
Dim objNotesField As Object
Dim sendmail As Boolean
Hi Jorge,
I think you don’t need any macro for this work, you can do this by
Conditional formatting ..
See the attached file. I have Apply two custom conditional formatting on
Calendar Range,
1) =DAY(TODAY())=C5
2) =VLOOKUP(C5,Sheet2!$A:$B,2,0)="sim"
Regards
Rajan verma
+91
I thought I answered this once already
Use this macro in a macro enabled workbook
Sub insertrows()
Dim i As Long
On Error Resume Next
For i = Cells(Rows.Count, "c").End(xlUp).Row To 2 Step -1
If Cells(i, "c") <> Cells(i - 1, "c") Then Rows(i).Insert
Next i
End Sub
Don Guillett
Microsoft MVP Excel
Dear Nemi
can u please explain step wise your issue.
*Regards,*
*Lalit Mohan*
On Thu, May 3, 2012 at 7:04 PM, Rajan_Verma wrote:
> ** **
>
> Hi,
>
> As I remember ,I have seen this file before 3-4 months on group, can you
> please explain it more .. what you want to do ?
>
> ** **
>
If you want to store the information in Array from worksheets, you can do
that by this way
Sub StoreRangeInArray()
Dim Arr
Arr = Selection
If IsArray(Arr) Then
MsgBox "Information Stored in Array" & vbCrLf & "Row =" & UBound(Arr,
1) & vbCrLf & "Column =" & UBound(Arr, 2)
End If
Try this link
http://office.microsoft.com/en-us/word-help/turn-on-or-off-autocorrect-options-HP005189430.aspx
*Regards,*
*Lalit Mohan*
On Thu, May 3, 2012 at 6:25 PM, Rajan_Verma wrote:
> *You can Check the office autocorrect option *
>
> ** **
>
> * *
>
> *Regards*
>
> *Rajan verma*
>
> *+91
Dear Vaibhav
Please attach sample for reference.
*Regards,*
*Lalit Mohan*
On Thu, May 3, 2012 at 12:17 PM, NOORAIN ANSARI wrote:
> Dear Vaibhav,
>
> Please select required range and run this code..
>
> Sub InsertRows_Vaibhav()
> Dim InsQuan As Integer
> On Error Resume Next
> InsQuan = InputB
Hi,
As I remember ,I have seen this file before 3-4 months on group, can you
please explain it more .. what you want to do ?
Regards
Rajan verma
+91 7838100659 [IM-Gtalk]
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Nemi Gandhi
Sent: 03 Ma
Thank you all. J
Regards
Rajan verma
+91 7838100659 [IM-Gtalk]
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Asa Rossoff
Sent: 03 May 2012 01:40
To: excel-macros@googlegroups.com
Subject: RE: $$Excel-Macros$$ Rajan verma : Most Helpful Member-
Dear Eduardo,
Please try in this way..
Sub Array_Testing()
Dim test(50) As String
test(0) = Cells(1, 2)
test(15) = Cells(1, 3)
Cells(1, 10) = test(0) & " " & test(15)
End Sub
--
Thanks & regards,
Noorain Ansari
www.noorainansari.com
www.excelmacroworld.blogspot.com
On Thu, May 3, 2012 at 6:1
Hi , i need help to work with arrays. I want to create an array and
put information ( from cells) in a specific position of that array. For
example.
Dim test(50) as string
test(0)= Cells(1,2) ' cells(1,2)= "LT12"
test(15)=cells(1,3) ' cells(1,3) "121"
cells(1,10)=test
but
What do you want where and why. Explanations are always nice.
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
From: Nemi Gandhi
Sent: Thursday, May 03, 2012 5:47 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Rising lagna-astrology
Attached herewith shee
If?? you mean you want other months simply add columns as shown on my sample
and fire the macro
a b c
jan09blank feb09 etc
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
From: MURALI NAGARAJAN
Sent: Wednesday, May 02, 2012 11:52 PM
To:
Attached herewith sheet for solution. Please help.
--
Nemi Gandhi
98204 92963
--
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
Yes Rajan you´re absolutely right, thank you very much, it was supposed to
be the excel in the ppt,
I was thinking, instead of putting Green on "Não" and Red "Sim" can´t we do
the macro to put Green whenever the day is = Today() and only put Red if
"Sim" and reset the counter? this way i don´t ha
2012/5/3 Jorge Marques
> Yes Rajan you´re absolutely right, thank you very much, it was supposed
> to be the excel in the ppt,
>
> I was thinking, instead of putting Green on "Não" and Red "Sim" can´t we
> do the macro to put Green whenever the day is = Today() and only put Red if
> "Sim" and re
Dear Experts,
I need urgent help to developed the macro, i've a list of my customer as
Customer Name Address Client Code Mailid Amout Due
I'm using the lotus notes application & wanna send them individual email with
above data fitted in our standard format, the client code is a unique val
Dear noorain.
Thank for your reply.but i can't able to open that file.plz sent that fils
in excel format.
On Thu, May 3, 2012 at 3:12 PM, NOORAIN ANSARI wrote:
> Dear Murali,
>
> Please see attached sheet,
> Hope it will useful to you.
>
> Kindly change path in the code then run.
> Wait 5 minut
Hi Ashsih , and Concern Person.
i Have package in MS Access which i need to take print out as per the PDF.
for this what i am doing i have blank form in pdf so i have pasted the same
in report disign view and convert into image.
and then setting all text boxes and their control. becouse i dont h
thanks
On Thu, May 3, 2012 at 1:24 PM, Asa Rossoff wrote:
> The link refers you to an update for Skype to resolve the issue. Or you
> can simply disable the "Click to call" add-in in Internet Explorer.
>
> ** **
>
> Asa
>
> ** **
>
> *From:* excel-macros@googlegroups.com [mailto:
> exce
The link refers you to an update for Skype to resolve the issue. Or you can
simply disable the "Click to call" add-in in Internet Explorer.
Asa
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of yasir_shahjee
Sent: Thursday, May 03, 2012 1:03 AM
To: exc
yes i have installed
On Tue, May 1, 2012 at 7:10 AM, Asa Rossoff wrote:
> Hi Yasir,
>
> Do you have Skype installed?
>
> ** **
>
> See
> http://answers.microsoft.com/en-us/office/forum/office_2010-excel/text-loses-formatting-when-i-use-cut-copy-paste/0371d013-1e5a-4d2b-874f-792d34d16c61?
Hi V.Kiran,
If you need to use an exact copy of the bank's form, it may be a bit tricky
in Excel. Whether to use Excel at all, and what approach to take if you
do, depends on the reason you are trying to undertake this.
For example, if you want to use an exact copy of the bank's form, and you
48 matches
Mail list logo
