Re: $$Excel-Macros$$ Help required on formula

Please help Regards On 3/29/14, Jocky Beta wrote: > Hi pramod, > > Please find the attached sheet in which i had explain what i required, > Request you to kindly go through it and help me to solve the problem. > > Regards > > > On Sat, Mar 29, 2014 at 10:13 AM, Pramod Singh wrote: > >> hey what

Re: $$Excel-Macros$$ Help required on formula

Hi pramod, Please find the attached sheet in which i had explain what i required, Request you to kindly go through it and help me to solve the problem. Regards On Sat, Mar 29, 2014 at 10:13 AM, Pramod Singh wrote: > hey what u want can u enplane complete... > > > On Sat, Mar 29, 2014 at 8:08

Re: $$Excel-Macros$$ Help required on formula

hey what u want can u enplane complete... On Sat, Mar 29, 2014 at 8:08 AM, Jocky Beta wrote: > Hi, > I have already assigned formula but its showing error. > > Please help me. > > Regards > > > On Fri, Mar 28, 2014 at 1:51 PM, Jocky Beta wrote: > >> Hi, >> >> Please help me on this _ >> >> >>

Re: $$Excel-Macros$$ Help required on formula

Hi, I have already assigned formula but its showing error. Please help me. Regards On Fri, Mar 28, 2014 at 1:51 PM, Jocky Beta wrote: > Hi, > > Please help me on this _ > > > Regards > > > On Fiday, March 28, 2014, Jocky Beta wrote: > > Hi All, > > > > Pls fin above attached sheet in which Q

Re: $$Excel-Macros$$ Help required on formula

Hi, Please help me on this _ Regards On Fiday, March 28, 2014, Jocky Beta wrote: > Hi All, > > Pls fin above attached sheet in which Query sheet when i type any word related to Item code ELEC0001 (Kindly see the master sheet) it will search the Item Name automatically. But when i put bulb it's

Re: $$Excel-Macros$$ help required urgently

1. change date format in d/mm/ 2. change text to column 3.now use date function to combined date again Divaker On Thu, Mar 27, 2014 at 4:04 PM, Neeraj Chauhan wrote: > Dear experts, > > > > We have givne below date format how to convert right format of date like > 13-Jan-2014 > > > > TT Mo

RE: $$Excel-Macros$$ Help!!(Dashboard)

Dear Ashish, Thanks a ton Regards, Soumyendu From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of ashish koul Sent: Saturday, March 15, 2014 3:29 PM To: excel-macros Subject: Re: $$Excel-Macros$$ Help!!(Dashboard) check chandoo.org http

Re: $$Excel-Macros$$ Help!!(Dashboard)

check chandoo.org http://office.microsoft.com/en-in/templates/dashboard-TC101915534.aspx http://www.skilledup.com/learn/business-entrepreneurship/best-free-excel-templates-dashboards/ On Thu, Mar 13, 2014 at 11:50 AM, Soum wrote: > Dear Ashish, > > > >Could you help me out abo

RE: $$Excel-Macros$$ Help me for interview : Excel Formulas and Macros

IN WHICH COMPANY... From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of KATHIRVELAN N Sent: Saturday, March 08, 2014 6:41 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Help me for interview : Excel Formulas and Macros Dear Friends, I

Re: $$Excel-Macros$$ Help on sumif function

Dear Dileep and Ravindra Very very Thanks for solution Regards Shrinivas On Thu, Feb 13, 2014 at 10:44 AM, Ravinder wrote: > =SUMIFS(B2:B22,A2:A22,">="&D6,A2:A22,"<="&E6) > > > > OR > > PFA > > > > *From:* excel-macros@googlegroups.com [mailto: > excel-macros@googlegroups.com] *On Behalf Of *Sh

RE: $$Excel-Macros$$ Help on sumif function

=SUMIFS(B2:B22,A2:A22,">="&D6,A2:A22,"<="&E6) OR PFA From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Shrinivas Shevde Sent: Thursday, February 13, 2014 9:28 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Help on sumif function

Re: $$Excel-Macros$$ Help on sumif function

Dear Shrinivas, Use sumifs for summing ranges based on more than one criteria, sumifs will handile number of criterias for summing ranges. Same like countifs also. If your are summing ranges which are located in othere workbooks better to use sumproduct rather usning sumifs, coz sumifs will not w

Re: $$Excel-Macros$$ Help Needed

Dear, use this. =num2text(reference) Please check attachment. thanking you On 4 February 2014 09:42, Harish P Y wrote: > It is not working Sir > > > With Regards > > *HARISH P Y* > > *P* *THINK BEFORE YOU PRINT:**Before printing this e-mail think whether > it is really necessary. Thanks for yo

