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

2010-04-09 Thread Praveen kumar
dear all,,, need an urgent help frm u guys... There are 10 diff towns, and the invoice price for all the towns on various dates are as per the table attached.(date ranges across the towns) Now I need to check, whether the datewise, townwise invoice price generated is correct. the attached file

$$Excel-Macros$$ Re: Upload Excel data to Access, but Access not installed (file)

2010-04-09 Thread Chechu
Hi Paul, Ops, I’m sorry I posted the file as a different post; I didn’t know how to do it following the original! I definitely agree with you, a .vbs operated centrally after end user signs off on his data entry. Then if I understand, user will sign off by exporting part of the Tracking sheet to a

$$Excel-Macros$$ Re: Need help on the below xl file

2010-04-09 Thread paulwillekens
Hi Vinu, See the solution below... I created a sheet "test" to see the test result... In the macro you can (after testing) modify statement cTest = "test" to cTest = "Result Sheet" Good luck. Please feedback. Kind greetings Paul Willekens '==

$$Excel-Macros$$ Re: Upload Excel data to Access, but Access not installed (file)

2010-04-09 Thread paulwillekens
Hi Cecilia, After checking out your excell workbook, IMHO the best is to develop a .vbs that does both things: grab the specified data in the different excel files and insert them in the database. Still this problem: if the end user starts this .vbs, he must have access to the database; else i the

Re: $$Excel-Macros$$ Excel 2007 - Crashing when shared with more than 10 users

2010-04-09 Thread Vinod N
Hi Dear, Already 2003-2007 compatibility pack is installed... but still the problem is exists.. However, i will contact Microsoft Specialist as advised... Thanks a tonn for your advise.. Thanks VinodN On Fri, Apr 9, 2010 at 10:48 AM, rf1234 rf1234 wrote: > Hello Dear > This is excel 2007 Compa

Re: $$Excel-Macros$$ Request Help to make code more efficient.

2010-04-09 Thread JsinSk
Thanks you two, I integrated both suggestions into my vba and it processed instantly. Very helpful :) -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com

$$Excel-Macros$$ Re: Plz do the Needful Sir

2010-04-09 Thread Dilip Pandey
You are always welcome. -- 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 Fri, Apr 9, 2010 at 5:19 PM, Anil Saxena wrote: > Thanks Lot Dilip Sir > > > On Fri, Apr 9, 2010 at 5:07 PM, Dilip

$$Excel-Macros$$ Re: Plz do the Needful Sir

2010-04-09 Thread Dilip Pandey
Dear Anil, Attached file is solved per your requirements. Get back to me in case of any queries. -- 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 Fri, Apr 9, 2010 at 4:44 PM, Anil Saxena

$$Excel-Macros$$ Plz do the Needful Sir

2010-04-09 Thread Anil Saxena
Hi Dilip Ji Plz Do the Needful and show the Formula also Ram is 2 Regards, Anil Saxena -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/excelda

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

2010-04-09 Thread Aindril De
Vikas, Download and install the UBit menu http://www.ubit.ch/software/ubitmenu-languages/#c205 U can download the free for personal use...option Regards, andy On Fri, Apr 9, 2010 at 1:03 PM, vikas gupta wrote: > DEAR EXCEL GURUS > > I HAVE A PROBLEM IN EXCEL AND WORD 2007 > THERE IS NO MENU OP

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

2010-04-09 Thread rf1234 rf1234
Hello Dear, There amy be 2 reason. 1.u have try to update online,the pirated virson got the problem after updation online. 2.u have try any addins or macro who change the settings. On Fri, Apr 9, 2010 at 1:03 PM, vikas gupta wrote: > DEAR EXCEL GURUS > > I HAVE A PROBLEM IN EXCEL AND WORD

Re: $$Excel-Macros$$ Need Passward Cracker

2010-04-09 Thread rf1234 rf1234
Hello Dear, It is used when Important workbook is passowrd protected i.e Tools-->Protection-->Protect sheet And if user has forgot the password.. Hope it Will Help Happy to Help :) Prashant Tripathi On Fri, Apr 9, 2010 at 1:24 PM, L.K. Modi wrote: > may i know what is the use of t

Re: $$Excel-Macros$$ plz help me its urgent

2010-04-09 Thread anil panchal
On Fri, Apr 9, 2010 at 11:41 AM, Anil Saxena wrote: > Hi Sir, > plz help me and Show the Formula > > -- > > -- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twit

Re: $$Excel-Macros$$ Need Passward Cracker

