Dear All,
I have attached sheet contains my query on Data Validation - Create a drop
down list containing only unique
--
*Best Regards,*
*Venkat*
*
*
*
*
--
--
Some important links for excel users:
1. Follow us
).Font.Bold = True
End If
Next c
End Sub
** **
Regards.
Daniel
** **
*De :* excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
*De la part de* Venkatesan c
*Envoyé :* vendredi 22 juillet 2011 14:58
*À :* Google
*Objet :* Fwd: $$Excel
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 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
Dear All,
I Have attached data sheet with Login Logout timings..i want how much time
they were in work...Pure Login hrs
have tried one formula...it's working for first 2 Employess not working for
all...
Please suggest any formula or VBA code...
Example:
Data:
User Name Status Login
Hi ,
Please Look below Link
http://www.brainbell.com/tutorials/ms-office/excel/Create_A_Speedometer_Chart.htm
*Best Regards,*
*Venkat*
On Tue, Jul 19, 2011 at 11:36 AM, Chandra Shekar
chandrashekarb@gmail.com wrote:
Hi,
Any suggestion please.
On Mon, Jul 18, 2011 at 2:31 PM,
Hi,
Check The Below link
http://www.mrexcel.com/articles.shtml#Charts
--
*Best Regards,*
*Venkat*
*
*
On Tue, Jul 19, 2011 at 11:37 AM, Chandra Shekar
chandrashekarb@gmail.com wrote:
Hi,
I need a book about graphs/charts only. Thanks!
On Wed, Jul 13, 2011 at 7:15 PM, Vikas Chouhan
Please Attach There is No Attachment...
*Best Regards,*
*Venkat*
*
*
On Mon, Jul 18, 2011 at 11:48 AM, Rsh rashmiv.ni...@gmail.com wrote:
Please help me in reducing the code in the attachment above..
Thnx in advance
--
From:iGATE Global Solutions supreet.sa...@igatepatni.com
Date: 18 Jul 11 20:41:03
Subject: iGate Patni hiring Senior Team Leads for WFM-Forecasting_Bangalore
location
To: venkatesa...@in.com
Job Location: Bengaluru/Bangalore
Dear Candidate,
We have few openings in BPO division.Please find
Hi Siva,
You Can Post your MS Access Query's in this group it self...
*
*
*Best Regards,*
*Venkat*
On Sun, Jul 17, 2011 at 12:13 PM, Siva Sankarnath S sivnt...@gmail.comwrote:
Hi Smarts,
Good day..
Could you send me googlegroup id for MS Access..
--
Thanks
Siva
--
Hi sharad,
look attached..it may Help you...
--
*Best Regards,*
*Venkat*
*
*
On Sun, Jul 17, 2011 at 5:22 PM, sharad jain jainshar...@gmail.com wrote:
Hi Guys,
Can someone please send me a simple code for round off to nearest 10? (No
macro if possible.)
For example, if I put 23 in A1,
Dear All,
Can any one help me on Regression Analysis in Excel with sample data..
*Best Regards,*
*Venkat*
*
*
*
*
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
://en.wikipedia.org/wiki/Regression_analysis
http://office.microsoft.com/en-us/excel-help/perform-a-regression-analysis-HA00963.aspx
On Thu, Jul 14, 2011 at 2:49 PM, Venkatesan c venkat1@gmail.comwrote:
Dear All,
Can any one help me on Regression Analysis in Excel with sample data
Hi Rahim,
Look attached file .
*Best Regards,*
*Venkat*
On Thu, Jul 14, 2011 at 10:35 PM, Rahim Sharieff
rahim.shari...@gmail.comwrote:
Hi Experts,
Please refer the attached workbook.
The first sheet here Schedule gives the training requirements and
Training batches, and the
Hi Jai,
Look Attached below..
On Wed, Jul 6, 2011 at 2:19 PM, Jai jaihumtu...@gmail.com wrote:
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
Hi,
Just Try Copy Paste it will work...
*Best Regards,*
*Venkat*
*
*
On Tue, Jul 5, 2011 at 12:40 AM, hanumant shinde arsfan2...@yahoo.co.inwrote:
Hi friends,
is there any way where we can copy data from closed workbook A and paste
it
into workbook B which is open?
--
Congrats *Ashish,*
*
*
*
*
--
*Best Regards,*
*Venkat*
*
*
On Tue, Jul 5, 2011 at 10:59 AM, Kal xcel kalx...@gmail.com wrote:
Congratulation Ashish...You deserve it
Kalyan
On Mon, Jul 4, 2011 at 11:17 PM, Ahmed galal ahmed.ga...@live.com wrote:
[image:
Hi,
Attach Some data ..and send will try..
*Best Regards,*
*Venkat*
*
*
On Mon, Jul 4, 2011 at 3:47 PM, airen airen1...@gmail.com wrote:
Hi,
i want to count unique values in a selection. I got this formula on
net =SUMPRODUCT((B2:B30)/COUNTIF(B2:B30,B2:B30)) but i dont
know how it
Hi
just install the software and just open that software and click Remove
Password...Before that you have to open
Locked VBA Book..
--
*Best Regards,*
*Venkat*
*
*
On Mon, Jul 4, 2011 at 6:32 PM, Chandra Shekar chandrashekarb@gmail.com
wrote:
How to use this software?
Thanks,
Hi Vikas,
Look the Below Link
http://excelvbatutor.com/vba_tutorial.html
*Best Regards,*
*Venkat*
*
*
On Sun, Jul 3, 2011 at 3:39 PM, vikas verma delhi.ve...@gmail.com wrote:
Hi All,
I am good with excel 2007 now I want to learn VBA coding in order to create
automation tool. Please
to learn more...
i have books if u need i can attach here...
Have A Nice Time Enjoy Life
Regards:
CMA Ankur Pandey
(Someone Different)
I'm not the best but i'm not like the rest~~
On Fri, Jul 1, 2011 at 10:29 AM, Venkatesan c venkat1@gmail.com
wrote
Dear Susan,
You select all sheets(Group it ) and then try this formula.You may get
result in all sheets
*Best Regards,*
*Venkat*
*
*
On Sat, Jul 2, 2011 at 9:52 PM, Susan sunni...@gmail.com wrote:
Hi Dilip,
The formula only returned the first sheet, I need it to sum all sheets
with
*Dear Asish,*
*
*
*Congrats...*
*
*
*Best Regards,*
*Venkat*
*
*
On Fri, Jul 1, 2011 at 9:25 PM, Ayush jainayus...@gmail.com wrote:
Dear Group,
I am extremely happy to share a good news with you. One of our dearest
group member 'Ashish Koul' is awarded Microsoft MVP award on 1st July for
Hi Ak,
Find attached your query resolved
*Best Regards,*
*Venkat*
On Thu, Jun 30, 2011 at 1:10 AM, Monu Tiwari exce...@gmail.com wrote:
Hi Experts,
I want to concatenate the different cells without losing the format of the
cells. Please refer the excel sheet for more details.
Hi Pooja,
Just watch the below link Youtube video's you may get VBA
BasicAdvancedconcepts
*Best Regards,*
*Venkat*
*
*
On Thu, Jun 30, 2011 at 10:32 PM, Pooja Sharma vatspoojav...@gmail.comwrote:
Hi All,
I want to learn VBA, therefore, could anybody suggest with a good link
where I can
Hi Pooja,
Just watch the below link Youtube video's you may get VBA
BasicAdvancedconcepts
http://www.teachmsoffice.com/list-of-tutorials.php?src=tegb
*Best Regards,*
*Venkat*
*
*
On Thu, Jun 30, 2011 at 10:32 PM, Pooja Sharma vatspoojav...@gmail.comwrote:
Hi All,
I want to learn VBA,
this out.
Thanks !!
On Tue, Jun 28, 2011 at 11:58 AM, Venkatesan c venkat1.sql@ gmail.comwrote:
Hi Deepak,
Find attached html file .for your queryYou prepare single pivot from
more than one.data
*Best Regards,*
*Venkat*
On Tue, Jun 28, 2011 at 10:21 AM, dpk dpk1...@gmail.com wrote
, SANJAY SONI
sanjaysoni2...@yahoo.co.inwrote:
Dear Venkar,
I think the attached file can resolve your problem..It will remove your
passward.
*
Best Regards,
*
*Sanjay **
*
**
*From:* Venkatesan c venkat1@gmail.com
*To:* Google excel-macros@googlegroups.com
*Sent:* Tuesday, 28
Dear All,
I want any VBA code or some tool to Unprotect Sheet in Excel 2007
I forgot the password..
*Best Regards,*
*Venkat*
*
*
*
*
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips
--
Thanks regards,
Noorain Ansari
On Tue, Jun 28, 2011 at 11:07 AM, Venkatesan c venkat1@gmail.comwrote:
Dear All,
I want any VBA code or some tool to Unprotect Sheet in Excel 2007
I forgot the password..
*Best Regards,*
*Venkat
*
Dear Paul,
**
Happy Birthday Wishes to you
*
--
*Best Regards,*
*Venkat*
*
*
On Mon, Jun 27, 2011 at 8:30 AM, OpenExcel.com 26may.1...@gmail.com wrote:
Wish you many many Happy Returns of the Day :) Enjoy :)
HappY BirthdaY :)
Best Regards
Ashish Jain
eXceLiTems
Hari,
Find attached
*Best Regards,*
*Venkat*
*
*
*Join My Group:
http://groups.google.com/group/excel-miraclehttps://groups.google.com/group/excel-miracle?hl=en
*
On Mon, Jun 20, 2011 at 11:03 AM, HARI NAIR hari.shrin...@gmail.com wrote:
I WANT YOUR VALUE HELP TO PUT A FORMULA IN THE
Dear All,
Can any one have templates or websites for Call Center InboundOutbound
Manpower scheduling.
--
*Best Regards,*
*Venkat*
*
*
*
*
--
--
Some important links for excel users:
1. Follow us on TWITTER for
Dear Prashant,
Please look below links...
http://www.techonthenet.com/excel/formulas/percentile.php
http://office.microsoft.com/en-us/excel-help/percentile-HP005209211.aspx
*Best Regards,*
*Venkat*
*
*
On Mon, Jun 20, 2011 at 6:16 PM, Prashant pawleprash...@gmail.com wrote:
Dear
Dear Ritesh,
Watch Below Link
http://www.youtube.com/watch?v=KKJj78LoFaA
On Sat, Jun 18, 2011 at 8:20 PM, Susan sunni...@gmail.com wrote:
http://www.excel-vba-easy.com/
-Original Message-
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of
Hi Skanda,
Please use Below formula for our query.
=REPT(0,(9-LEN(B4)))B4
*Best Regards,*
*Venkat*
On Fri, Jun 17, 2011 at 3:46 AM, Skanda skanda.pokkun...@gmail.com wrote:
Hi,
How to add zeros in front of a value with varying lengths so that the
length of the column is 9?
for instance
On Fri, Jun 17, 2011 at 6:00 AM, Venkatesan c venkat1@gmail.com wrote:
Dear Hari,
Just watch the below link video's you may get Some of basics in Excel VBA
http://www.teachmsoffice.com/list-of-tutorials.php?src=tegb
Best Regards,
Venkat
On Thu, Jun 16, 2011 at 8:35 PM, Hari
Dear Hari,
Just watch the below link video's you may get Some of basics in Excel VBA
http://www.teachmsoffice.com/list-of-tutorials.php?src=tegb
Best Regards,
Venkat
On Thu, Jun 16, 2011 at 8:35 PM, Hari harisha.prabha...@gmail.com wrote:
Dear Friends,
Can any one please help me in
Dear All,
Please watch below link in YouTube you may get hundreds of Excel Tips
Tricks... With Excel Sample Excel Workbooks Also
[image: image.png]
*http://www.youtube.com/user/ExcelIsFun?blend=1ob=5*
*
*
*Best Regards,*
*Venkat*
--
Hi Azeema,
Send the sample data and some one will assist the query..
Best Regards,
Venkat..
On Wed, Jun 15, 2011 at 2:38 PM, Azeema Faizunnisa aze...@gmail.com wrote:
I have a table in excel of # of employees by age, sex and category of
employment. The ROWs have three diff categories by
Dear Ayush,
Thank for good share of tutorial
Regards,
Venkat
On Fri, Jun 10, 2011 at 10:13 PM, Ayush jainayus...@gmail.com wrote:
Well, he's done it again. My good friend John Franco just uploaded these free
lookup syntax mastery
downloadshttp://www.1shoppingcart.com/app/?Clk=4338508for
.
On Sat, Feb 19, 2011 at 2:59 AM, Venkatesan c venkat1@gmail.comwrote:
Dear All,
I want to Export data to Excel 2007 from SQL Server 2000 table.Kindly help
on this.
--
*Regards,*
*Venkat*
--
--
Some
Thank U
On Mon, Feb 21, 2011 at 12:35 PM, saggi realsa...@gmail.com wrote:
Just Go on DATA ribbon in Xl, Then Other Sources, then Give the path
of SQL table this exercise need to done once.
after onward same u can pull from Existing Connection just need to
given Username Password.
Dear All,
I want to Export data to Excel 2007 from SQL Server 2000 table.Kindly help
on this.
--
*Regards,*
*Venkat*
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
RefTbl(r, 1).Resize(1, RefTbl.Columns.Count).Copy
Cells(n, 1).PasteSpecial xlPasteValuesAndNumberFormats
End If
Next r
Application.CutCopyMode = False
Next i
End Sub
On Thu, Sep 23, 2010 at 5:03 PM, Venkatesan c venkat1@gmail.comwrote:
Dear Group,
I
Dear Group,
Excel is the User friendly Application Compare then all Spread sheets It's
Very much Easy to Handle New user's Too..
Best Regards,
*
Venkat
*
--
--
Some important links for excel users:
1.
Dear Group,
Excel is the User friendly Application Compare then all Spread sheets It's
Very much Easy to Handle New user's Too..
*Best Regards,*
**
*Venkat*
On Sat, Aug 28, 2010 at 12:19 PM, Ayush jainayus...@gmail.com wrote:
Its a very handy tool for any data analysis and reporting.
Dear Group,
I have attached sample data below i want to get defined criteria Emp id's.
Can i have any formula's or Macros
Best Regards,
*
Venkat
*
--
--
Some important links for excel users:
1. Follow us on
Dear Kalyan,
My Correct Requirement Is Attached below
On Wed, Aug 25, 2010 at 4:30 PM, Kal xcel kalx...@gmail.com wrote:
Hi venkat,
VLOOKUP formula will solveyour problem, see the attachment.
On Wed, Aug 25, 2010 at 3:15 PM, Venkatesan c venkat1@gmail.comwrote:
Dear Group,
I
:
On Tue, Aug 17, 2010 at 5:31 PM, Venkatesan c venkat1@gmail.comwrote:
Dear Group,
Find the attached data Required.I want to Extract Only Mobile Numbers from
the strings
Raw Data Required on 16th *091* rnr. 91 on 16th *
018* s/o. *018* on 16th *0188811
Dear Group,
Find the attached data Required.I want to Extract Only Mobile Numbers from
the strings
Raw Data Required on 16th *091* rnr. 91 on 16th *
018* s/o. *018* on 16th *0188811* s/o. *0188811* on
16th *02008285228* ringing cm disconnected the call.
cm disconnected the
call. *02008285228*
On Tue, Aug 17, 2010 at 8:59 PM, bhavya khanna bhavya...@gmail.com wrote:
On Tue, Aug 17, 2010 at 5:31 PM, Venkatesan c venkat1@gmail.comwrote:
Dear Group,
Find the attached data Required.I want to Extract Only Mobile Numbers from
the strings
Dear Group,
Find Below data Requirement.I Want to extract numbers post (_ )Only.
Raw Data Required
Best Regards,
Venkat
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links
?t=312142
Regards,
Andy
On Thu, Jun 3, 2010 at 6:57 PM, Venkatesan c venkat1@gmail.comwrote:
Dear Group,
Can i have UNIQUEIFS Function its some thing like SUMIFS
Best Regards,
*
Venkat
Dear Group,
Can i have UNIQUEIFS Function its some thing like SUMIFS
Best Regards,
*
Venkat
*
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
shtName = Left(shtName, 2) Replace(shtName, 05, 06, 3)
sht.Name = shtName
Next
End Sub
Regards,
*Jitendra Kr. Verma** ***
--
*From:* excel-macros@googlegroups.com [mailto:
excel-mac...@googlegroups.com] *On Behalf Of *Venkatesan c
*Sent
*
*
*
*Sheets(i).Name = Left(Sheets(i).Name, 3) mo Right(Sheets(i).Name,
3)*
*Next i*
*
*
*End Sub*
Warm Regards,
Harmeet Singh
http://www.facebook.com/libraharry
On Tue, Jun 1, 2010 at 3:07 PM, Venkatesan c venkat1@gmail.comwrote:
Dear Group,
I have attached here file for help
Dear Ayush,
Good show
Best Regards,
*
Venkat
*
On Mon, May 24, 2010 at 9:00 AM, Ayush jainayus...@gmail.com wrote:
Dear Group Members,
Finally, after long time we have achieved a milestone of 7000
members.
I would use this moment to thank each one of you for your contribution
to the
Dear Group,
I have attached here with help required sample data.I had given input
output required in different sheets.
please any one create for this VB Code and let me know
Best Regards,
*
Venkat
*
--
--
Some
. Hope this will help. Please let me know in case you
need my assistance.
Regards,
Deepak
On Sat, May 22, 2010 at 4:21 PM, Venkatesan c venkat1@gmail.comwrote:
Dear Group,
I have attached here with help required sample data.I had given input
output required in different sheets
Dear Group,
Any send me with example Multiple conditions Lookup
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN
Dear Group,
Need Assistance for folowing Problam
active cell value is Number(or)text(or)Formula Should show as a msg box by
using Macro
*Thanks Regards,*
*Venkatesan C*
--
--
Some important links for excel users
Dear Group.
Iam the beginner for Excel macros.
I want to know what is the procedure to write a macro and kindly provide
some examples in excel files
*Thanks Regards,*
*Venkat *
--
--
Some important links for
Course for beginners over internet.
--
Thanks Regards,
DILIP KUMAR PANDEY
MBA-HR,B.Com(Hons),BCA
Mobile: +91 9810929744
dilipan...@gmail.com
dilipan...@yahoo.com
New Delhi - 62, India
On Tue, Apr 13, 2010 at 12:27 PM, Venkatesan c venkat1@gmail.comwrote:
Dear Group.
Iam
Dear Group,
Please help me to create Function for below Problam Help books,Procedure
to create udf's
20100312=12-mar-2010
*
Thanks Regards,
Venkat C*
--
--
Some important links for excel users:
1. Follow us on
Dear All,
Any one can Assist me attached file query It's something like reverse Lookup
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
Dear All
Can I Have Excel Macros PDF Complete Guide
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Excel and VBA Tutorials(Video
67 matches
Mail list logo