RE: $$Excel-Macros$$ No Data Validation when using Paste Values

hi Jon, This has always been a problem with data validation and paste. The only way around it, that I know of, is to use a 'Change' event macro. You ask VBA to examin any new data to see if it is suitable. If it isn't, get VBA to delete the entry, and post a message box politely informing the

RE: $$Excel-Macros$$ VBA Password Breaker required

Hi, Pls find the password breaker as below; Sub Button2_Click() ' Breaks worksheet and workbook structure passwords. ' probably originator of base code algorithm modified for coverage ' of workbook structure / windows passwords and for multiple passwords '

Re: $$Excel-Macros$$ max_units_on_a_day

Hi Anish, Subtotal would only find date wise max values for unit price and qty. and would show different results, than as desired in the query. Here are two examples from that data - 1st October - Highest units sold - 165 at the unit price of 1110 Answer Expected - 165 and 1110 Subtotaling would

Re: $$Excel-Macros$$ No Data Validation when using Paste Values

Dear Jon, One workaround could be to check the data which is being entered - in the light of it's format AND it's value. Validation may behave differently on formats / on values. For example, a Date entered as a Date or entered as a value. Best Regards, -- DILIP KUMAR PANDEY MBA-HR,B

Re: $$Excel-Macros$$ VBA Password Breaker required

Hi Sharat, Thanks for the code. I was able to run it to get the sheet unprotected. What should I do to break VBA password. If I run the button2_click only the sheet's passowrd is broken. But VBA is still passowrd protected. Can you please guide me. Thanks in Advance!! On Sat, Dec 19, 2009 at

Re: $$Excel-Macros$$ filtering large data files

Try using advanced filter with wild characters, if that suits ur needs. Thanks, DILipandey On 12/18/09, Hagar j...@hammondz.wanadoo.co.uk wrote: Hello to all you experts, i want to be able to filter a large amount of data to a single row that i can then use in other areas. data consists of

$$Excel-Macros$$ help on .pdf to excel

Hi All the Champs, I've a query, is there any way to convert a .pdf file into an excel format?? If there is any way, the please guide the way.. -- Best Regards Pooja Sharma -- -- Some important links for excel

$$Excel-Macros$$ Automatic compilation of 5 file in to one

Hi, Is it Possible to compile 5 files into one master file automatically, I have 5 files from 5 different branch offices and one master file ie:- 5 files from branch are A,B.C,D E, these file have branch name, pod dispatch date and pod number like this *BRANCH-A* ** **

Re: $$Excel-Macros$$ help on .pdf to excel

Hi Pooja, It is something related with text capturing from an image (PDF) file which is beyond the capabilities of Excel, so try searching free/paid softwares over Internet. Best Regards, -- DILIP KUMAR PANDEY MBA-HR,B COM(Hons.),BCA Mobile: +91 9810929744 dilipan...@gmail.com

Re: $$Excel-Macros$$ Macro to copy and clear range

Dear Anthony, I believe this macro should only run on the protected sheet, because it has the syntax:- ActiveSheet.Unprotect Give the consideration on this area and you might be able to solve your problem. Best Regards, -- DILIP KUMAR PANDEY MBA-HR,B COM(Hons.),BCA Mobile: +91 9810929744

Re: $$Excel-Macros$$ identifying duplicates

Dear Steve, It would be better if you can post the lists here so that we all can better understand your needs / present situation. Are Names there in a single column OR they are distributed as per First Name, Middle Name, Last Name, .etc ? Thanks Best Regards, -- DILIP KUMAR PANDEY

Re: $$Excel-Macros$$ help on .pdf to excel

can u please mail your file or also try free online pdf to excel converter websites first On Sun, Dec 20, 2009 at 11:31 AM, Dilip Pandey dilipan...@gmail.com wrote: Hi Pooja, It is something related with text capturing from an image (PDF) file which is beyond the capabilities of Excel,

Re: $$Excel-Macros$$ How to filter a spread sheet based on another sheet

Dear Sebastian, One test file would help the group members to help you out. :) 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/17/09, sebastianw...@gmail.com sebastianw...@gmail.com