2010-04-09 Thread L.K. Modi
may i know what is the use of this password cracker Actually me new to this group. Pls dont take otherwise this group is very good and i have learned many things from here that i thought can not be possible. Thanks for ur much good support thanks to all member of group Regards LKModi On Fri,

Re: $$Excel-Macros$$ plz help me its urgent

2010-04-09 Thread Chandra Gupta
Hello dear Please find the attached solution. Chandra Gupta Maurya On Fri, Apr 9, 2010 at 11:41 AM, Anil Saxena wrote: > Hi Sir, > plz help me and Show the Formula > > -- > > -- > Some important links for excel user

Re: $$Excel-Macros$$ plz help me its urgent

2010-04-09 Thread Swapnil Palande
Hi Anil, Please find attached excel for solution. Regards, Swapnil. On Fri, Apr 9, 2010 at 11:41 AM, Anil Saxena wrote: > Hi Sir, > plz help me and Show the Formula > > -- > > -- > Some important links for excel us

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

2010-04-09 Thread vikas gupta
DEAR EXCEL GURUS I HAVE A PROBLEM IN EXCEL AND WORD 2007 THERE IS NO MENU OPENED AND ALSO NOT WRITE IN THE FILE EVEN NEW FILE I HAVE PIRATED OFFICE PLEASE HELP ME REGARDS VIKAS -- -- Some important links for excel

$$Excel-Macros$$ plz Sir Do It Urgent

2010-04-09 Thread Anil Saxena
Plz Sir Do It and Show the formula also -- Forwarded message -- From: Anil Saxena Date: Fri, Apr 9, 2010 at 10:24 AM Subject: $$Excel-Macros$$ Fwd: plz Sir Do It Urgent To: Dilip Pandey Cc: excel-macros@googlegroups.com -- Forwarded message -- From: Anil Saxe

Re: $$Excel-Macros$$ MATCH question

2010-04-09 Thread Dilip Pandey
Hi Tom, Check the attached file and let me know if you face any challenge(s). -- 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 Fri, Apr 9, 2010 at 4:36 AM, tomfabtas...@hotmail.com < tomfa

Re: $$Excel-Macros$$ If condition issue

2010-04-09 Thread Dilip Pandey
Hi Raj Kumar Just solved this query for Anil, please check my reply and if not able to find the same do get back to me. -- 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 Fri, Apr 9, 2010 a

Re: $$Excel-Macros$$ If condition issue

2010-04-09 Thread rf1234 rf1234
Hello Dear You can use Multiple if Condition & Conditional Formatting. Please have a look on attached sheet... Hope it Will Help Happy To Help :) Prashant Tripathi On Fri, Apr 9, 2010 at 10:55 AM, Raj Kumar wrote: > Hi Dear, > > There is a problem in excel so kinly solve my querry > >

Re: $$Excel-Macros$$ Fwd: plz Sir Do It Urgent

2010-04-09 Thread rf1234 rf1234
Hello Dear You can use Multiple if Condition & Conditional Formatting. Please have a look on attached sheet... Hope it Will Help Happy To Help :) Prashant Tripathi On Fri, Apr 9, 2010 at 10:24 AM, Anil Saxena wrote: > > > -- Forwarded message -- > From: Anil Saxena > D

$$Excel-Macros$$ plz help me its urgent

2010-04-09 Thread Anil Saxena
Hi Sir, plz help me and Show the Formula -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our Facebook Group @ http://www.facebo

Re: $$Excel-Macros$$ Does anybody have games

2010-04-09 Thread Vikas Chouhan
Hi Open http://vikask008.hpage.com/ and click free games download link On Wed, Apr 7, 2010 at 12:37 AM, Nani Ram <06n...@gmail.com> wrote: > Hi All, > > Does anybody have games in excel sheet, if so please send me. > > > Thanks, > Naniram > > -- > > --

Re: $$Excel-Macros$$ Need Passward Cracker

2010-04-09 Thread Vikas Chouhan
Hiii, Dear Run this file On Thu, Apr 8, 2010 at 6:14 PM, Jai wrote: > > Dear All, > > Can you Give me VBA Passward Cracker, > -- > Thanks For Mail. > > -- > > -- > Some important links for excel users: > 1. Follow u

$$Excel-Macros$$ Fwd: plz Sir Do It Urgent

2010-04-09 Thread Anil Saxena
-- Forwarded message -- From: Anil Saxena Date: Fri, Apr 9, 2010 at 10:05 AM Subject: plz Sir Do It Urgent To: Dilip Pandey Plz Sir Do It and Show the formula also -- -- Some important links for ex