Re: $$Excel-Macros$$ Help required for formule

x the values with "Z" (or some alpha character) > > Paul > > > *From:* Jagadeesh B S > *To:* excel-macros@googlegroups.com > *Sent:* Thu, November 18, 2010 1:18:24 AM > *Subject:* Re: $$Excel-Macros$$ Help required for formule > > > Hello friends my require

Re: $$Excel-Macros$$ Help required for formule

h "Z" (or some alpha character) Paul > >From: Jagadeesh B S >To: excel-macros@googlegroups.com >Sent: Thu, November 18, 2010 1:18:24 AM >Subject: Re: $$Excel-Macros$$ Help required for formule > > > > >Hello friends my requirement is met in some way but not the compl

Re: $$Excel-Macros$$ Help required for formule

gt; *From:* Jagadeesh B S > > *To:* excel-macros@googlegroups.com > > *Sent:* Wed, November 17, 2010 7:45:42 AM > > *Subject:* $$Excel-Macros$$ Help required for formule > > >  Hello Friends > > > I need a formula or macro( preferabley formule) need to prepare this repo

Re: $$Excel-Macros$$ Help required for formule

Your formula for row 3 would look like: =IF(C3="USD",VLOOKUP(A3,Data!A:E,5,FALSE),VLOOKUP(A3,Data!A:E,4,FALSE)) Paul > >From: Jagadeesh B S >To: excel-macros@googlegroups.com >Sent: Wed, November 17, 2010 7:45:42 AM >Subject: $$Excel-Macros$$ Help required for form

$$Excel-Macros$$ Help required for formule

Hello Friends I need a formula or macro( preferabley formule) need to prepare this report . I need a formula which should get the details for the account # mentioned in the column A with the reference to the currency,form the sheet DATA, if the currency is USD It should pull the value in the colu

Re: $$Excel-Macros$$ Help Required

*No dear its still pending * On Thu, Nov 11, 2010 at 12:59 PM, Rajasekhar Praharaju < rajasekhar.prahar...@gmail.com> wrote: > hello rakesh, > > Only for this attached sheet do you have query or Prior chain mails as > well, then i think u can just use this formula for the attached sheet > replac

Re: $$Excel-Macros$$ Help Required

hello rakesh, Only for this attached sheet do you have query or Prior chain mails as well, then i think u can just use this formula for the attached sheet replacing date =A2+30 By adding 30days u are getting the answer...Please let me know if this resolves your query or not. Thanks, R

$$Excel-Macros$$ Help Required

Dear All, Can i replace the date as per my requirement. if yes plz suggest me how it possible. Thanks in advance plz do the needful ASAP. -- Regards Rakesh Sharma -- -- Some important links for excel users: 1. F

Re: $$Excel-Macros$$ help required

Hi dave, VBA also ok for me. Regards Girish On Wed, Nov 3, 2010 at 4:07 PM, Dave Bonallack wrote: > Hi Girish, > Can we use VBA? > Regards - Dave. > > -- > Date: Wed, 3 Nov 2010 12:36:23 +0530 > > Subject: Re: $$Excel-Macros$$ help require

RE: $$Excel-Macros$$ help required

Hi Girish, Can we use VBA? Regards - Dave. Date: Wed, 3 Nov 2010 12:36:23 +0530 Subject: Re: $$Excel-Macros$$ help required From: girishkumar832...@gmail.com To: excel-macros@googlegroups.com; davebonall...@hotmail.com Hi Dave, Pls. find attached file. i have added formulas in respective

RE: $$Excel-Macros$$ help required

nswering my questions. I don't like guessing. Regards - Dave. Date: Tue, 2 Nov 2010 19:28:15 +0530 Subject: Re: $$Excel-Macros$$ help required From: girishkumar832...@gmail.com To: excel-macros@googlegroups.com; davebonall...@hotmail.com Hi Dave thanks for your reply actually i remove

RE: $$Excel-Macros$$ help required

ust not possible with this info. Regards - Dave. Date: Mon, 1 Nov 2010 19:37:37 +0530 Subject: Fwd: $$Excel-Macros$$ help required From: girishkumar832...@gmail.com To: excel-macros@googlegroups.com Dear Experts, Any updates!!! -- Forwarded message -- From: girish kumar Da

