Re: $$Excel-Macros$$ A Simple VBA Query

Hi Dave, Thank you so much for your interest. Let me tell you something about this - We are 3 friends living together and shares general expenses. I had decided to make a simple worksheet and record these transactions. Not every time all 3 are available to give their share and hence whoever pay

$$Excel-Macros$$ Re: Rota planning

Sheet did not attach - where do I do this please? John -- -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials

RE: $$Excel-Macros$$ A Simple VBA Query

Hi Abhishek, Attach your workbook, and lets see what you've got so far. Regards - Dave. Date: Mon, 14 Dec 2009 10:23:03 +0530 Subject: Re: $$Excel-Macros$$ A Simple VBA Query From: abhishek@gmail.com To: excel-macros@googlegroups.com Hi folks, Any update ? Regards, On Fri, Dec 11,

Re: $$Excel-Macros$$ VBA Code for Locking/Unlocking excel sheet using password input form

Hi Nandkumar, Well, I downloaded it (as a free user) - two rar files, extracted them, two more rar files, extracted them too - one exe file, VIRUS ALERT ! (glad to know my antivirus works!), exe gone, I deleted rest of the downloaded package. What is it anyway ? Some kind of lost password recover

$$Excel-Macros$$ Re: Need help to select the data columns into pivot table data field using VBA code.....

Hi Vallinayagam, Thanks a tonne for your help. It's working great. I would like to get more help on this. If data structure changes then I may need to edit the codes according to that. Instead of that input boxes have to get the input from me for column name to use for Row field (e.g. A to

Re: $$Excel-Macros$$ A Simple VBA Query

Hi folks, Any update ? Regards, On Fri, Dec 11, 2009 at 1:22 PM, Abhishek Jain wrote: > Hi all, > > Any help on this ? > > Regards...Abhishek > > > On Tue, Dec 8, 2009 at 8:31 PM, Abhishek Jain wrote: > >> Hi all, >> >> First of all I am very sorry to bother this group so much. >> >> I am tryin

$$Excel-Macros$$ Convert code into VBA Code

Hi Friends, how are you all doing. My last post regarding excel based translation from Google when unanswered. I am really hopeful that this time the champs in the group will not disappoint me. I want to convert the below code into a vba code. My requirement is to translate a string from excel int

$$Excel-Macros$$ Re: A question

http://office.microsoft.com/en-us/templates/CT101172771033.aspx Plenty to go at here to get you started, John On 12 Dec, 18:13, hemant shah wrote: > Hi Team > > Can you pls help me with my question. > Every thing is mentioned in the attached sheet. > > Pls help, > > Regards, > > Hemant Shah > >

$$Excel-Macros$$ Rota planning

Dear Group, I am looking to develop a duties rota writing spreeadsheet which creates a table based the rotataion of people but also taking notice of their ability to do either task. In the attached sheet I have listed and numbered all staff and set entry data for the size of the rota and the skil

Re: $$Excel-Macros$$ Freeze the cell once the Data has been entered?

hey this was good one 2009/12/13 Dilip Pandey > Dear Ramesh, > > Required automation is attached herewith. > > Thanks & Best Regards, > -- > DILIP KUMAR PANDEY >MBA-HR,B COM(Hons.),BCA > Mobile: +91 9810929744 > dilipan...@gmail.com > dilipan...@yahoo.com > New Delhi - 110062 > > > On

Re: $$Excel-Macros$$ VBA Code for Locking/Unlocking excel sheet using password input form

You have to be a premium member to dload that file. On Dec 11, 8:42 pm, Nandkumar kakvipure wrote: > Try Dis one > > http://rapidshare.com/files/106336650/LostPassword.Passware.Kit.Enter... > > On Fri, Dec 11, 2009 at 8:02 PM, Abhishek Jain wrote: > > > Punit, > > > What's the VBA password of you

Re: $$Excel-Macros$$ VBA Security - Restrict Users from Editing VBA Macros

Dear Dilip, I tried many software... but all asks for a full version i did not fin one which does not ask for a serial key... Please help Thanks Vinod... On Sun, Dec 13, 2009 at 7:14 PM, Dilip Pandey wrote: > Dear Vinod, > > There are many demo softwares/ tools available over internet whi

Re: $$Excel-Macros$$ Freeze the cell once the Data has been entered?

Dear Ramesh, Required automation is attached herewith. Thanks & Best Regards, -- DILIP KUMAR PANDEY MBA-HR,B COM(Hons.),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 110062 On 12/10/09, Chanti-Hyderabad wrote: > > Hi Excel Gurus, > > Looking for the follo

Re: $$Excel-Macros$$ VBA Security - Restrict Users from Editing VBA Macros

Dear Vinod, There are many demo softwares/ tools available over internet which well help you to remove VBA password. To get the full version, either you can purchase them or search for the unlock key(s) if you get the respective option in tool. Remeber some software do not ask for serial keys. :

Re: $$Excel-Macros$$ Alert for repeating cell information

Agree with Dave, conditional formatting is fast and better way as far as the conditions and resultant color are limited per consideration. Best Regards, -- DILIP KUMAR PANDEY MBA-HR,B COM(Hons.),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 110062 On 12/12

Re: $$Excel-Macros$$ data cleaning in excel

Ok, The solution is revised as per your needs. One thing the data scenario given by you has some conflict. Explained below:- 11/1/09 123456 -> duplicate 10/19/09123456 -> original 12/1/09 123456 -> duplicate Let me know if I am correct in unde

$$Excel-Macros$$ VBA code to trace formula

Hi, I need to verify calculation in sheet. So, I want to develop a VBA code can trace cells have formula and produce formula in its notation (where notation cell is the cell just on left side of the variable cell) Thanks, Sameh -- --

$$Excel-Macros$$ A question

Hi Team Can you pls help me with my question. Every thing is mentioned in the attached sheet. Pls help, Regards, Hemant Shah -- -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text),