Re: $$Excel-Macros$$ Help Needed

It is not working Sir With Regards *HARISH P Y* *P* *THINK BEFORE YOU PRINT:**Before printing this e-mail think whether it is really necessary. Thanks for your support to protect our environment for the future generation* *1 ream of paper = 6% of a tree and 5.4 kg CO2 in the atmosphere 3 shee

Re: $$Excel-Macros$$ Help Needed

Dear Harish, Please find attachment of addin. Please use & reply. Thanking you (it was received by me in 2009 through this group) On 30 January 2014 14:39, Harish P Y wrote: > Dear Excel Gurus, > > Please find the attached file Marks Sheet, > and i want to obtain the marks obtained in words a

Re: $$Excel-Macros$$ Help Needed

This is very useful. > http://excelribbon.tips.net/T008351_Converting_Numbers_Into_Words.html > Thanks for this Link. -- 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 f

Re: $$Excel-Macros$$ Help Needed

http://excelribbon.tips.net/T008351_Converting_Numbers_Into_Words.html http://support.microsoft.com/kb/213360 http://www.yogeshguptaonline.com/2009/07/excel-functions-convert-numbers-into.html check above links On Thu, Jan 30, 2014 at 2:39 PM, Harish P Y wrote: > Dear Excel Gurus, > > Please f

Re: $$Excel-Macros$$ Help Required

Thanks Ravinder. On Fri, Jan 24, 2014 at 4:37 PM, Ravinder wrote: > PFA > > > > *From:* excel-macros@googlegroups.com [mailto: > excel-macros@googlegroups.com] *On Behalf Of *Rakesh kumar > *Sent:* Friday, January 24, 2014 4:26 PM > *To:* excel-macros@googlegroups.com > *Subject:* $$Excel-Macros

RE: $$Excel-Macros$$ Help Required

PFA From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Rakesh kumar Sent: Friday, January 24, 2014 4:26 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Help Required Hi Friends, Please find the attachment. Help Please -- Th

RE: $$Excel-Macros$$ Help required for PDF Stamp

Your query is not clear. Please explain more you need to edit any pdf or only create stamp like approved, rejected or else as pdf From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Rajeev Sent: Wednesday, January 22, 2014 12:03 PM To: excel-macros@googlegro

Re: $$Excel-Macros$$ help!!! creation code from data in cells

Hi, will you please provide the row data for the same query... thanks On Thu, Jan 2, 2014 at 11:07 PM, abhinav bansal wrote: > > > hi all i want to creat formula as defined below- > - > formula needed for creating Studen

RE: $$Excel-Macros$$ Help with formula in vba

x27;C:\Users\User\Desktop\Reports\[Reason Codes.xlsx]Rail'!$A$1:$B$62,2,FALSE))" Thanks and Regards, Gargee Singh From: garge...@hotmail.com To: excel-macros@googlegroups.com CC: quote.ex...@gmail.com Subject: RE: $$Excel-Macros$$ Help with formula in vba Date: Sat, 7 Dec 2013 15

RE: $$Excel-Macros$$ Help with formula in vba

Hi Ravinder, thanks a lot, yes this is very helpful. exactly what i needed . :) Thanks and Regards, Gargee Singh From: ravinderexcelgr...@gmail.com To: excel-macros@googlegroups.com CC: quote.ex...@gmail.com Subject: RE: $$Excel-Macros$$ Help with formula in vba Date: Sat, 7 Dec 2013 12

Re: $$Excel-Macros$$ Help needed

Ravinder, PFA, Regards, Cartik On Tue, Nov 12, 2013 at 10:50 AM, Ravinder Kumar < ravinderbhardwa...@gmail.com> wrote: > Hi > > Please help me, to create a formula with small function and Vlook up > function. > > > Regards > Ravindra > > -- > Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And

Re: $$Excel-Macros$$ Help to extract text file into excel in respective coloumn

Sub delimit_txt_file() Dim wkb As Workbook Dim fNameAndPath As String fNameAndPath = Application.GetOpenFilename(FileFilter:="Text Files (*.txt), *.txt", Title:="Select File To Be Opened") Workbooks.OpenText Filename:=fNameAndPath, Origin:=xlWindows, _ StartRow:=1, DataType:=xlDelimited, TextQual

Re: $$Excel-Macros$$ help required on attached Macro

Hi, I don't have password for this file is there any alternative way to complete same. On Thu, Oct 17, 2013 at 2:03 PM, Anil Gawli wrote: > Dear Jocky, > > Kindly unlock the password and resend. > > Warm Regards, > Gawli Anil > Thanks & Regards, > Gawli Anil Narayan > Software Developer, >

