RE: $$Excel-Macros$$ Data validation - Need help to prevent Duplicate Entry

2013-10-16 Thread Ravinder
Pls use this if you like this. (sorry missed attachment in last mail) From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of ashish koul Sent: Wednesday, October 16, 2013 8:38 PM To: excel-macros Subject: Re: $$Excel-Macros$$ Data validation - Need help to preve

RE: $$Excel-Macros$$ Data validation - Need help to prevent Duplicate Entry

2013-10-16 Thread Ravinder
Pfa, if u like to use this... From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of ashish koul Sent: Wednesday, October 16, 2013 8:38 PM To: excel-macros Subject: Re: $$Excel-Macros$$ Data validation - Need help to prevent Duplicate Entry try this Priv

RE: $$Excel-Macros$$ week selection by criteria

2013-10-16 Thread Ravinder
PFA. IF u r looking for this. From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Avinash Sent: Thursday, October 17, 2013 2:07 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ week selection by criteria hi all, i want criteria based wee

$$Excel-Macros$$ Getting Object variable or with block variable not set while getting the table from the webpage

2013-10-16 Thread Menaka Balakrishnamoorthy
Hi, I've written a code to navigate from one webpage to another and getting the table from the second webpage. Sometimes its getting the table value and sometime I'm getting Object variable or with block variable not set error. I think while setting the line Set doc = ie.Document, 'm getting t

$$Excel-Macros$$ week selection by criteria

2013-10-16 Thread Avinash
hi all, i want criteria based week selection attached is the excel sheet for better understanding. Regards, Avinash -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discuss

Re: $$Excel-Macros$$ Help needed in creating a Dashbord

2013-10-16 Thread alisha malhotra
Hi I have attached some dummy data. Please suggest how can I calculate on year basis or division basis like if I change the division to calculate the head count/CTC then data should change automatically. In HR Dashboard I can show the status of recruitment done/ Exits/Head Count in a particular

Re: $$Excel-Macros$$ VBA for Excel to Word

2013-10-16 Thread koul . ashish
Can u share sample workbook n output format in word document Sent on my BlackBerry® from Vodafone -Original Message- From: Justin Pulley Sender: excel-macros@googlegroups.com Date: Wed, 16 Oct 2013 10:47:40 To: Reply-To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ VBA for E

$$Excel-Macros$$ VBA for Excel to Word

2013-10-16 Thread Justin Pulley
Is it possible to write a macro that exports two worksheets out of a workbook to Word? currently I export to .pdf which I thought was fine, but my boss asked for an export to word. The challenge is one of the worksheets contains charts that need to go with it. current code ThisWorkbook.Shee

Re: $$Excel-Macros$$ Re: Prince Kumar - Most Helpful Member Jan'13

2013-10-16 Thread ashish koul
which link On Wed, Oct 16, 2013 at 9:00 PM, PrIyAnKa wrote: > pls send me link for re sub > On 30-Jul-2013 2:47 PM, "vba" wrote: > >> Hi >> >> Do one thing, check your spam box & if you dont find there also. >> >> or else Unsub & Re-Sub. >> >> Thanks >> >> >> On Tue, Jul 30, 2013 at 2:33 PM, P

Re: $$Excel-Macros$$ Re: Prince Kumar - Most Helpful Member Jan'13

2013-10-16 Thread PrIyAnKa
pls send me link for re sub On 30-Jul-2013 2:47 PM, "vba" wrote: > Hi > > Do one thing, check your spam box & if you dont find there also. > > or else Unsub & Re-Sub. > > Thanks > > > On Tue, Jul 30, 2013 at 2:33 PM, PrIyAnKa wrote: > >> Please help me ,i'm not getting emails from group ,i'm sti

Re: $$Excel-Macros$$ Need macro for converting PDF in to given format

2013-10-16 Thread Jocky Beta
Hi Ashish, Thanks for the prompt reply but i can not use the same due to policy, request you to kindly give me the alternate option. Regards On Wed, Oct 16, 2013 at 8:34 PM, ashish koul wrote: > try *able2extract *professional version > > > On Wed, Oct 16, 2013 at 8:10 PM, Jocky Beta wrote:

Re: $$Excel-Macros$$ Data validation - Need help to prevent Duplicate Entry

2013-10-16 Thread ashish koul
try this Private Sub Worksheet_Change(ByVal Target As Range) If Target.Column = 1 Then If Application.WorksheetFunction.CountIf(Range("a:a"), Target.Value) > 1 Then Target.Value = "" MsgBox "Duplicate entry is not allowed", vbInformation, "Note:" End If

Re: $$Excel-Macros$$ Need macro for converting PDF in to given format

2013-10-16 Thread ashish koul
try *able2extract *professional version On Wed, Oct 16, 2013 at 8:10 PM, Jocky Beta wrote: > Hi Team, > > I need help on above attached sheets, In the excel sheet i should browse > the PDF file (which is attached in this mail ) and then the output data > should be come in given format. > > Look

$$Excel-Macros$$ Data validation - Need help to prevent Duplicate Entry

2013-10-16 Thread Secret Shot
Dear Exterts, I am stuck in my project and need your expert advice that ho can i prevent duplicate data entry in any colom, but i have to use list validation too at the same time So for example my source range is G1:G10 on the basis of this i need to put list validation on range A1:A10, but i wan

$$Excel-Macros$$ Need macro for converting PDF in to given format

2013-10-16 Thread Jocky Beta
Hi Team, I need help on above attached sheets, In the excel sheet i should browse the PDF file (which is attached in this mail ) and then the output data should be come in given format. Looking forward your co-operation Regards -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wann

Re: $$Excel-Macros$$ Help needed in creating a Dashbord

2013-10-16 Thread ashish koul
Hi try these links see if it helps http://chandoo.org/wp/2010/01/04/sales-dashboards/ http://chandoo.org/wp/2008/03/28/73-free-designer-quality-excel-chart-templates-grab-now-and-become-a-charting-superman/ http://chandoo.org/wp/2011/03/22/customer-service-dashboard/ http://www.excelhero.com/blog/

Re: $$Excel-Macros$$ Consolidate to one working sheet

2013-10-16 Thread Hari
Thanks for your help. It will be much helpful other than in VBA code. Thanks, Harish On 11 October 2013 17:51, Ravinder wrote: > PFA, if u r looking for this. > > ** ** > > *From:* excel-macros@googlegroups.com [mailto: > excel-macros@googlegroups.com] *On Behalf Of *Hari > *Sent:* Friday

Re: $$Excel-Macros$$ Custom buttons

2013-10-16 Thread Excel_Lover
See if the below link will help you. http://www.rondebruin.nl/win/s2/win008.htm On Tue, Oct 15, 2013 at 9:11 PM, dr wrote: > The last step is what I have a question with. I want to use an image I > designed, not ones that are in the window. Is there a way to use my own > image on a button? >