Re: $$Excel-Macros$$ if statements with several matching values.

Dear Mike, Below is the formula for your requirement. =IF(AND(A2=abcdCust,LEN(B2)=6),0B2,IF(AND(A2=xyzzCust,LEN(B2)=8),LEFT(B2,4)-RIGHT(B2,4),)) Solved workbook is also attached. Best Regards, -- DILIP KUMAR PANDEY MBA-HR,B COM(Hons.),BCA Mobile: +91 9810929744 dilipan...@gmail.com

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

Hi Jon, After writing macro, protect it with password. Follow below steps:- Right click on VBA Project -Choose VBAProject Properties - Go to Protection tab - Mark the checkbox Lock Project for Viewing and enter the password below. Now create a button in spreadsheet and assign this macro to that

Re: $$Excel-Macros$$ how to code macro for use on multiple worksheets

Dear Pete, You can use following if you don't want to refer sheets:- Sub ABC Dim ws As Worksheet For Each ws In ActiveWorkbook.Sheets ' enter your code here Next End Sub Best Regards, -- DILIP KUMAR PANDEY MBA-HR,B COM(Hons.),BCA Mobile: +91 9810929744 dilipan...@gmail.com

Re: $$Excel-Macros$$ ||URGENT|| Need help is filtering/extracting names and counting values

Dear Abhishek, Another way could be Sub-total feature of Excel, but again for that you have to play with source data - (sorting, arranging etc.) I believe Pivot Table is best for this query. Try and learn pivots as it is a very powerful feature of MS Excel.and this will benefit you in future as

Re: $$Excel-Macros$$ Where to Learn Excel

You are Welcome Abdul, If you want video tutorials, then you should check up the books from big publishing houses as they provides Learning CDs alongwith their books, alternatively you should consult some leading book shops / video libraries etc. Best Regards, -- DILIP KUMAR PANDEY MBA-HR,B

Re: $$Excel-Macros$$ Declare weekends

Dear Nikhil, Please provide the test file alongwith the results / scenario(s) you are expecting. Thanks, -- DILIP KUMAR PANDEY MBA-HR,B COM(Hons.),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 110062 On 12/6/09, nikhil deshpande deshpande...@gmail.com

Re: $$Excel-Macros$$ Time Tracker

Yes Paul, what you mentioned is correct I have to pull that information Thanks Sumesh On Wed, Dec 2, 2009 at 11:18 AM, SumesH P S sumesh.subbay...@gmail.comwrote: Hi All, Could you please help me to write a macro for saving the date and time in a spread sheet when the user lock the system,

$$Excel-Macros$$ Find if cell contain partiular word or number

Dear All i want to find particular word or number in column A,B C eg.ABC,XYZ,123 i want to write macro If column A B C contain ABC,XYZ,123 any one in three of this.then status of D column should be found if not then not found How can i use If InStr or any other function Column A Column B

Re: $$Excel-Macros$$ Where to Learn Excel

Dear Abdul, visit http://spreadsheetpage.com/ by john walkenbach It will help you. I'm sure. Etore -- -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at

$$Excel-Macros$$ Copy Paste values in adjacent cell

*Copy Paste values in adjacent cell* i had data in html format.i want the data to be splitted into columns in excel. *HTML FORMAT* Employee name Emp id johnabraham wesleypeter neiljohn 254800254801 254802 254803 and so on. i tried copying the data from

$$Excel-Macros$$ How to save contents of cell range in an array?

In a VBA subroutine, how can one, for example, save the contents (numbers) of the range A1:L12 in the array x(12,12)? And how does one declare x(12,12)? Thanks in advance. John Uebersax -- -- Some important links

Re: $$Excel-Macros$$ ||URGENT|| Need help is filtering/extracting names and counting values

Hi Dilip ji, Is there any solution for this - other than pivots ? Trust you can figure out something. Krgrds, AJ On Sat, Dec 5, 2009 at 7:24 PM, Dilip Pandey dilipan...@gmail.com wrote: Dear Abhishek, In order to learn Pivot Tables, you can try below link:-

Re: $$Excel-Macros$$ Stumped with count if's

yes it does thanks for the help On Dec 5, 11:02 am, Dilip Pandey dilipan...@gmail.com wrote: Dear Zilla, Attached file would be help you to get the logics of IFs. Let me know if it solves your query. Best Regards, -- DILIP KUMAR PANDEY    MBA-HR,B COM(Hons.),BCA Mobile: +91 9810929744

$$Excel-Macros$$ combobox to show 01 instead of 1

Hi, I have a combobox that is populated from a named range on a sheet (days from1 to 31) I changed them to text to show as (01 to 31) but my combo box still shows 1 instead of 01. Can this be fixed? Thanks. Nasim --

$$Excel-Macros$$ Mimik tab on last control (last name text box)

Hi, My userform has a multipage with several pages and lots of controls. Oon one of the pages there is a text box for last name and after user finishes typing in it clicks streight on the save button (does not tab). I have a cell that is changing the text (that is passed to it from the last name

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

Thanks. On Dec 6, 9:29 am, Dilip Pandey dilipan...@gmail.com wrote: Hi Jon, After writing macro, protect it with password. Follow below steps:- Right click on VBA Project -Choose VBAProject Properties - Go to Protection tab - Mark the checkbox Lock Project for Viewing and enter the password

$$Excel-Macros$$ HELP!! My code is pausing after I press a button

I am trying to automatically delete items from an in house intranet website. I have the code that works upto the point of delete button pressing, and I have the code that works to press the next confirmation button. Each portion has been tested and works fine. The problem is that the code STOPS,

Re: $$Excel-Macros$$ Re: Need marco to take the print out of Web Page

Hi Bruce, Thanks for the help. But i need something diff. Attached is the xls with the links. Now i want a Marco that copy the links from the cell and paste it on the address bar in Internet Explorer (not in Google), open that page and give the print out, close it and move to next line.