Re: $$Excel-Macros$$ help required on attached Macro

Dear Jocky, Kindly unlock the password and resend. Warm Regards, Gawli Anil Thanks & Regards, Gawli Anil Narayan Software Developer, Abacus Software Services Pvt Ltd On Thu, Oct 17, 2013 at 1:59 PM, Jocky Beta wrote: > Hi Team, > > Can anybody fix this attached error for me. i am also attachi

Re: $$Excel-Macros$$ Help needed in creating a Dashbord

Hi I have attached some dummy data. Please suggest how can I calculate on year basis or division basis like if I change the division to calculate the head count/CTC then data should change automatically. In HR Dashboard I can show the status of recruitment done/ Exits/Head Count in a particular

Re: $$Excel-Macros$$ Help needed in creating a Dashbord

Hi try these links see if it helps http://chandoo.org/wp/2010/01/04/sales-dashboards/ http://chandoo.org/wp/2008/03/28/73-free-designer-quality-excel-chart-templates-grab-now-and-become-a-charting-superman/ http://chandoo.org/wp/2011/03/22/customer-service-dashboard/ http://www.excelhero.com/blog/

RE: $$Excel-Macros$$ Help needed in creating a Dashbord

Give some data...in which you want to work even dummy data. From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of alisha malhotra Sent: Tuesday, October 15, 2013 11:21 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Help needed in creating a Dash

RE: $$Excel-Macros$$ Help required in a small formula.....

E2=1-((1/5)^2+(1/5)^2+(1/5)^2+(1/5)^2+(1/5)^2+(1/5)^2) E4=1-((1/5)^2+(1/5)^2+(1/5)^2+(1/5)^2+(1/5)^2) From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Indrajit $nai Sent: Saturday, October 12, 2013 2:23 AM To: excel-macros@googlegroups.com Subject: $$Excel-M

Re: $$Excel-Macros$$ Help required in a small formula.....

This formula have 6 part *=1-(**(B3/D2)^2**+**(B4/D2)^2**+**(B5/D2)^2**+**(B5/D2)^2**+**(B6/D2)^2**+**(B7/D2)^2**)* And this Only 5 Part, Purple part was missing *=1-(**(1/5)^2**+**(1/5)^2**+**(1/5)^2**+**(1/5)^2**+**(1/5)^2**)* On 12-10-2013 3:52, Indrajit $nai wrote: Hello Experts, Kindly fi

Re: $$Excel-Macros$$ Help required in formula.....

s@googlegroups.com] *On Behalf Of *Indrajit $nai > *Sent:* Friday, October 04, 2013 7:13 AM > > *To:* excel-macros@googlegroups.com > *Subject:* Re: $$Excel-Macros$$ Help required in formula. > > ** ** > > Hi Ravinder, > > ** ** > > Actually it wa

Re: $$Excel-Macros$$ Help required in formula.....

d > drag > > ** ** > > *From:* excel-macros@googlegroups.com [mailto: > excel-macros@googlegroups.com] *On Behalf Of *Indrajit $nai > *Sent:* Thursday, October 03, 2013 1:29 PM > *To:* excel-macros@googlegroups.com > *Subject:* Re: $$Excel-Macros$$ Help required in formu

RE: $$Excel-Macros$$ Help required in formula.....

Actullay its fuction u have to use as Excel formulas type =sumup(b2) and drag From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Indrajit $nai Sent: Thursday, October 03, 2013 1:29 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Help

Re: $$Excel-Macros$$ Help required in formula.....

Unable to run the macro, kindly assist. -- Indrajit Disclaimer: This electronic message and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you are not the intended recipient you are hereby notified th

Re: $$Excel-Macros$$ Help for Copy paste

> *Sent:* Saturday, September 21, 2013 3:50 PM > *To:* excel-macros@googlegroups.com > *Subject:* Re: $$Excel-Macros$$ Help for Copy paste > > ** ** > > Dear Ravindra > > Great job thanks. > > my problem is resolved > > Now just for the knowledge i

Re: $$Excel-Macros$$ Help for Copy paste

Dear Ravindra Great job thanks. my problem is resolved Now just for the knowledge is there any way to delete all blank rows where there is formula but no value as in my case Thanks once again Regards Shrinivas On Sat, Sep 21, 2013 at 1:23 PM, Ravinder wrote: > pfa > > ** ** > > *From:* exce

Re: $$Excel-Macros$$ Help Required : How i import Data in Excel from DBF File & Get Max voucher Number

