Re: $$Excel-Macros$$ When do my subscribers pay plan

Hi Sorry :) Here it is. The sheet "from csv" is data copied from the csv file. The sheet "Output idea" is how I want the data to be sorted. The bold numbers is the next delivery month. (I did manage to get thatone by a IF statement) But i need to get the rest of the months to be filled by how

Re: $$Excel-Macros$$ Make database with user form i have made

Dear all, I am new to Excel VBA, esp for treating it database. Could hemal explain how to use it? Also, I cannot open the file from Noorain, my excel version is 2003. Thanks a lot! Darwin 2011/9/23 NOORAIN ANSARI > Dear Hemal, > > Please try below code, sheet is attached for ur help. > > Priv

Re: $$Excel-Macros$$ Urgent------Fill in 1 column

To me, all non customer requests are treated the same and I even sometimes ignore those who say it is “URGENT” From: Brajesh Kumar Porwal Sent: Friday, September 23, 2011 5:31 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Urgent--Fill in 1 column Hi Expert, Find attached

Re: $$Excel-Macros$$ columns data need to be in reverse order

Try in a macro enabled workbook (.xls or .xlsm) Sub CustomSortSAS() 'converts to values Rows(3).Clear x = Application.Match(Application.Min(Rows(2)), Rows(2)) y = Application.Match(Application.Max(Rows(2)), Rows(2)) Cells(3, y - x + 2).Resize(, x - 1).Value = _ Cells(2, 1).Resize(, x - 1).Value

Re: $$Excel-Macros$$ Message on Cell

Hi Ankit, Go through the below links to have a better understanding about Validation in Excel. http://www.contextures.com/xlDataVal06.html http://www.contextures.com/xlDataVal04.html http://www.contextures.com/xlDataVal07.html Hope that helps! --- Ms.Exl.Learner

Re: $$Excel-Macros$$ Find the month of sales cross the target

How about a nice macro to populate col K and color the month within the row. Option Explicit Sub crossmonthSAS() Dim i As Long Dim j As Double Dim ms As Long For i = 2 To Cells(Rows.Count, 1).End(xlUp).Row ms = 0 For j = 2 To 8 ms = ms + Cells(i, j) If ms < 100 Then Cells(i, "k") = "Not Qualified

Re: $$Excel-Macros$$ Issue with Selection as collection

Dear markkim, you forgot to write rcell after next Sub selection_area() Dim rcell As Range For Each rcell In Selection rcell.Value = 1 Next rcell End Sub Thanks and Regards Akhilesh Airen -- -- Some important links

Re: $$Excel-Macros$$ Digest for excel-macros@googlegroups.com - 12 Messages in 6 Topics

Dear CK, try it... *for dd/mm/yy format* *Function dd_mm_yy(s As Range) dd_mm_yy = VBA.Format(s, "dd/mm/yy") End Function * *for dd mm yy format Function with_Space(s As Range) with_Space = VBA.Format(s, "dd" & " " & "mm" & " " & "yy") End Function * -- Thanks & regards, Noorain Ansari *http:/

Re: $$Excel-Macros$$ When do my subscribers pay plan

