Hi
Where can I find some good info on :
When a macro runs I want a input box for user to insert the column range
A:(or B; or F: etc) and then a input box for the text to look for say
ABC or 123 or xyz etc and then a third box for the column for a format to be
done.
Have googled but have not
Hi,
Is this possible using formula ?
On Thu, Jul 21, 2011 at 7:38 PM, Anish Shrivastava wrote:
> Hi Vijay,
>
> See the attached file. let me know if it works fine.
>
> On Thu, Jul 21, 2011 at 7:26 PM, vijayajith VA wrote:
>
>> Hi,
>>
>> I have names, order no and county names in two sheets.. nee
Hi Noorain,
Thanks for the links...
If you could share me some call center dashboard excel templates...it would
be great for me...
Thank You...
On Thu, Jul 21, 2011 at 10:10 PM, Raghunandan wrote:
> Hi Guys,
>
> Can any1 help me out by sending Call center KPI dashboards or any link
> where i
Hi All,
Thank you all for your response.
Special thanks to Noorain Ansari, who provided me what I wanted.
Regards,
Raghavendra
On Jul 22, 8:22 am, NOORAIN ANSARI wrote:
> Dear Raghvendra,
>
> Please try below code and see attached sheet
>
> Sub advancefilter_sumif()
> Dim i, j As Long
>
Thank u Ashish. I will check it out and come back to u If I have any
clarification. Thanks!
On Thu, Jul 21, 2011 at 3:07 PM, ashish koul wrote:
> http://akoul.blogspot.com/2011/06/macro-to-import-data-from-webpage-to.html
>
> http://akoul.blogspot.com/2011/06/copy-data-of-webpage-to-excel-using.
Hi All,
Please can anyone help me how to export excel pivot data into access table
or text file
Is that possible?
Thanks in advance
Sushil
--
--
Some important links for excel users:
1. Follow us on TWITTER for ti
Hi Asish,
How to pull out particular lines or paragraphs in any site. Can we do this
without using webquery method. Please let me know about this.
Thanks,
Chandra Shekar B
On Fri, Jul 22, 2011 at 1:00 PM, Chandra Shekar <
chandrashekarb@gmail.com> wrote:
> Thank u Ashish. I will check it o
Try this
=SUBSTITUTE(A1,"abc","#")
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Prabhu
Sent: Thursday, July 21, 2011 8:51 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ ***Formula for find and replace***
Hi Friends,
Can you he
Try the Attachement
-Original Message-
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Daniel
Sent: Thursday, July 21, 2011 9:36 PM
To: excel-macros@googlegroups.com
Subject: RE: $$Excel-Macros$$ VBA Conditional Format Offset
Try :
Sub ConFormatOff
Set Wb=ActiveWorkbook
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Jorge Marques
Sent: Thursday, July 21, 2011 10:44 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Help Macro doesn´t work anymore, keeps giving same
error
Hi guys, i
See the attached File,
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Prabhu
Sent: Thursday, July 21, 2011 10:54 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Excel formula help
Hi Friends,
In the attached sheet wherever we find
See if it helps
http://danielcurran.com/outlook/how-to-create-a-reminder-email-for-outlook-e
mail-from-excel/
http://www.dummies.com/how-to/content/setting-up-email-reminders-in-outlook-
2007.html
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Prabh
See if it helps.
http://www.steptocallcenter.com/call_center_operational_documents_templates.
html
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Raghunandan
Sent: Thursday, July 21, 2011 10:10 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macro
If your date in A and B Column then Try it
Sub RemoveDuplicate()
Dim rng As Range
Dim cell As Range
Set rng = Range("A2:A" & ActiveSheet.UsedRange.Rows.Count)
For Each cell In rng
If WorksheetFunction.CountIf(rng, cell.Value) > 1 Then
cell.EntireRow.Delete
End If
Ne
Try this
Sub ReMoveDuplicateAndSum()
Dim cell As Range
Dim Rng As Range
Range("A:A").Copy Range("E1")
Range("E:E").RemoveDuplicates 1
Set Rng = Range("F2:F" & Range("E1").End(xlUp).Row)
Range("F1").Value = "Amount"
For Each cell I
Try This
Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As
Boolean)
MsgBox "You Can not save this Workbook"
Cancel = True
End Sub
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Anshul
Sent: Friday, July 22, 2011 12:07 AM
T
Sub ShowInputBOx()
Range("A1").value=application.inputbox ("Please enter A value")
End Sub
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Cab Boose
Sent: Friday, July 22, 2011 1:47 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ VBA Macr
Try the Attached Sheet
When it will open it will ask the UserName , I have Give Two User name in
Codes 1) Adam 2) Rajan
After enter the Username as CommandBar will add with Different Menus
Regards
Rajan.
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On B
Hope you will like it, J
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/gr
Open Both Sheets and Run This Macro to Get Desired Result :
Sub Seperate()
Dim Wbopen As Workbook
Dim wb As Workbook
Set wb = Workbooks.Add
ActiveWorkbook.SaveAs "Consolidate"
wb.Sheets.Add.Name = "BT"
wb.Sheets.Add.Name = "BT-1"
For Eac
I am a newbie to VBA
I have a word document that is composed of many pages with text. I
want to find the first occurance of "Objective" and copy the text that
follows then paste it into A1. Find the next occurance and past it
into A2. Do this until the end of the word file. Then find the fi
Do the following 1.creTe word app 2.take microsoft word library in the
references 3m specify the path of word doc and
On 7/22/11, dkelb wrote:
> I am a newbie to VBA
> I have a word document that is composed of many pages with text. I
> want to find the first occurance of "Objective" and
thank you...
On Fri, Jul 22, 2011 at 7:12 PM, Rajan_Verma wrote:
> *See if it helps.*
>
>
> http://www.steptocallcenter.com/call_center_operational_documents_templates.html
> **
>
> * *
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *Raghunandan
I dont' know the details of the code. Do you mind scripting it up??
Thanks.
On Fri, Jul 22, 2011 at 11:23 AM, hari kumar wrote:
> Do the following 1.creTe word app 2.take microsoft word library in the
> references 3m specify the path of word doc and
>
> On 7/22/11, dkelb wrote:
> > I am a new
Attached your word document.
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Darin Kelberlau
Sent: Saturday, July 23, 2011 9:04 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Copy text from Word and paste into Excel
I dont' know th
25 matches
Mail list logo