,* > > *Ravi Kumar.* > > ** ** > > *From:* excel-macros@googlegroups.com [ > mailto:excel-macros@googlegroups.com ] *On > Behalf Of *Ravinder > *Sent:* Wednesday, September 11, 2013 3:56 PM > *To:* excel-macros@googlegroups.com > *Cc:* Soum > *Subjec

RE: $$Excel-Macros$$ Help Required : How i import Data in Excel from DBF File & Get Max voucher Number

cel-macros@googlegroups.com <mailto:excel-macros@googlegroups.com> Cc: Soum Subject: RE: $$Excel-Macros$$ Help Required : How i import Data in Excel from DBF File & Get Max voucher Number Use below formula or attached file.may be u r looking for this.. =IF(A2="",&

RE: $$Excel-Macros$$ Help Required : How i import Data in Excel from DBF File & Get Max voucher Number

Use below formula or attached file.may be u r looking for this.. =IF(A2="","",MONTH(A2)&"000"&SUM((MONTH($A$2:A2)=MONTH(A2))*1)) From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of rashid memon Sent: Wednesday, September 11, 2013 2:19 PM To: excel-macros@

RE: $$Excel-Macros$$ Help Required : How i import Data in Excel from DBF File & Get Max voucher Number

Pls provide example file for more clarification. From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of rashid memon Sent: Wednesday, September 11, 2013 2:19 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Help Required : How i import Data in Exce

Re: $$Excel-Macros$$ HELP WITH FALSE RESULT IN EXCEL

everything works out fine with my original formula except for time-in is on or about 11:15 AM and time-out is 12:00 PM, this is the only range where i get a FALSE result.. On Mon, Sep 9, 2013 at 2:46 AM, Waseem Saifi wrote: > Please use ROUND function while subtract. > > Because while subtracti

Re: $$Excel-Macros$$ HELP WITH FALSE RESULT IN EXCEL

Please use ROUND function while subtract. Because while subtracting answer is (In General Format) = 0.03472223 and when you determine in formula =timevalue("0:50:00"), it's value is (In General Format) = 0.0347 You can use =ROUND(E2-D2,15) or 14 or 13 in num_digits, But no mor

Re: $$Excel-Macros$$ HELP WITH FALSE RESULT IN EXCEL

Please add false statement =IF(AND(F2<=TIMEVALUE("0:50:00"),F2>TIMEVALUE("0:30:00")),"RV",IF(AND(F2<=TIMEVALUE("1:00:00"),F2>TIMEVALUE("0:51:00")),"IE",IF(F2=TIMEVALUE("0:00:00"),"MV", *"")*)) . Enjoy Team XLS On Mon, Sep 9, 2013 at 12:33 PM, Angel Araneta wrote: > >

Re: $$Excel-Macros$$ Help needed in Excel

ugust 13, 2013 1:26:31 PM UTC+5:30, Ravinder Negi wrote: > >> pfa...first select area which you want to merge...example select range >> "A1:B4" then click on button >> >> -- >> *From:* Pankaj >> *To:* excel-...@googlegroups

Re: $$Excel-Macros$$ Help Opening in folder using general path

Worked perfectly, thank you very much. On 1 August 2013 14:10, De Premor wrote: > Ups Sorry, my fault, i haven't change a variable to fit yours > > > Sub tes() > Dim oWSHShell As Object, OpenFile As String > > Set oWSHShell = CreateObject("WScript.Shell") > OpenFile = oWSHShell.Spe

Re: $$Excel-Macros$$ help needed urgent

thanks.. its done On Wed, Aug 21, 2013 at 4:05 PM, vba wrote: > See any hidden temp file is created or not. > > Try revoking shared access for particular folder n re share. > > Thanks > On 21 Aug 2013 17:26, "thameem" wrote: > >> Dear all, >> file is in server, but no one is using that file, b

Re: $$Excel-Macros$$ help needed urgent

See any hidden temp file is created or not. Try revoking shared access for particular folder n re share. Thanks On 21 Aug 2013 17:26, "thameem" wrote: > Dear all, > file is in server, but no one is using that file, but stil showing file is > use.. please help me wat to do... > > -- > Are you =E

Re: $$Excel-Macros$$ Help needed in Excel

roups.com > *Cc:* ravinder negi > > *Sent:* Tuesday, August 13, 2013 8:49 AM > *Subject:* Re: $$Excel-Macros$$ Help needed in Excel > > > I want to merge contents of column A & B as shown in column C. Please see > the sample file enclosed > > > On Wednesday,

Re: $$Excel-Macros$$ Help needed in Excel

I want to merge contents of column A & B as shown in column C. Please see the sample file enclosed On Wednesday, August 7, 2013 2:34:57 PM UTC+5:30, Ravinder Negi wrote: > > pls provide excel or explain more about your query... > > -- > *From:* Pankaj > > *To:* ex

Re: $$Excel-Macros$$ Help needed in Excel

pls provide excel or explain more about your query... From: Pankaj To: excel-macros@googlegroups.com Sent: Wednesday, August 7, 2013 9:23 AM Subject: $$Excel-Macros$$ Help needed in Excel I have 2 columns in excel - A and B. I want to merge the contents

Re: $$Excel-Macros$$ Help needed in Excel

Concatenate(a1,char(10),b1) On Aug 7, 2013 9:24 AM, "Pankaj" wrote: > > > I have 2 columns in excel - A and B. > > I want to merge the contents of a horizontal row one below the other as: > A > B > > please tell me a formula to do this as the columns contain 900 cells each > and I cannnot merge t

Re: $$Excel-Macros$$ Help Opening in folder using general path

Ups Sorry, my fault, i haven't change a variable to fit yours Sub tes() Dim oWSHShell As Object, OpenFile As String Set oWSHShell = CreateObject("WScript.Shell") OpenFile = oWSHShell.SpecialFolders("Desktop") & "\data_source\week_to_date-export.xls" Set oWSHShell = Nothing

Re: $$Excel-Macros$$ Help Opening in folder using general path

Try this Sub tes() Dim oWSHShell As Object, OpenFile As String Set oWSHShell = CreateObject("WScript.Shell") OpenFile = oWSHShell.SpecialFolders("Desktop") & "\data_source\week_to_date-export.xls" Set oWSHShell = Nothing Workbooks.Open Filename:=SaveDest End Sub Pada 01/

Re: $$Excel-Macros$$ Help to Calculate Half day leave in Attendance

Thank you so much ur formula is working .. sir On Tuesday, 29 January 2013 22:28:19 UTC+5:30, Excel Beginner wrote: > > Hi Hemanath, > > Use the following formula or more clarity find the > attachment. > > =COUNTIF(*C3:AG3*,"H")*0.5 > > > > > > > >

Re: $$Excel-Macros$$ Help req - sumif & sumifs or countif & countifs

Dear Prabhu, THANKS A LOT. On 29 July 2013 20:41, Prabhu Pinky wrote: > Sumif - used to sum the range by checking single condition. > Sumifs - used to sum the range by checking multiple conditions. > > Countif - used to count the range by checking single condiyion. > Countifs - used to count th

Re: $$Excel-Macros$$ Help req - sumif & sumifs or countif & countifs

Dear Rajasekhar, THanks On 29 July 2013 21:00, Rajasekhar Praharaju wrote: > Hi Ashish, > > Just go through this link... you have good examples... > > http://chandoo.org/wp/2008/11/12/using-countif-sumif-excel-help/ > > Thanks, > Raj > > > On Mon, Jul 29, 2013 at 8:41 PM, Prabhu Pinky wrote: > >

Re: $$Excel-Macros$$ Help req - sumif & sumifs or countif & countifs

Hi Ashish, Just go through this link... you have good examples... http://chandoo.org/wp/2008/11/12/using-countif-sumif-excel-help/ Thanks, Raj On Mon, Jul 29, 2013 at 8:41 PM, Prabhu Pinky wrote: > Sumif - used to sum the range by checking single condition. > Sumifs - used to sum the range by

Re: $$Excel-Macros$$ Help req - sumif & sumifs or countif & countifs

Sumif - used to sum the range by checking single condition. Sumifs - used to sum the range by checking multiple conditions. Countif - used to count the range by checking single condiyion. Countifs - used to count the range by checking multiple conditions. On Jul 29, 2013 8:28 PM, "Ashish Kumar" w

Re: $$Excel-Macros$$ Help need on attached Excel

Hi Sir, I checked the same main time but In-vain it can not shows the results in the attendance details calculator. Request you to kindly assist me in briefly *Regards* On Wed, Jul 17, 2013 at 5:58 PM, P.VIJAYKUMAR wrote: > Respected Vikas, > > There is no problem with the tracker.Just enable

Re: $$Excel-Macros$$ Help need on attached Excel

Respected Vikas, There is no problem with the tracker.Just enable the macros of excel.For inputting any new data do not type manually but use the button given and type the data into the dialogue box you get after pressing the button. ** Regards, VijayKumar -- Are you =EXP(E:RT) or =NOT(EXP(E

Re: $$Excel-Macros$$ Help Required

Hi pfa Anil Kumar From: Neeraj Chauhan To: excel-macros@googlegroups.com Sent: Wednesday, 17 July 2013 3:41 PM Subject: $$Excel-Macros$$ Help Required Dear experts,   How to subtract time in hours and minute   10:30 AM -  10:30 PM =     Thank

Re: $$Excel-Macros$$ Help Required

Please find attachment. it might help you On 7/17/13, Neeraj Chauhan wrote: > Dear experts, > > > > How to subtract time in hours and minute > > > > > 10:30 AM > > - 10:30 PM > > = > > > > > > Thanks & Regards > > Neeraj Chauhan > > +91-9756706350 > > neerajchauhan...@gmail.com > > > > -

Re: $$Excel-Macros$$ Help need on attached Excel

Any Hope? Regards On Tue, Jul 16, 2013 at 9:20 PM, Bé Trần Văn wrote: > File your reference, the noorain.ansari > > 2013/7/16 vikas khen > >> Hi Team, >> >> Expecting replay on this mail as It will very helpful for me >> >> Regards >> >> >> On Thu, Jul 11, 2013 at 1:43 PM, vikas khen wrote:

Re: $$Excel-Macros$$ Help need on attached Excel

Hi Team, Expecting replay on this mail as It will very helpful for me Regards On Thu, Jul 11, 2013 at 1:43 PM, vikas khen wrote: > Hi Experts, > > I have found below attached Excel tracker on group it's Fantastic it's > amazing! but i need to understand how it's Attendance calculate is >

Re: $$Excel-Macros$$ Help needed

thank you it working On Sun, Jul 14, 2013 at 3:58 PM, ashish koul wrote: > try this > Sub check_files_to_open() > > Dim flname As String > > flname = InputBox("Enter file to search") > Set fso = CreateObject("scripting.filesystemobject") > Set fld = fso.getfolder("C:\Users\admin

Re: $$Excel-Macros$$ Help needed

try this Sub check_files_to_open() Dim flname As String flname = InputBox("Enter file to search") Set fso = CreateObject("scripting.filesystemobject") Set fld = fso.getfolder("C:\Users\admin\Desktop\New folder") For Each fil In fld.Files If UCase(Left(fil.Name, InStrR

Re: $$Excel-Macros$$ Help needed

sorry again not working, its asking to select folder, later file name, if i type file name, its actually pdf format but opening in excel format. cant we fix folder path in this program, so there is no need to select folder every time On Sun, Jul 14, 2013 at 11:57 AM, ashish koul wrote: > hi

Re: $$Excel-Macros$$ Help needed

hi try this Sub check_files_to_open() Dim fldpath Dim fld As Object, fil As Object, fso As Object Dim flname As String With Application.FileDialog(msoFileDialogFolderPicker) .Title = "Choose the folder" .Show End With flname = InputBox("Enter file to search") On Error Resume Next fldpath = App

Re: $$Excel-Macros$$ Help needed

Sorry, might be I am not explained clearly, example I have file name "350" in that folder i have file names from 1 to 5000, i will type this file name "350" in one cell, then i will run vba code, so it can open file with name "350". please help me regards, thameem On Sun, Jul 14, 2013 at 9:57 A

Re: $$Excel-Macros$$ Help needed

try this see if it helps Sub check_files_to_open() Dim fldpath Dim fld As Object, fil As Object, fso As Object With Application.FileDialog(msoFileDialogFolderPicker) .Title = "Choose the folder" .Show End With On Error Resume Next fldpath = Application.FileDialog(msoFileDialogFolderPicker).Sel

Re: $$Excel-Macros$$ Help Needed

HI DP many thanks for the solution..for my query and its working and serving my purpose 100% thanks Patil M G On Wed, Jul 10, 2013 at 7:22 PM, De Premor wrote: > Hi Patil, > > PFA > > Please Run Procedure named *GenerateFromTemplate > * > Rgds, > [dp]* > > * > Pada 10/07/2013 18:30, Pati

Re: $$Excel-Macros$$ Help me plz

thank you bro On Wed, Jul 3, 2013 at 3:00 PM, Waseem Saifi wrote: > Dear Thameem, > > Open attached file. I have applied rule what you have asked. > just select from cell A2:C4 and go to conditional formatting-manage rules. > It will be cleared. > > > On Sat, Jun 22, 2013 at 2:56 PM, thameem w

Re: $$Excel-Macros$$ Help me plz

Dear Thameem, Open attached file. I have applied rule what you have asked. just select from cell A2:C4 and go to conditional formatting-manage rules. It will be cleared. On Sat, Jun 22, 2013 at 2:56 PM, thameem wrote: > Dear all, > > Plz find attached file, its sample, I want high for range of

Re: $$Excel-Macros$$ Help in linking data based on PO criteria

Hi Vabz & Nur, I have done some research on both PFA's and Relay code and am a little confused at how they can be used in my project? Could either of you expand on how I could use them or refer me to a tutorial or site that will help me get a better understanding so I can apply it to the proje

Re: $$Excel-Macros$$ Help in linking data based on PO criteria

Thank you both for the help! Im not very familiar with PFA files or relay code so I will do some research. Any tips on where to look or any website tutorials would be great. Thanks again! On Tuesday, June 25, 2013 2:34:38 AM UTC-4, Ravinder Negi wrote: > PFA > > --- On *Mon, 6/24/13, rya

Re: $$Excel-Macros$$ Help Pivot table gives error when adding to "addDataFiled"

Thanks, I discovered the error, but ended up using your's macros, thank you very much all. On 7 June 2013 15:27, Bé Trần Văn wrote: > You try this Code, used for Version. > > Code: > Sub PivotTable_Change() > Dim PTCache As PivotCache > Dim PT As PivotTable > Application.ScreenUpdating = False >

Re: $$Excel-Macros$$ Help in linking data based on PO criteria

it's relay effective code..nur On Tue, Jun 25, 2013 at 11:02 AM, VBA VABZ wrote: > Hi > > PFA file that take care of coping data. > > HTH//Vabs > > > On Mon, Jun 24, 2013 at 7:41 PM, wrote: > >> Hi All! >> >> My name is Ryan. I am pretty experienced in Excel but have run into a >> dead in wit

Re: $$Excel-Macros$$ Help in linking data based on PO criteria

Hi PFA file that take care of coping data. HTH//Vabs On Mon, Jun 24, 2013 at 7:41 PM, wrote: > Hi All! > > My name is Ryan. I am pretty experienced in Excel but have run into a > dead in with my recent project. I currently manage all PO's for my company > to perform financial formulas, analy

Re: $$Excel-Macros$$ Help me plz

Thank you, it working fine, I will update in my file now, thank you once again. regards, Thameem.m On Sat, Jun 22, 2013 at 4:42 PM, De Premor wrote: > Attached, new rule based on C > 0 and D=0 > > Rgds, > [dp] > > Pada 22/06/2013 18:03, thameem menulis: > > Plz check attached file > > > On S

Re: $$Excel-Macros$$ Help me plz

Attached, new rule based on C > 0 and D=0 Rgds, [dp] Pada 22/06/2013 18:03, thameem menulis: Plz check attached file On Sat, Jun 22, 2013 at 2:39 PM, De Premor > wrote: can you provide us more raw data in excel with some example that meet your requirement to

Re: $$Excel-Macros$$ Help me plz

Plz check attached file On Sat, Jun 22, 2013 at 2:39 PM, De Premor wrote: > can you provide us more raw data in excel with some example that meet > your requirement to make it more clearly to understand ! > > Rgds > [dp] > Pada 22/06/2013 17:21, thameem menulis: > > SORRY , I need high only

Re: $$Excel-Macros$$ Help me plz

can you provide us more raw data in excel with some example that meet your requirement to make it more clearly to understand ! Rgds [dp] Pada 22/06/2013 17:21, thameem menulis: SORRY , I need high only for 3 condition... there is zero in row 2 also, in my data alot of zero are there... because

Re: $$Excel-Macros$$ Help me plz

SORRY , I need high only for 3 condition... there is zero in row 2 also, in my data alot of zero are there... because still my data is on process not yet freeze... so it can change.. once it get freeze, we can apply C3=0 or c2=0 condition, but to freeze data, it will take 2 more months, but i need

Re: $$Excel-Macros$$ Help me plz

In attached file, please see the conditional formating formula and range to apply Rgds, [dp] Pada 22/06/2013 16:26, thameem menulis: Dear all, Plz find attached file, its sample, I want high for range of cells, only at that condition, plz help me to learn, for condition or sample find attac

Re: $$Excel-Macros$$ Help to create transport Cab roster

On 14 June 2013 11:13, Prabhu Pinky wrote: > Hi asish..i can give inputs for you. Gimme some till will prepare a > document and share to you..hope it may help you... > On Jun 14, 2013 10:57 AM, "Ashish Kumar" > wrote: > >> Dear Seniors, >> >> How to create a transport Cab roster. If, any one hav

Re: $$Excel-Macros$$ Help to create transport Cab roster

Hi asish..i can give inputs for you. Gimme some till will prepare a document and share to you..hope it may help you... On Jun 14, 2013 10:57 AM, "Ashish Kumar" wrote: > Dear Seniors, > > How to create a transport Cab roster. If, any one have an these type of > roster data or example, then please

Re: $$Excel-Macros$$ Help required to change cursor colour in excel sheet

You can do this type of thing, but only by using VBA (or macros) - there is no built in Excel setting to control this. There is one massive drawback, and that is that this technique will use something called "Event Procedures", which means that the macro will fire every time you move the cursor -

Re: $$Excel-Macros$$ help needed

Thank you Sir, lock aspect ratio and move and don't resize with cells, are not checked(ticked), I did both. thank you once again for helping me, regards, Thameem.M On Mon, Jun 10, 2013 at 8:38 AM, P.VIJAYKUMAR wrote: > Respected Thameem, > > After inserting the graph you get the chart tools in

Re: $$Excel-Macros$$ help needed

Respected Thameem, After inserting the graph you get the chart tools in the menu bar. In the chart tools menu go to the formatting tab. In the last tab (to the right) you will find size munu.Click the small arrow down the tab and you will get sizing message box with size and properties tabs.In the

Re: $$Excel-Macros$$ help needed

am sorry, it is office file, I am working for gas plant, they dont allow us to use USB or to upload any official file in mail. regards, Thameem.M On Sun, Jun 9, 2013 at 1:56 PM, priti verma wrote: > Can you please share your file > > > On Sun, Jun 9, 2013 at 2:32 PM, thameem wrote: > >> Dear s

Re: $$Excel-Macros$$ help needed

Can you please share your file On Sun, Jun 9, 2013 at 2:32 PM, thameem wrote: > Dear sir's, > > I have problem in excel graph, its automatically getting enlarged, if i > close and open excel, then again it will be in original size, with out any > modification, please advise me > > > regards, >

Re: $$Excel-Macros$$ Help delete rows with dynamic worksheets

Works perfectly :), thanks a million. On 6 June 2013 17:01, ashish koul wrote: > see if it helps > Sub test() > Dim wk As Worksheet > Dim i As Long > Application.ScreenUpdating = False > Application.DisplayAlerts = False > Application.Calculation = xlCalculationManual > > For Each wk In ThisWork

Re: $$Excel-Macros$$ Help delete rows with dynamic worksheets

see if it helps Sub test() Dim wk As Worksheet Dim i As Long Application.ScreenUpdating = False Application.DisplayAlerts = False Application.Calculation = xlCalculationManual For Each wk In ThisWorkbook.Worksheets For i = wk.Range("a" & wk.Rows.Count).End(xlUp).Row To 2 Step -1 If wk.

Re: $$Excel-Macros$$ Help Needed

its serving my requirement..thank you so much for help paul thanks Patil MG On Wed, Jun 5, 2013 at 8:05 PM, Paul Schreiner wrote: > Try this macro. > > if it does what you're looking for, then I can walk you through how it > operates. > > > *Paul* > > ---

Re: $$Excel-Macros$$ HELP REQUIRED - TOP 3 VALUES

Hi, PFA... Regards, Kuldeep Singh Assistant Manager Quality Game Zone India Limited Phone.: +91-9716615535 || naukrikuld...@gmail.com || *Please* *Consider the environment. Please don't print this e-mail unless you really need to.* * * On Thu, May 23, 2013 at 2:23 PM, Prashant Pawle wrote: >

Re: $$Excel-Macros$$ Help Please - Data sub validation

Good job!!! On Tue, May 21, 2013 at 3:42 PM, Chaya wrote: > Thanks a lot priti. > > > Regards, > Chaya > > The excel learner :-) > > > On Tue, May 21, 2013 at 3:39 PM, priti verma wrote: > >> HI chaya, >> I hope this is what you're asking ... >> >> >> On Tue, May 21, 2013 at 2:59 PM, Chaya wro

Re: $$Excel-Macros$$ Help Please - Data sub validation

Thanks a lot priti. Regards, Chaya The excel learner :-) On Tue, May 21, 2013 at 3:39 PM, priti verma wrote: > HI chaya, > I hope this is what you're asking ... > > > On Tue, May 21, 2013 at 2:59 PM, Chaya wrote: > >> Dear Priti, >> >>As always you did the great logical solution. Infact

Re: $$Excel-Macros$$ Help Please - Data sub validation

HI chaya, I hope this is what you're asking ... On Tue, May 21, 2013 at 2:59 PM, Chaya wrote: > Dear Priti, > >As always you did the great logical solution. Infact i really don't > understand the formula used for data validation in Level2 (very huge long), > but i have got some more ideas o

<    1   2   3   4   5   6   7   8   9   10   >