Congrats Rajan .. bhayee
--
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)
Dear Rajan
Congratulation brother. :)
On 5/3/12, Maries talk2mar...@gmail.com wrote:
*Congrats Brother.*
On Wed, May 2, 2012 at 8:15 PM, xlstime xlst...@gmail.com wrote:
Congratulation Rajan
On Wed, May 2, 2012 at 9:30 PM, Ayush Jain jainayus...@gmail.com wrote:
Hello
Dear all,
I have a spreadsheet containing daily customer transaction data. I have
used SUMIF to find out the monthly customer transaction data.
However, it is tedious to copy the formula and paste for next month when
next month comes.
Can anyone suggest any VBA code / idea to help shifting
Dear Vaibhav,
Please select required range and run this code..
Sub InsertRows_Vaibhav()
Dim InsQuan As Integer
On Error Resume Next
InsQuan = InputBox(Enter number of rows to insert, Your Call)
If InsQuan = 0 Then
MsgBox Invalid number entered, vbCritical, Stop!
Exit Sub
End If
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
thanks
On Thu, May 3, 2012 at 1:24 PM, Asa Rossoff a...@lovetour.info 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:
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 noorain.ans...@gmail.comwrote:
Dear Murali,
Please see attached sheet,
Hope it will useful to you.
Kindly change path in the code then
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
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
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 rajanverma1...@gmail.comwrote:
*You can Check the office autocorrect option *
** **
* *
*Regards*
*Rajan
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
End Sub
Dear Nemi
can u please explain step wise your issue.
*Regards,*
*Lalit Mohan*
On Thu, May 3, 2012 at 7:04 PM, Rajan_Verma rajanverma1...@gmail.comwrote:
** **
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
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
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
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
Congratulation bhai
*Regards,*
*Lalit Mohan*
On Thu, May 3, 2012 at 6:21 PM, Rajan_Verma rajanverma1...@gmail.comwrote:
Thank you all. J
** **
* *
*Regards*
*Rajan verma*
*+91 7838100659 [IM-Gtalk]*
** **
*From:* excel-macros@googlegroups.com [mailto:
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
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 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$$
This is a a better approach than looping
Filtercopy visible to new workbooksave 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
Please attach file with sample data for understanding.
*Regards,*
*Lalit Mohan*
On Thu, May 3, 2012 at 7:45 PM, Seema vasee...@gmail.com 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
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
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
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
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
thank you Noorain
On Thu, May 3, 2012 at 11:53 PM, NOORAIN ANSARI noorain.ans...@gmail.comwrote:
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,
Is there any videos also available by which can learn.
On Thu, May 3, 2012 at 11:55 PM, Aruna jayaram aruna2...@gmail.com wrote:
thank you Noorain
On Thu, May 3, 2012 at 11:53 PM, NOORAIN ANSARI
noorain.ans...@gmail.comwrote:
Dear Aruna,
Please find attached Basic note of VBA with
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 if the
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
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
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 rajanverma1...@gmail.comwrote:
Hi
Can you please more explain.Like where we need to match Grade
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
Hi noorain,
really useful one.
Regards,
venkat
Chennai
--
Sent from my Nokia phone
--Original message--
From: NOORAIN ANSARI noorain.ans...@gmail.com
To: excel-macros@googlegroups.com
Date: Thursday, May 3, 2012 11:53:00 PM GMT+0530
Subject: Re: $$Excel-Macros$$ Require VBA
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
--
34 matches
Mail list logo