$$Excel-Macros$$ VBA Password Breaker required

Hi, Can anyone send me the VBA password breaker. Thanks in Advance!! -- -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Exc

Re: $$Excel-Macros$$ Sorting Data

Hi Paul, thanks for helping me. Below is the configuration of my data. The only area that is to be alphabetized is the array of letters in the example below, A7 and below remain unchanged. As new data is entered it is place in row 1 and all existing data is shifted down including the data below th

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

I have a spreadsheet with multiple data validations that I want users to paste values to. Unfortunately, I've noted that the data validation rules don't apply when you paste values. Do anyone know a work around? Thanks. -- ---

$$Excel-Macros$$ RE: Charts on Maps

Hi, I'm trying to determine how to have data populate a may of a country. For example, I have seen many such charts displaying different degrees of color intensity for demographic data in the US. I have seen similar such charts for other countries as well. See http://waterwatch.usgs.gov/ for an e

$$Excel-Macros$$ filtering large data files

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 about 85 columns and 15000 rows of data, much of which is very similar. 1st filter would have about 15 unique names, each of which then limits the rows

Re: $$Excel-Macros$$ max_units_on_a_day

Dear Praveen, Please see the attached file. Hope this helps you. Kind regards, Abhishek Jain On Fri, Dec 18, 2009 at 3:20 PM, Praveen kumar wrote: > dear all > > > need a help.. > > > A similar product in sold to different customers on the same day at > different prices. > I need to select

Re: $$Excel-Macros$$ Concatenating after checking cells

Hi, Why u use macro for this, u just choose formulla e.g =Max(A1:A6) result 29-Nov-08 i m just giving result according to your data give by you in enclosed sheet. Regards, Guru On Thu, Dec 17, 2009 at 6:55 PM, rf1234 rf1234 wrote: > *Date at sheet1* > *Date at sheet2* > *Date at shee

Re: $$Excel-Macros$$ max_units_on_a_day

Hi, You can simply use SUBTOTAL function, which you can find under DATA submenu. Attached please find the solution. Cheers!! ANISH On Fri, Dec 18, 2009 at 3:20 PM, Praveen kumar wrote: > dear all > > > need a help.. > > > A similar product in sold to different customers on the same day at

$$Excel-Macros$$ max_units_on_a_day

dear all need a help.. A similar product in sold to different customers on the same day at different prices. I need to select the Unit Price at which the product has sold Maximum units on any particular day. and if there is a tie in the maximum units sold, then the higher of the rate per

RE: $$Excel-Macros$$ Concatenate after checking all cell

-Original Message- From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] On Behalf Of shyam Sent: Thursday, December 17, 2009 7:02 PM To: MS EXCEL AND VBA MACROS Subject: $$Excel-Macros$$ Concatenate after checking all cell Date at sheet1 Date at sheet2 Date at s

Re: $$Excel-Macros$$ Concatenate after checking all cell

TEXT(IF(ISTEXT(B41)=FALSE,B41,IF(ISTEXT(C41)=FALSE,C41,IF(ISTEXT(D41)=FALSE,DC41,IF(ISTEXT(E41)=FALSE,E41,IF(ISTEXT(F41)=FALSE,F41,IF(ISTEXT(G41)=FALSE,G41,"")),"DD-MMM-") try this see whether it works for you o On Fri, Dec 18, 2009 at 10:51 AM, rf1234 rf1234 wrote: > Dear paul Thanks

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

Thanks Dave. My apologies for late reply. I would shortly send you a workbook mentioning my requirement. Thanks again. AJ On Wed, Dec 16, 2009 at 4:12 PM, Dave Bonallack wrote: > This time. > Dave > > -- > Date: Tue, 15 Dec 2009 15:46:56 +0530 > > Subject: Re: $$Ex