Re: $$Excel-Macros$$ Help Required

*Thanks A lot dear * On Fri, Oct 29, 2010 at 4:53 PM, anil panchal wrote: > Dear Rakesh, > > As per Discus please find the attached file. > > hope this is want you :-) > > Thanks & Regards > Anil Kumar > 113784 > > > On Fri, Oct 29, 2010 at 3:41 PM, anil panchal wrote: > >> Dear Rakesh, >>

Re: $$Excel-Macros$$ Help Required

already give solution On Fri, Oct 29, 2010 at 3:16 PM, Born to Win wrote: > Hello, > > Please Use COUNTA() Function or check Attached File. > > Thanks, > Chandrabhan Singh > > > > On Fri, Oct 29, 2010 at 2:43 PM, Rakesh Sharma wrote: > >> *Dear All, >> >> >> Please find the attachment and let me

$$Excel-Macros$$ Help Required!

Hi Team, I want a macro in MS word that will do the following. It will first convert the upper case into title case and then replace every connecting word with lower case. *Example:* AGREEMENT. THE ADOPTION THE ADULT OR MARRIED MINOR *Required Output:* Agreement. The Adoption the Adul

$$Excel-Macros$$ Help Required Macro/Formula

Dear Group, Can I Have Help on Attached file . *Best Regards,* *Venkat* -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our

Re: $$Excel-Macros$$ help required

hi experts, its a rolling up method for example if raw cdr having No 93854512115 then formula should find name for this no if didnt then it roll up one no and then find again (like 9385451211) till finding name it will rolling up hope now u understand Girish On Tue, Oct 19, 2010 at 1:24 PM,

Re: $$Excel-Macros$$ help required

Please check the attachment, On Tue, Oct 19, 2010 at 10:32 AM, girish kumar wrote: > Hi Krishna, > > see file attached, in that second sheet u see in b column i used Left > function and in c column Vlookup > > left function i used =left(A2.13) > > and vlookup answer is #N/A > > Becau

Re: $$Excel-Macros$$ help required

Hello, Dear Please check this. Perhaps you need this. Thanks Chandra Gupta Maurya On Mon, Oct 18, 2010 at 7:52 PM, girish kumar wrote: > Dear Experts, > > need one urgent help from you guys i have attached one file having 2 sheets > named "system data" & "Raw CDR" > > i need a formula for getti

Re: $$Excel-Macros$$ help required

Dear Girish Please find herewith enclosed file. regards sumit On Tue, Oct 19, 2010 at 10:32 AM, girish kumar wrote: > Hi Krishna, > > see file attached, in that second sheet u see in b column i used Left > function and in c column Vlookup > > left function i used =left(A2.13) > > and vlookup

Re: $$Excel-Macros$$ help required

Hi Krishna, see file attached, in that second sheet u see in b column i used Left function and in c column Vlookup left function i used =left(A2.13) and vlookup answer is #N/A Because In System Data sheet Left function answer is not there if i decrease the no's in left function i ll get the an

Re: $$Excel-Macros$$ help required

Dear Girish, Sorry I didn't understand what you are looking for, Please give an Example, what you want exactly? May be i have some communication problem to understand your query. Thanks, Excelkid On Mon, Oct 18, 2010 at 7:52 PM, girish kumar wrote: > Dear Experts, > > need one urgent help fro

$$Excel-Macros$$ help required

Dear Experts, need one urgent help from you guys i have attached one file having 2 sheets named "system data" & "Raw CDR" i need a formula for getting name in sheet Raw CDR for exam sheet system data having no 93 Afghanistan Other and Raw Cdr having No 93854512115 for getting destination na

$$Excel-Macros$$ Help required to copy selective folders from various subfolders.

HI Team, I am looking for a macro for copy selective folders by name from various subfolders. Instance: Folder A has 3 subfolders named (aaa, bbb, ccc) Each subfolder has super subfolders as (Input & Output) Requirement: I have to copy all Output folders from Each Parent folder by replacing t

Re: $$Excel-Macros$$ Help Required Making Data into Muliple sheets

