$$Excel-Macros$$ Re: Formula Needed Please

2015-03-12 Thread Maciej Piotrowicz
Hello Use in O6 cell formula = COUNTIF($D$5:$I$32;O5) and copy to right. Regards W dniu piątek, 13 marca 2015 07:28:20 UTC+1 użytkownik Will Sob napisał: > > > Hi, > Please I need help with the attached file. I want a that calculates how > many times 10, 13, 17 has appeared within the range D5

$$Excel-Macros$$ Formula Needed Please

2015-03-12 Thread Will Sob
Hi, Please I need help with the attached file. I want a that calculates how many times 10, 13, 17 has appeared within the range D5:I32 Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.faceboo

Re: $$Excel-Macros$$ Formula based on some criteria

2015-03-12 Thread rameshwari shyam
Dear gaurav, required some more modification. if you can check AED in question sheet is 15 then in Master sheet, search for 15 SAR. Below than that there is a AED 15, KWD 15, SAR 1.5 OMR 1.5 BHD 15 QAR 1.25, Base currency will be AED in question sheet and in master sheet base currency will be SAR

Re: $$Excel-Macros$$ multiple files to single file

2015-03-12 Thread Prabhu Pinky
what is the password to view the macro code. Thanks & Regards, Prabhu R On 12 March 2015 at 11:43, Mahesh Patil wrote: > Hi, > Collect all excel files under one folder. Use attached file to merge all > excel files. > Regards, > Mahesh Patil > On Mar 11, 2015 6:32 PM, wrote: > >> Sir, >> >> i

$$Excel-Macros$$ Re: vba recorded macro not working

2015-03-12 Thread Mike B
Hi Mandeep, I would appreciate you looking at the attached worksheet, I have written and explanation in a comment on the worksheet explaining the issues I am experiencing, I thought it would be easier for you to understand. On Sunday, March 8, 2015 at 12:08:13 PM UTC-5, Mike B wrote: > Thank yo

$$Excel-Macros$$ Re: Sum value of closing balance of date

2015-03-12 Thread Michael Vinoth
Hi Ashish, Please find the attached macro file. Regards, MV On Thursday, March 12, 2015 at 3:34:33 PM UTC+5:30, Ashish_Bhalara wrote: > Dear experts, > > I need function to sum only closing value of particular date, pls see > attached file for example. > > Regards. > Ashish Bhalara > 96241118

$$Excel-Macros$$ Hiring-Java Developer@Cupertino,CA [Please send resumes to r...@technotalent.com]

2015-03-12 Thread Rene Mickey
Hi, Hope you are doing great... Please let me know your interest along with your updated resume (If you are not available please refer this Position) *[Please send resumes to r...@technotalent.com ]* *Position* *Role : Java Developer* *Location : **Cupertino,CA* *Duration

Re: $$Excel-Macros$$ Formula based on some criteria

2015-03-12 Thread Gaurav Devrani
Hi Rameshwari , Please check the file. Let me know if it does not work for you. Regards Gaurav Devrani On Thu, Mar 12, 2015 at 5:47 PM, Rameshwari wrote: > Hello team, > > I stuck with one formula, please help me on this. Formula based on some > criteria. > > > > Sheet “Question” having curre

$$Excel-Macros$$ Formula based on some criteria

2015-03-12 Thread Rameshwari
Hello team, I stuck with one formula, please help me on this. Formula based on some criteria. Sheet “Question” having currency name with the prices, based on currency name & prices need to update the value in answer filed. Master sheet will be a reference for the currency. Every 13 row

$$Excel-Macros$$ Re: Sum value of closing balance of date

2015-03-12 Thread Maciej Piotrowicz
Hi I do not know how to do this with using only one formula. I added column. My method attached. Waiting for somebody who use one formula. Maybe any array formula? Regards W dniu czwartek, 12 marca 2015 11:04:33 UTC+1 użytkownik Ashish_Bhalara napisał: > > Dear experts, > > I need function to

$$Excel-Macros$$ Sum value of closing balance of date

2015-03-12 Thread Ashish Bhalara
Dear experts, I need function to sum only closing value of particular date, pls see attached file for example. Regards. Ashish Bhalara 9624111822 P*Please do not print this email unless it is absolutely necessary. Spread environmental üawareness.♣♣♣* -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in

Re: $$Excel-Macros$$ Query for autofit columns.

2015-03-12 Thread Gaurav Devrani
Okay. .I got it. On Thu, Mar 12, 2015 at 2:41 PM, Mandeep baluja wrote: > Not working Range("C8").CurrentRegion.Columns.AutoFit this line will > unhide the hide columns in between the range. i have tried visible columns > property but its not working. > > On Thursday, 12 March 2015 14:37:51 U

Re: $$Excel-Macros$$ Please help me Urgent

2015-03-12 Thread Gaurav Devrani
Dat's Cool Vaibhav. Thanks. On Wed, Mar 11, 2015 at 11:32 PM, Michael Vinoth wrote: > > Very Nice... Mr.Vabz > > On Wednesday, March 11, 2015 at 6:33:10 PM UTC+5:30, Vabz wrote: > >> Suppose you have value in cell A1 then type follo. formula in A2 & dont >> press enter & press F9, you will get r

$$Excel-Macros$$ Re: Query for autofit columns.

2015-03-12 Thread Mandeep baluja
got to know autofit not works for merge cells was doing the issue tried this code it works. Sub Hidealternatecolumns() Dim first As Double Dim last As Double first = 4 last = 65 For i = first To last If Cells(1, i).Column Mod 2 = 0 Then Cells(1, i).EntireColumn.Hidden = True

Re: $$Excel-Macros$$ Query for autofit columns.

2015-03-12 Thread Mandeep baluja
Not working Range("C8").CurrentRegion.Columns.AutoFit this line will unhide the hide columns in between the range. i have tried visible columns property but its not working. On Thursday, 12 March 2015 14:37:51 UTC+5:30, Gaurav Devrani wrote: > > Hi Mandeep, > > Please check the attached file.

Re: $$Excel-Macros$$ Query for autofit columns.

2015-03-12 Thread Gaurav Devrani
Hi Mandeep, Please check the attached file. let me know if I am missing something. Regards Gaurav Devrani On Thu, Mar 12, 2015 at 1:43 PM, Mandeep baluja wrote: > Quuery for autofit > > -- > Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s > =TIME(2,DO:IT,N:OW) ! Jo

$$Excel-Macros$$ multiple files to single file

2015-03-12 Thread myxlguru
Sir, i need a macro to import multiple file to single file i got some files in a week later i copy those to 1 file some time not copy (some in 2003 format,some 2007,some .csv,.xlsm etc) some times files contains more than 1 sheet need help copy all those files which i save in Latest Data(this is

$$Excel-Macros$$ Query for autofit columns.

2015-03-12 Thread Mandeep baluja
Quuery for autofit -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Ur

Re: $$Excel-Macros$$ multiple files to single file

2015-03-12 Thread my excel
Sir, Very Nice Thank You very much On Thu, Mar 12, 2015 at 11:43 AM, Mahesh Patil wrote: > Hi, > Collect all excel files under one folder. Use attached file to merge all > excel files. > Regards, > Mahesh Patil > On Mar 11, 2015 6:32 PM, wrote: > >> Sir, >> >> i need a macro to import multiple