Re: Re: $$Excel-Macros$$ Datewise,townwise data??

2010-04-10 Thread Praveen kumar
hi shashank, thts wrong dude.. you just put vlookup... but the data has got townwise, datewise rateswhich differs reg Praveen On Sat, 10 Apr 2010 15:04:10 +0530 wrote HI Praveen Please find the Sorted data --- On Sat, 10/4/10, Praveen kumar wrote: From: Praveen kumar

$$Excel-Macros$$ how to query if a given sheet exists?

2010-04-10 Thread vsoler
Hello, how, in a module, can I possibly know if a given sheet, say Budget 2010 exists? thank you for your help -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links :

Re: $$Excel-Macros$$ how to query if a given sheet exists?

2010-04-10 Thread ashish koul
Sub a() Dim i As Integer Dim K As Boolean K = False For i = 1 To Worksheets.Count If Worksheets(i).Name = Budget 2011 Then MsgBox Sheet (i) IS Budget 2010 K = True Exit For End If Next i If K = False Then MsgBox Budget 2011 Sheet does not exits End If End Sub On Sat, Apr 10, 2010 at

Re: $$Excel-Macros$$ OFFICE ERR : SELECTION IS LOCKED

2010-04-10 Thread lal rahul
Hi All, Please help me in Learning Excel Macros, Pivot Table, ...is there any Ebooks you have got which you can mail me would be a help. Also i m working in Workforce Management wherein we need to forecast the call volume...please help me with it too Looking

Re: $$Excel-Macros$$ FILTER

2010-04-10 Thread vinod rao
Hi Vikas, How did you do this?. Regards Vin On Wed, Apr 7, 2010 at 7:00 PM, Vikas Chouhan vikask...@gmail.com wrote: Hi, Go format as table, On Wed, Apr 7, 2010 at 6:23 PM, Jai jaihumtu...@gmail.com wrote: Dear All Members. How can put the filter 2 times in One Excel file . --