Dear Siti, Thanks a lot Best Regards, Venkat On Fri, Sep 24, 2010 at 3:47 PM, siti Vi wrote: > Sub splittabel() > ' siti Vi / jakarta, 24 sept 2010 > Dim RefTbl As Range > Dim DesTbl As Range > Dim sNames As String, ArrNames > Dim r As Long, n As Long, i As Long, c As Integer > > Set RefTbl

$$Excel-Macros$$ Help Required: Line Charts

Hi, I've a workbook where two tables given on the sheet1 showing sales for 2009 and 2010. I want to present the data through Line Char. There should be a dropdown on the top of the charts containing three values 2009, 2010 & 2009 Vs 2010. If I select 2009 then the chart should show only sales dur

$$Excel-Macros$$ Help Required: Line Charts

Hi, I've a workbook where two tables given on the sheet1 showing sales for 2009 and 2010. I want to present the data through Line Char. There should be a dropdown on the top of the charts containing three values 2009, 2010 & 2009 Vs 2010. If I select 2009 then the chart should show only sales dur

$$Excel-Macros$$ Help Required: Line Charts

Hi, I've a workbook where two tables given on the sheet1 showing sales for 2009 and 2010. I want to present the data through Line Char. There should be a dropdown on the top of the charts containing three values 2009, 2010 & 2009 Vs 2010. If I select 2009 then the chart should show only sales dur

Re: $$Excel-Macros$$ Help Required......for conditional Large Function..

hi check the attachment see if it helps -- Regards Ashish Koul 9953979291 *akoul*.*blogspot*.com *akoul*.wordpress.com My Linkedin Profile On Tue, Sep 7, 2010 at 5:37 PM, NOORAIN AN

$$Excel-Macros$$ Help Required......for conditional Large Function..

Dear Experts, I need a help. I have a list of Employees and his Salaries. I want to retrieve 2nd highest salary of a particular employee. I am unable to retrieve it through Large() function.Please help File is attached. Thanks in advance Noorain Ansari -- -

Re: $$Excel-Macros$$ Help Required!

Hi Ashish, Am still getting compile error since i am using microsoft outlook 2000 version. Can this code work in 2000 version or I should execute this code using 2007 version. Please advice me. Thanks, Sharma On Fri, Aug 27, 2010 at 1:51 PM, ashish koul wrote: > > > On Fri, Aug 27, 2010 at 1:3

Re: $$Excel-Macros$$ Help Required!

in reference select Microsoft outlook Regards Ashish koul akoul.blogspot.com On Fri, Aug 27, 2010 at 10:06 AM, amrahs k wrote: > Hi Koul, > > Thanks a lot for your effort and time. I have a response for the below > code. > > I get compile error: Can't find project or library while running m

Re: $$Excel-Macros$$ Help Required!

Hi Koul, Thanks a lot for your effort and time. I have a response for the below code. I get compile error: Can't find project or library while running macro. line error: Dim olApp As Outlook.Application Please look into this and advice me how to proceed with this. Regards, Sharma On Thu, Aug 2

Re: $$Excel-Macros$$ Help Required ----

Hi Venkat, I was wondering if you could do away with simple sort command. Given below is the result i got after sorting the provided data. Emp id Product C1101 A C1104 A C1107 A C1110 A C1113 A C1116 A C1119 A C1102 B C1105 B C1108 B C B C1114 B C1117 B C1120 B C1

Re: $$Excel-Macros$$ Help Required ----

Dear Kalyan, My Correct Requirement Is Attached below On Wed, Aug 25, 2010 at 4:30 PM, Kal xcel wrote: > Hi venkat, > > VLOOKUP formula will solveyour problem, see the attachment. > > On Wed, Aug 25, 2010 at 3:15 PM, Venkatesan c wrote: > >> Dear Group, >> >> I have attached sample data belo

Re: $$Excel-Macros$$ Help Required ----

Hi venkat, VLOOKUP formula will solveyour problem, see the attachment. On Wed, Aug 25, 2010 at 3:15 PM, Venkatesan c wrote: > Dear Group, > > I have attached sample data below i want to get defined criteria Emp id's. > Can i have any formula's or Macros > > Best Regards, > * > > Venkat > * >

$$Excel-Macros$$ Help Required ----

Dear Group, I have attached sample data below i want to get defined criteria Emp id's. Can i have any formula's or Macros Best Regards, * Venkat * -- -- Some important links for excel users: 1. Follow us on TWITTE

