http://support.microsoft.com/kb/306125
http://support.microsoft.com/kb/321686
http://www.ozgrid.com/forum/showthread.php?t=83016page=1
On Thu, Jul 21, 2011 at 10:44 AM, Markkim mark@gmail.com wrote:
Hi all
I'm trying to learn how to connect to SQL Server and extract information
from
Hi Ashish
Thanks for that. How do I toggle the 'TabOrder' on ? At the moment the tab
order is not working.
Thanks
Charlie
On Thu, Jul 21, 2011 at 7:08 PM, ashish koul koul.ash...@gmail.com wrote:
try this
On Thu, Jul 21, 2011 at 11:36 AM, Cab Boose swch...@gmail.com wrote:
Hi Rajan
Can someone help this is really urgent.
Thanks
Harish
On 20 July 2011 23:06, Harish Sharma harishsharma...@gmail.com wrote:
Hi Anish,
Please find attached the sample file with one row filled.
And Column C Column H concatenate should give us unique value so if
this is repeated then we need
Sure Harish :) ..
You will have it soon..
On Thu, Jul 21, 2011 at 3:45 PM, Harish Sharma harishsharma...@gmail.comwrote:
Can someone help this is really urgent.
Thanks
Harish
On 20 July 2011 23:06, Harish Sharma harishsharma...@gmail.com wrote:
Hi Anish,
Please find attached the
Harish,
I forgot to ask you one thing.
The column headers in the file you attached will be constant for all the
30-35 files which are there on your sharedrive, right?
Cheers,
Anish
On Wed, Jul 20, 2011 at 11:06 PM, Harish Sharma
harishsharma...@gmail.comwrote:
Hi Anish,
Please find attached
Hi,
Just Go to Below link and sign in your Gmail account..and set as a
https://groups.google.com/group/excel-macros/subscribe?hl=en
and go to Edit my membership ---Email *(Approximately 15 emails per day)*Send
each message to me as it arrives
and save it...
--
*Best Regards,*
*Venkat*
*
*
Hi,
How to extract data from websites for ex: Yahoo News Columns. could anyone
provide VBA code for this. Thanks!
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
Hi Harsih,
Since you didnt reply about column headers I assumed that it's the same for
every file on share drive.
Please see the attached file with macro.
You must populate the file path in Sheet2-A1.
Do let me know if it works fine for you.
Cheers!!
Anish
On Thu, Jul 21, 2011 at 4:00 PM,
Harish,
PLease ignore the earlier attachment as I forgot to add *DUPLICATE CHECK* in
that macro.
Use this attachment.
On Thu, Jul 21, 2011 at 5:09 PM, Anish Shrivastava anish@gmail.comwrote:
Hi Harsih,
Since you didnt reply about column headers I assumed that it's the same for
every
Hi Masters,
can anybody please forward me excel dashboard designs i need dashboard
designs with all automations and vba work like drop downs , charts, graphs
a dashboard with full graphical and customization interface
i'll be realy greatfull to you guys please forward me the designs,
Regards,
open this link
http://chandoo.org/wp/excel-dashboards/
On Thu, Jul 21, 2011 at 4:49 PM, Avinash Patil avinash007pa...@gmail.comwrote:
Hi Masters,
can anybody please forward me excel dashboard designs i need dashboard
designs with all automations and vba work like drop downs , charts, graphs
can you send the direct link
On Thu, Jul 21, 2011 at 4:34 PM, Chandra Shekar
chandrashekarb@gmail.com wrote:
Hi,
How to extract data from websites for ex: Yahoo News Columns. could anyone
provide VBA code for this. Thanks!
--
Hi Avinash,
Try this:
http://www.freeexceldashboards.com/exceldashboardtemplates.html
Cheers,
Andy
On Thu, Jul 21, 2011 at 4:49 PM, Avinash Patil avinash007pa...@gmail.comwrote:
Hi Masters,
can anybody please forward me excel dashboard designs i need dashboard
designs with all automations
Thanks a ton to one all really helped me alot in this concern.
On Mon, Jul 18, 2011 at 11:30 PM, Mahesh parab mahes...@gmail.com wrote:
Hi
For Vlookup you can use static Name range which is predetermined
RANGE
=SBUMapping!$A$1:$D$789
OR
dynamic Name range range which resize dynamically
Any link is ok. Just I need to learn how to do this task. Thanks.
On Thu, Jul 21, 2011 at 2:15 PM, ashish koul koul.ash...@gmail.com wrote:
can you send the direct link
On Thu, Jul 21, 2011 at 4:34 PM, Chandra Shekar
chandrashekarb@gmail.com wrote:
Hi,
How to extract data from
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.html
http://akoul.blogspot.com/2011/06/macro-to-copy-text-from-webpage-to.html
On Thu, Jul 21, 2011 at 6:30 PM, Chandra Shekar
Hi Avinash,
Try below Links,
http://www.l3analytics.com/2011/05/16/free-excel-dashboard-template/
http://www.excelcharts.com/blog/how-to-create-an-excel-dashboard/
http://www.contextures.com/excel-dashboards.html
http://www.mrdashboard.com/download.html
--
*Best Regards,*
*Venkat*
*
*
On
Vijay,
Though you have provided the sample sheet your requirement is not clear.
What do you mean by merge the names in one sheet. do you want to consolidate
the data or you want a concatenation.
On Thu, Jul 21, 2011 at 5:33 PM, vijayajith VA vijayajith...@gmail.comwrote:
fyi
On Wed, Jul
Hi,
I have names, order no and county names in two sheets.. need to consolidate
in one sheet..
Thanks
On Thu, Jul 21, 2011 at 7:04 PM, Anish Shrivastava anish@gmail.comwrote:
Vijay,
Though you have provided the sample sheet your requirement is not clear.
What do you mean by merge the
Hi Friends,
Can you help me to know the formula for find and replace.Examble i need to
find ABC in the A1 cell and replace with #. If there is no 'ABC
existing A1 should remain as it is.
Existing CellReplace as
12ABC 12# 13XTZ 13XTZ
--
Hi Friends,
Can you help me to know the formula for find and replace.Example i need to
find ABC in the A1 cell and replace with #. If there is no 'ABC
existing A1 should remain as it is.(Not using ctr+H)
*Example.*
Existing Cell Replace as
12ABC 12#
Giving the formula as per your example.
*=IF(RIGHT(A1,3)=ABC,LEFT(A1,2)#,A1)*
Copy it down.
On Thu, Jul 21, 2011 at 8:55 PM, Prabhu prabhugate...@gmail.com wrote:
Hi Friends,
Can you help me to know the formula for find and replace.Example i need to
find ABC in the A1 cell and replace
HI,
Sub ABCReplace()
[A1].Replace ABC, #
End Sub
Regards.
Daniel
De : excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] De
la part de Prabhu
Envoyé : jeudi 21 juillet 2011 17:26
À : excel-macros@googlegroups.com
Objet : $$Excel-Macros$$ Re: ***Formula for find
You are welcome.
Oh just noticed, out of curiosity, why is my message displayed after
Ashish's? I messaged it before!!
On Jul 21, 2:47 am, Natron protoc...@gmail.com wrote:
Thanks to both Ashish and GoldenLance. Problem solved.
--
If you are looking for an Excel formula, just use
=SUBSTITUTE(A1,ABC,)
On Jul 21, 8:37 pm, Daniel dcolarde...@free.fr wrote:
HI,
Sub ABCReplace()
[A1].Replace ABC, #
End Sub
Regards.
Daniel
De : excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] De
la part de
Try :
Sub ConFormatOffset()
With Range([A1], Cells(Rows.Count, 1).End(xlUp))
.FormatConditions.Delete
.FormatConditions.Add Type:=xlExpression, Operator:=xlGreater, _
Formula1:==A1B1
.FormatConditions(1).Interior.Color = RGB(255, 0, 0)
End With
End Sub
Hi Anish,
If it is ABC12 and i need to replace the ABC form the cell then the
formula will be ?
Regards,
Prabhu
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
Hey Prabhu,
try this formula
=IF(ISERROR(REPLACE(A1,FIND(ABC,A1),3,#)),A1,(REPLACE(A1,FIND(ABC,A1),3,#)))
On Thu, Jul 21, 2011 at 8:50 PM, Prabhu prabhugate...@gmail.com wrote:
Hi Friends,
Can you help me to know the formula for find and replace.Examble i need to
find ABC in the A1
Wouldn't this be much more easier, and apt?
=SUBSTITUTE(A1,ABC,#)
On Jul 21, 9:27 pm, Prabhu prabhugate...@gmail.com wrote:
Hi Anish,
If it is ABC12 and i need to replace the ABC form the cell then the
formula will be ?
Regards,
Prabhu
--
Prabhu,
Use the solution given by GoldenLance below.
=SUBSTITUTE(A1,ABC,#)
*GoldenLance,*
Thanks Man, This formula didnt hit my mind at that time.
On Thu, Jul 21, 2011 at 10:02 PM, GoldenLance samde...@gmail.com wrote:
Wouldn't this be much more easier, and apt?
=SUBSTITUTE(A1,ABC,#)
On
Harish,
Did you try it.. ??
On Thu, Jul 21, 2011 at 5:19 PM, Anish Shrivastava anish@gmail.comwrote:
Harish,
PLease ignore the earlier attachment as I forgot to add *DUPLICATE CHECK*in
that macro.
Use this attachment.
On Thu, Jul 21, 2011 at 5:09 PM, Anish Shrivastava
@Anish, that's cool dude, just trying to help.
Sam Mathai Chacko
On Jul 21, 9:41 pm, Anish Shrivastava anish@gmail.com wrote:
Prabhu,
Use the solution given by GoldenLance below.
=SUBSTITUTE(A1,ABC,#)
*GoldenLance,*
Thanks Man, This formula didnt hit my mind at that time.
On
Hi All,
Great!!! Thanks..
Regards,
Prabhu
--
--
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 @
Thanks Daniel that works, but I'm still trying to wrap my head around
applying this format to various ranges on the worksheet.
My data I'm comparing is in Column D and F, E and Getc all the way
up to Column EK. Any pointers on skipping around with this formula?
Thanks again!
Natron
Try
Hi guys, i have this macro i use to copy a range from column D of a
worksheet of a workbook to column G of another workbook and worksheet, but
it keeps giving me the same error saying that it´s subscript out of range
in the line in yellow.
Public wb, wbmes As Workbook
Sub filldatabase()
Call
Please check if the sheet name is Pivot.
if not then rename it to Pivot.
On Thu, Jul 21, 2011 at 10:44 PM, Jorge Marques leote.w...@gmail.comwrote:
Hi guys, i have this macro i use to copy a range from column D of a
worksheet of a workbook to column G of another workbook and worksheet, but
it
Hi Friends,
In the attached sheet wherever we find *Opt. *(Opt dart and a space) is
replace with # and add with the previous cell which does not contain
Opt.originally.
As per the attached sheet A9,10,11,12 we have to remove Opt. and add #
with A8 as prefix.
Similarly in A3 Opt. 0D1-
Dear members,
Thanks for all your contribution to group. I am very happy to see the
great participation in the group.
For me its very important to know what you feel about the group, So that I
can take any action or initiative on the basis of your feedback.
This is an anonymous survey, so feel
Hi,
Can anyone let me know VBA code for the below?
Input Data
Names Amount
A 100
B 200
C 100
B 100
A 100
D 150
Out put data should be
Names Amount
A 200
B 300
C 100
D 150
Regards,
Raghavendra
--
Thank you Dave for the last cell point the correction. I didn't notice the
last column being Yes.
I think Column U don't have to be blank, because we have an additional
column (A) without Yes or No, so If we change the formula without including
column U, like,
Hello Prabhu,
Use SUBSTITUTE. or excel's Find/Replace command
SUBSTITUTE is a case sensitive function, so you need convert the cell to
UPPER or LOWER, so use,
=SUBSTITUTE(UPPER(A1),ABC,)
Or,
=SUBSTITUTE(LOWER(A1),abc,)
All the letters in 1st output will be in CAPITAL LETTERS
All the letters
Yes, the names are all ok, i double checked it, even try to change names,
but doesn´t work :S
2011/7/21 Anish Shrivastava anish@gmail.com
Please check if the sheet name is Pivot.
if not then rename it to Pivot.
On Thu, Jul 21, 2011 at 10:44 PM, Jorge Marques leote.w...@gmail.comwrote:
Hi,
How to learn Excel VBA. If i chose VB.Net course it's cover Excel VBA
Or any special course to learn Excel VBA.
Also advice where i can learn.
Regards,
Prabhu
--
--
Some important links for excel users:
1.
is it possible to attach the sheet? You can remove the data from it or
replace the values..
On Thu, Jul 21, 2011 at 11:04 PM, Jorge Marques leote.w...@gmail.comwrote:
Yes, the names are all ok, i double checked it, even try to change names,
but doesn´t work :S
2011/7/21 Anish Shrivastava
Yes Prabhu, It is possible.. Pour in your further details/sample
attachments.
On Thu, Jul 21, 2011 at 11:03 PM, Prabhu prabhugate...@gmail.com wrote:
Hi all,
I need to send Automatic mail message from my mail id to some around 10
members in every week end to remind them to do something.
I
A Pivot Table is used precisely for such computations. As a thumb
rule, use Excel functions and tools where Excel can handle it
efficiently. Use VBA only if Excel cannot give desired output on its
own
On Jul 21, 10:19 pm, Raghavendra raghavendra@gmail.com wrote:
Hi,
Can anyone let me know
Try :
Sub ConFormatOffset3()
Dim LastRow As Long
LastRow = Cells.Find(*, , , , xlByRows, xlPrevious).Row
With Range([D1], Cells(LastRow, EJ))
.FormatConditions.Delete
.FormatConditions.Add Type:=xlExpression,
Formula1:==AND(F1,D1F1)
Hi,
You can’t do it with a formula (a formula only changes the value of the cell
which contains it). Either you use the replace command (Ctrl+H) or you have
to use a macro.
Regards.
Daniel
De : excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] De
la part de Prabhu
Envoyé
try this
=IF(ISERROR(REPLACE(A2,FIND(Opt.,A2),3,#)),A2,(REPLACE(A2,FIND(Opt.,A2),3,#)))
On Thu, Jul 21, 2011 at 10:54 PM, Prabhu prabhugate...@gmail.com wrote:
Hi Friends,
In the attached sheet wherever we find *Opt. *(Opt dart and a space) is
replace with # and add with the previous cell
try the attached file
On Fri, Jul 22, 2011 at 2:33 AM, Vikas Chouhan vikask...@gmail.com wrote:
try this
=IF(ISERROR(REPLACE(A2,FIND(Opt.,A2),3,#)),A2,(REPLACE(A2,FIND(Opt.,A2),3,#)))
On Thu, Jul 21, 2011 at 10:54 PM, Prabhu prabhugate...@gmail.com wrote:
Hi Friends,
In the
check few examples here
http://akoul.blogspot.com/2010/07/vba-code-to-send-email-through-excel.html
http://akoul.blogspot.com/2011/07/sending-birthday-images-messages-to.html
http://akoul.blogspot.com/2010/08/sending-e-mail-based-on-data-in-column.html
On Fri, Jul 22, 2011 at 12:01 AM, Anish
try this book
http://www.recordexcelmacro.com/vebooks/RecordExcelMacrosthatWork.pdf
and websites join these forums
www.mrexcel.com www.contextures.com www.rondebruin.nl www.ozgrid.com
www.cpearson.com
peltiertech.com
chandoo.org
www.mvps.org/links.html
www.vbaexpress.com
add this line before if condition see if it helps
wb.Sheets(Pivot).select
On Thu, Jul 21, 2011 at 11:56 PM, Anish Shrivastava anish@gmail.comwrote:
is it possible to attach the sheet? You can remove the data from it or
replace the values..
On Thu, Jul 21, 2011 at 11:04 PM, Jorge
create a pivot table . check the attachment.
On Thu, Jul 21, 2011 at 10:49 PM, Raghavendra raghavendra@gmail.comwrote:
Hi,
Can anyone let me know VBA code for the below?
Input Data
Names Amount
A 100
B 200
C 100
B 100
A 100
D 150
Out
Dear Raghunandan,
Please use below link for Call center Dashboard
http://www.klipfolio.com/products/call-center-dashboard
http://www.inovasolutions.com/call-center-reporting/products/call-center-dashboard.html
On Thu, Jul 21, 2011 at 10:10 PM, Raghunandan raghunandan...@gmail.comwrote:
Hi
Dear Raghvendra,
Please try below code and see attached sheet
Sub advancefilter_sumif()
Dim i, j As Long
Dim abc, cba As Range
Application.ScreenUpdating = False
Sheet1.Range(A1:A Sheet1.Range(A1).End(xlDown).Row).Copy
Sheet1.Range(D1).Select
ActiveSheet.Paste
Sheet1.Range(E1).Value =
Please let me know how i can remove save as option from excel file...I have
restrict persons not to save as anexcel file.
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links
Experts,
In order to unlock locked sheets/workbooks or VBA project, which program or
codes would you suggest.
Regards
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
Hi
1. I have created a database with some custom menus. In that I am having a
menu called Manage and I require a code which should hide the particular
menu for particular users.
2. I have created a form for startup and I don’t want allow the users to
close the form using the Cnrl+W. It should
Hi
Pls find the code.
Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As
Boolean)
If SaveAsUI Then
Cancel = True
End If
End Sub
This will work only if the workbook has been saved once.
On Fri, Jul 22, 2011 at 12:07 AM, Anshul anshula...@gmail.com wrote:
Please let me
60 matches
Mail list logo