Dear you can share shample sheet with example On Fri, Sep 23, 2011 at 3:29 AM, Urghhh wrote: > Hi > > From my accounting system (http://www.e-conomic.com/) I get a csv file > containing all my subscribers. > > They are listed like this: > > Subscribe plan (12x a year, 6x, 4x, 2x, 1x) > Start dat

Re: $$Excel-Macros$$ Digest for excel-macros@googlegroups.com - 12 Messages in 6 Topics

Hi Macros, How could we fix the date format to "DD/MM/YY". So, If we enter other format it should convert to "DD/MM/YY" Ex: I want like DD MM YY only 24/11/1985 --- This is correct format 11/24/1985 this should convert into 24/11/1985 automatical how it is possible...

Re: $$Excel-Macros$$ Find the month of sales cross the target

Hi Deepak, Copy and paste the below formula in Second Row after Column H. =IF(B2>100,B$1,IF(SUM(B2:C2)>100,C$1,IF(SUM(B2:D2)>100,D$1,IF(SUM(B2:E2)>100,E$1,IF(SUM(B2:F2)>100,F$1,IF(SUM(B2:G2)>100,G$1,IF(SUM(B2:H2)>100,H$1,"Not Qualified"))) I have attached an example file for your better unde

Re: $$Excel-Macros$$ Message on Cell

Dear Ankit, Please see attached sheet with solution. -- Thanks & regards, Noorain Ansari *http://excelmacroworld.blogspot.com/* *http://noorain-ansari.blogspot.com/* On Fri, Sep 23, 2011 at 10:42 AM, Ankit Agrawal wrote

Re: $$Excel-Macros$$ Find the month of sales cross the target

Dear deepak here is the sample formula =If(sum(b2:b2)>=100,"Qualified","Not Qualified") -- *Great day,* *viper* On Fri, Sep 23, 2011 at 3:04 PM, Deepak Rawat wrote: > Hil All > > I have attached the file of data. > > My problem is i have to find the qualifying month of sales by a formula

Re: $$Excel-Macros$$ Message on Cell

Dear Sir, This is not working & plz tell me how we can do it another files. Regards, Ankit On Fri, Sep 23, 2011 at 3:55 PM, §»VIPER«§ wrote: > of course > > pfa > > > -- > *Great day,* > *viper > > * > On Fri, Sep 23, 2011 at 10:42 AM, Ankit Agrawal < > ankit.agrawal...@gmail.com> wrote:

Re: $$Excel-Macros$$ Message on Cell

Dear Sir, It is not working.and plz tell how we can apply it on other sheet too. Regards, Ankit On Fri, Sep 23, 2011 at 3:55 PM, §»VIPER«§ wrote: > of course > > pfa > > > -- > *Great day,* > *viper > > * > On Fri, Sep 23, 2011 at 10:42 AM, Ankit Agrawal < > ankit.agrawal...@gmail.com> wr

Re: $$Excel-Macros$$ Message on Cell

of course pfa -- *Great day,* *viper * On Fri, Sep 23, 2011 at 10:42 AM, Ankit Agrawal wrote: > Dear All, > > I want to show a messge when we enter value which is more than 50k.As we > type 6 at that time a message show approval need. > > Could it possible? > > Regards, > Ankit > > --

$$Excel-Macros$$ Find the month of sales cross the target

Hil All I have attached the file of data. My problem is i have to find the qualifying month of sales by a formula. if it does not qualify then it should reflect as "Not Qualify" Pls Help!! Regards, Deepak -- -- So

$$Excel-Macros$$ columns data need to be in reverse order

Dear all, Any body help in this matter,please have luk of the attachement, I have lot of columns data,Now I want all the data with formula in reverse manner -- Thanks & Regards Shivashankar.C.Katageri 9945800300 --

$$Excel-Macros$$ Message on Cell

Dear All, I want to show a messge when we enter value which is more than 50k.As we type 6 at that time a message show approval need. Could it possible? Regards, Ankit -- -- Some important links for excel users:

$$Excel-Macros$$ Connect user form with excel cell

I have made user form for basic salary. i just want to connect to excel cell... In short , i want to make database through that form. .. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tr

$$Excel-Macros$$ When do my subscribers pay plan

Hi >From my accounting system (http://www.e-conomic.com/) I get a csv file containing all my subscribers. They are listed like this: Subscribe plan (12x a year, 6x, 4x, 2x, 1x) Start date for next period Amount to pay Here is a couple of examples Every x month, next period start date, Amount 12

Re: $$Excel-Macros$$ Increasing rows in Excel 2010

Its based on your operating system. download the first one and read the content. It will guide -- *Great day,* *viper* On Fri, Sep 23, 2011 at 11:55 AM, Chandra Shekar < chandrashekarb@gmail.com> wrote: > Hello Noorain, > > Could u pls let me know which one to download in the attached