$$Excel-Macros$$ Help Required!

Hi Team Members, I have a query with regard to outlook email. Can anyone please suggest or advice me how to proceed with this. Requirement: An email should be send automatically with below subject and body to the mentioned address. Copying the left most sheet in the attached excel in a separate w

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

ort.SortFields.Add Key:=Range( _ "B2:B65000"), SortOn:=xlSortOnValues, Order:=xlAscending, DataOption:= _ xlSortNormal With ActiveWorkbook.Worksheets(Sht_OUT).Sort .SetRange Range("A1:B65000") .Header = xlYes .MatchCase = False .Orientat

RE: $$Excel-Macros$$ Help Required

You're welcome. Regards - Dave. Date: Sat, 14 Aug 2010 14:17:47 +0530 Subject: Re: $$Excel-Macros$$ Help Required From: deepaktheind...@gmail.com To: excel-macros@googlegroups.com Thanks Dave - it works... On Sat, Aug 14, 2010 at 1:56 PM, Dave Bonallack wrote: Hi, I hope the att

Re: $$Excel-Macros$$ Help Required

Thanks Dave - it works... On Sat, Aug 14, 2010 at 1:56 PM, Dave Bonallack wrote: > Hi, > I hope the attached contains what you need. > Regards - Dave. > > -- > Date: Sat, 14 Aug 2010 10:23:42 +0530 > Subject: $$Excel-Macros$$ Help Required

RE: $$Excel-Macros$$ Help Required

Hi, I hope the attached contains what you need. Regards - Dave. Date: Sat, 14 Aug 2010 10:23:42 +0530 Subject: $$Excel-Macros$$ Help Required From: deepaktheind...@gmail.com To: excel-macros@googlegroups.com Hi All, I need your help to make an automation of the attached worksheet. In

$$Excel-Macros$$ Help Required

Hi All, I need your help to make an automation of the attached worksheet. In the attached workbook different columns have been given . We have to searched for duplicate entries in column Service Provider, From and To. If values entered in these 3 columns are same then it should be displayed “Yes”

Re: $$Excel-Macros$$ help required

ing, >> DataOption:= _ >> xlSortNormal >> ActiveWorkbook.Worksheets(Sht_OUT).Sort.SortFields.Add Key:=Range( _ >> "B2:B65000"), SortOn:=xlSortOnValues, Order:=xlAscending, >> DataOption:= _ >> xlSortNormal >> With Active

Re: $$Excel-Macros$$ help required

lSortOnValues, Order:=xlAscending, > DataOption:= _ > xlSortNormal > With ActiveWorkbook.Worksheets(Sht_OUT).Sort > .SetRange Range("A1:B65000") > .Header = xlYes > .MatchCase = False > .Orientation = xlTopToBottom >

Re: $$Excel-Macros$$ help required

xlSortNormal     With ActiveWorkbook.Worksheets(Sht_OUT).Sort     .SetRange Range("A1:B65000")     .Header = xlYes     .MatchCase = False     .Orientation = xlTopToBottom     .SortMethod = xlPinYin     .Apply     End With     Range("A2").Select End

Re: $$Excel-Macros$$ Help Required Extract Numbers

Hi, Solution for your query will be available in the below link. http://www.ozgrid.com/VBA/ExtractNum.htm On Wed, Aug 4, 2010 at 3:26 PM, Venkatesan c wrote: > Dear Group, > > Find Below data Requirement.I Want to extract numbers post (_ )Only. > Raw Data Required > > Best Regards, > Venkat > >

$$Excel-Macros$$ Help Required Extract Numbers

Dear Group, Find Below data Requirement.I Want to extract numbers post (_ )Only. Raw Data Required Best Regards, Venkat -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links :

$$Excel-Macros$$ Help required

Hi, I am newbie to Macro's, can someone help me with where to find the correct source of information for macro's or any material as such. Many thanks in advance. Regards Sreeji

$$Excel-Macros$$ Help required: Can Data be sent through odbc rather than received?

Where I work, we unfortunately use the dinosaur called SAS. I have a SAS plug in for excel which allows me to ODBC in, execute SAS code, and retrieve the data set created using the copyfromrecordset statement. Problem is this is one directional. I have a need whereby I have data in an excel shee

Re: $$Excel-Macros$$ Help required with if formula

use this formula in cell D7 =IF(OR(B7="A",B7="B"),IF(C7<=$C$4,$B$4,IF(C7<=$C$3,$B$3,IF(C7<=$C$2,$B$2,0))),IF(C7<=$E$4,$D$4,IF(C7<=$E$3,$D$3,IF(C7<=$E$2,$D$2,0 On 12 May 2010 12:31, lucky singh wrote: > Dear All, > > > Kindly help with the IF formula in the attached sheet asap. > > Thanks an

$$Excel-Macros$$ Help required with if formula

Dear All, Kindly help with the IF formula in the attached sheet asap. Thanks an advance. Regards, Lucky Singh Sr. MIS Analyst. 9987337414 -- -- Some important links for excel users: 1. Follow us on TWITTER for ti

Fw: $$Excel-Macros$$ Help required in creating xml from EXCEL

Hi All, My excel containd the following rows and columns: I want to convert this data into an xml file based on the path mentioned in the 2nd column   Data Path Name ocim:root/ocim:name[xsi type:"myname"]/ocim:firstname Name2 ocim:root/ocim:name[xsi type:"myname"]/ocim:Last

$$Excel-Macros$$ Help required in creating xml from EXCEL

Hi All, My excel containd the following rows and columns: I want to convert this data into an xml file based on the path mentioned in the 2nd column   Data Path Name ocim:root/ocim:name[xsi type:"myname"]/ocim:firstname Name2 ocim:root/ocim:name[xsi type:"myname"]/ocim:Lastname i

$$Excel-Macros$$ Help required in creating xml from EXCEL

Hi All, My excel containd the following rows and columns: I want to convert this data into an xml file based on the path mentioned in the 2nd column   Data Path Name ocim:root/ocim:name[xsi type:"myname"]/ocim:firstname Name2 ocim:root/ocim:name[xsi type:"myname"]/ocim:Lastname i doubt "

Re: $$Excel-Macros$$ Help Required

Hi Venkat, Please use the below formula to get the desired output. Attached is the excel sheet for your reference. *=DATE(LEFT(A1,4),MID(A1,5,2),RIGHT(A1,2))* Thanks and best regards, Ayush Jain On Mon, Apr 5, 2010 at 1:14 PM, Venkatesan c wrote: > Dear Group, > > Please help me to create F

$$Excel-Macros$$ Help Required

Dear Group, Please help me to create Function for below Problam & Help books,Procedure to create udf's 20100312=12-mar-2010 * Thanks & Regards, Venkat C* -- -- Some important links for excel users: 1. Follow us o

Re: $$Excel-Macros$$ Help Required - Gantt Chart

hi, check this file i created it will help U. pl give me feedback on this On 1/20/10, Rakesh Sharma <> wrote: > > Hi Maniyan, > > Here is the solution which I think my help you. > > > > Regards > Rakesh > > -- > The INTERNET now has a personality. YOURS! See your Ya

Re: $$Excel-Macros$$ Help Required - Gantt Chart

hi rakesh very great approach for the solution i also needed this solution thanks buddy On 20/01/2010, Rakesh Sharma wrote: > Hi Maniyan, > > Here is the solution which I think my help you. > > >  Regards > Rakesh > > > The INTERNET now has a personality. YOURS! See your Yahoo! Homepage. >

$$Excel-Macros$$ Help Required - Gantt Chart

Hi Maniyan, Here is the solution which I think my help you.  Regards Rakesh The INTERNET now has a personality. YOURS! See your Yahoo! Homepage. http://in.yahoo.com/-- -- Some important links for excel use

Re: $$Excel-Macros$$ Help required in conditional formatting

egi.uttranc...@gmail.com> wrote: >> >>> Hi Mr. Dilip, >>> >>> Its working fine as I was looking. >>> Kindly let me know how you have done it as the process you have described >>> in the attachment, I am doing the same but not able to apply the

Re: $$Excel-Macros$$ Help required in conditional formatting

ave described >> in the attachment, I am doing the same but not able to apply the required >> format on required row as its applying on the selected cell only. >> >> >> >> Unfeigned Regards >> Manoj S Negi >> Skype - manojsnegi >> >> >> -- Forwarded

Re: $$Excel-Macros$$ Help required

Dear Abhi, Your source data is not aligned properly. For working with charts, you need to have data in structured manner. See if you can work with source data and remove extra rows/columns in between. Best Regards, -- DILIP KUMAR PANDEY MBA-HR,B COM(Hons.),BCA Mobile: +91 9810929744 dilipan.

$$Excel-Macros$$ Help required

Dear Friends,   I want to draw line chart for the attached data. The data is for Apr 2008 to March 2009.   Pls provide the help.   Regards,    Abhijit Vipat 9004318922 -- -- Some important links for excel use

Re: $$Excel-Macros$$ Help required in conditional formatting

format on required row as its applying on the selected cell only. > > > > Unfeigned Regards > Manoj S Negi > Skype - manojsnegi > > > ------ Forwarded message -- > From: Dilip Pandey > Date: Wed, Jan 13, 2010 at 3:08 PM > Subject: Re: $$Excel-Macros$$ H

Re: $$Excel-Macros$$ Help required in conditional formatting

ile said formatting is working for > those two rows only not for others.* > > > *Unfeigned Regards > Manoj S Negi > Skype - manojsnegi > * > > -- Forwarded message -- > From: Dilip Pandey > Date: Tue, Jan 12, 2010 at 8:13 PM > Subject: Re: $$

Fwd: $$Excel-Macros$$ Help required in conditional formatting

: $$Excel-Macros$$ Help required in conditional formatting To: excel-macros@googlegroups.com Dear Manoj, Attached file (Excel 2003) version has been solved per your requiremtn and re-attached. Best Regards, -- DILIP KUMAR PANDEY MBA-HR,B COM(Hons.),BCA Mobile: +91 9810929744 dilipan...@gmail.com

Fwd: $$Excel-Macros$$ Help required in conditional formatting

Negi Skype - manojsnegi * -- Forwarded message -- From: Dilip Pandey Date: Tue, Jan 12, 2010 at 8:13 PM Subject: Re: $$Excel-Macros$$ Help required in conditional formatting To: excel-macros@googlegroups.com Dear Manoj, Attached file (Excel 2003) version has been solved per your

Re: $$Excel-Macros$$ Help required in conditional formatting

Dear Manoj, Attached file (Excel 2003) version has been solved per your requiremtn and re-attached. Best Regards, -- DILIP KUMAR PANDEY MBA-HR,B COM(Hons.),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 110062 On Tue, Jan 12, 2010 at 5:13 PM, Manoj S Negi <

$$Excel-Macros$$ Help required in conditional formatting

Hi All, Refer to the mail subject kindly help me in conditional formatting as per below mentioned condition... * "How to change the format of a particular row's format based on an particular cell's value".* Files are also attached for further reference. Right now I am using Excel 2007 therefore I

$$Excel-Macros$$ help required want to add oulook signature with logos in it

ho to insert outlook signature with logos in email while sending a mil from excel Sub SendWithAtt() Dim olApp As Outlook.Application Dim olMail As MailItem Dim i As Long Dim SigString As String Dim Signature As String Application.ScreenUpdating = False Set olApp = N

$$Excel-Macros$$ help required

hi Can someone please change this code as per my requirement . i want that if i am doing nothing in my workbook its idle lets say for 3 or 4 minutes its should automatically save and close it ...also let me know in which event i have to put the macro workbook open or activate , etc. Const idle

Re: $$Excel-Macros$$ Help required for Macro_Autofilter & copy data

Dear All I did it. first i filter data as per date criteria then take it on new sheet & from there copy unique value in workbook in folder. below mention is revised code Sub Macroms() Dim mydate As Date Dim wsm As Worksheet ' ' Macro5 Macro ' ' mydate = Range("H1").Value Selection.AutoFilter

Re: $$Excel-Macros$$ Help Required!

Dear Sharmaji, Thanks and same to you and your family. 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/25/09, amrahs k wrote: > > Dear Dilip, > > First I would like to wish you "Merry Chri

Re: $$Excel-Macros$$ Help Required!

Dear Dilip, First I would like to wish you "Merry Christmas" and Looking forward to continued success with you! Advance Happy New Year 2010 for you and your Family! Thanks for your efforts! Regards, Sharma On 12/24/09, Dilip Pandey wrote: > > Dear Sharma Ji, > "Merry Christmas" > > Attached i

Re: $$Excel-Macros$$ Help required on cell movement

You are welcome..!! "Merry Christmas" 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/24/09, Sachin Shukla wrote: > > Dear Dilip, > > Thanks a lot. > > > Sachin Shukla > > > On Thu, Dec 2

Re: $$Excel-Macros$$ Help required on cell movement

Dear Sachin, "merry christmas" Attached file has been solved / customised as per your needs. Thanks. 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/24/09, Sachin Shukla wrote: > > Dear A

$$Excel-Macros$$ Help required on cell movement

Dear All, Please help me on attached file. Thanks in advance Sachin Shukla -- -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.c

Re: $$Excel-Macros$$ Help Required!

Hi Dilip, Good Afternoon! I just wanted to follow up with the below email. Any updated on this sir? Thanks & Regards, Sharma On 12/21/09, amrahs k wrote: > > Dear Dilip, > > Yes. Please go ahead with the revised solution since it looks perfect. > > Good job sir. Thanks a lot for your efforts.

Re: $$Excel-Macros$$ Help Required!

Dear Dilip, Yes. Please go ahead with the revised solution since it looks perfect. Good job sir. Thanks a lot for your efforts. Regards, Sharma On Mon, Dec 21, 2009 at 8:01 PM, Dilip Pandey wrote: > Dear SharmaJi. > > Attached is the revised solution for you with action item at your end. > >

Re: $$Excel-Macros$$ Help Required in Excel Roster

Hems, Basically there are hidden helper columns and rows that do some of the calculations. One of the hidden rows counts how many changes from Sunday to Monday. Then the OFFSET function was used to access this calculation that dictate the correct offset. A formula with several IF functions were us

Re: $$Excel-Macros$$ Help Required in Excel Roster

Norman, Dude its too gud Keep it up ... i wud lik learn all this ...how did u manage this?? Cheers! Hems On Thu, Dec 17, 2009 at 10:25 PM, Norman May wrote: > Hems, > > Attached is another version of your Roster. > > Norman > > On Tue, Dec 15, 2009 at 12:56 PM, Hems wrote: > >> Hello A

Re: $$Excel-Macros$$ Help Required in Excel Roster

Hey Norman, Amazing work... yup this is what i wanted ...appreciate if cud explain the logic ..in short.. Thanks a lot bro Cheers! Hems On Thu, Dec 17, 2009 at 6:26 AM, Norman May wrote: > Hopefully this is what you wanted. > > Norman > On Tue, Dec 15, 2009 at 12:56 PM, Hems wrote: > >>

$$Excel-Macros$$ Help Required in Excel Roster

Hello All, I have created excel roster but i am stuck with formula. I have mentioned all the information in the excel file. Appreciate if you'll help me to create automated roster for every month after inserting the shift for day 1 of the month. Attached file for further information. Thanks in

RE: $$Excel-Macros$$ Help required in repeating calculation using macro (This is urgent, can anyone help me)

Hi, Take a look at the attached to see if I have understood you correctly. Regards - Dave. Date: Fri, 4 Dec 2009 11:15:46 +0530 Subject: Re: $$Excel-Macros$$ Help required in repeating calculation using macro (This is urgent, can anyone help me) From: rfhyd1...@gmail.com To: excel-macros

Re: $$Excel-Macros$$ Help required in repeating calculation using macro (This is urgent, can anyone help me)

Here are a couple of questions I have: customer Billable% = Customer Billable hours/Potential hours (H17/ F17): what do you want to see in H17? I am afraid you are thinking SUM (H7:H16), but since all the values are percentages this simply makes no sense. Might it be possible that H17 should be G

Re: $$Excel-Macros$$ Help required in repeating calculation using macro (This is urgent, can anyone help me)

Hi, can you please tell me what additional information you need. Thanks, Bala On Thu, Dec 3, 2009 at 9:21 PM, RolfJ wrote: > I'd be happy to help, but would need a bit more information. > > Rolf Jaeger > SoarentComputing > http://soarentcomputing.com/SoarentComputing/ExcelSolutions.htm > > > On

Re: $$Excel-Macros$$ Help required in repeating calculation using macro (This is urgent, can anyone help me)

I'd be happy to help, but would need a bit more information. Rolf Jaeger SoarentComputing http://soarentcomputing.com/SoarentComputing/ExcelSolutions.htm On Dec 2, 4:52 am, bala Subrahmanyam puligadda wrote: > Hi ALL, > > Please help me in the repeating some calculations by using the macro. > >

$$Excel-Macros$$ Help required in repeating calculation using macro (This is urgent, can anyone help me)

Hi ALL, Please help me in the repeating some calculations by using the macro. Please find the attachment. the following are the details for that we have to do calculation on the Employee Summary Rep tab. Please look into A17 row i.e., the subtotal for Organisation name ABC now what we have to d

Fwd: $$Excel-Macros$$ Help required in repeating calculation using macro (This is urgent)...

Can any one help me...I need this very urgent.. Thanks... -- Forwarded message -- From: bala Subrahmanyam puligadda Date: Sat, Nov 28, 2009 at 12:00 PM Subject: $$Excel-Macros$$ Help required in repeating calculation using macro To: excel-macros@googlegroups.com Hi ALL

$$Excel-Macros$$ Help required in repeating calculation using macro

Hi ALL, Please help me in the repeating some calculations by using the macro. the following are the details for that we have to do calculation on the Employee Summary Rep tab. Please look into A17 row i.e., the subtotal for Organisation name ABC now what we have to do is to calculate the sum of

$$Excel-Macros$$ help required in inserting multiple rows together

Hi friends, > > Can any body help me in this i want to insert rows between alternate rows > > for example > > Row No. > > sr. no. > > name > > 10 > > 1 > > sachin > > 11 > > 2 > > piyush > > 12 > > 3 > > amit > > 13 > > 4 > > pankaj > > 14 > > 5 > > hitendra > > > I want it to be > > Row No. > > s

$$Excel-Macros$$ Help required. from vertical to horizontal swapping

Dear All, I have vertical col A ,c and f which contains cell value upto 5000. i.e A1:A5000,C1:C5000,F1:F5000 RESPECTIVELY. I want to copy C1:C8 cell value to another sheet i.e (sheet1) in a row manner. i.e copied cell paste into sheet 1 range M7 to T7 cell.( Total eight cell in a row.)Then anoth

$$Excel-Macros$$ help required

hello frds i am stuck in this problem. I made one distance matrix table sheet. i attached in this mail i am not able to make a VBA code for following problem 1. 4 -5 cities i write in column 1 will automatically comes in horizontal line of sheet 1, The cities which i write in column 1,that cit

$$Excel-Macros$$ Help Required

Hi, Iam a regular user of this group, and some of the tips have helped me a lot in my regular work, as my work also is excel based. I have a little concern. I need to sum up data from different sheets into a master, using 2 or 3 different criteria...Iam unable to do this at the moment...Can any o

$$Excel-Macros$$ help required

Dear all, Any one can help w.r.t copy from subjects of column cells to row cells,by just dragging or in no time, please for reference see attached file, -- Thanks & Regards Shivashankar.C.Katageri. --~--~-~--~~~---~--~~ -

$$Excel-Macros$$ Help required to modify vb code

Dear All i herewith attach the code to send row of excel through outlook, i have modify it as per my requirement but the body of mail not get draft as per the code it should be Dear (Cell value A) Line 1 Line 2 Line 3 Table (mean row of Excel sheet) Line 4 but when i run the macro mail draf

$$Excel-Macros$$ Help Required

Dear All, Please help me on attached sheet. Thanks Sachin Shukla --~--~-~--~~~---~--~~ - Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add

$$Excel-Macros$$ Help Required - Urgently

Hello everyone, I am facing a problem and would appreciate your advise on the same. I have an excel file in which i have put Data Validation - List in one column (for example - Col A). Now, i want another list in the other column (for example 0 Col B) to be refreshed automatically whenever the se

$$Excel-Macros$$ Help required

Hi, See the attached solution. I used array formulas to identify which company should be excluded. regards! 2009/6/3 Sachin Shukla > Dear All, > > Please help me on analysis of different senarion. details question and > sheet attached. > > > Thanks > > Sachin Shukla > > > > -- Fabio Lemos e

<    1   2   3   4   5   >