Re: $$Excel-Macros$$ Need help on dynamic list

Hi, Please find the attached solution. In sheet one I have two validation lists, which is taking data from Sheet2. Sheet2 has named ranges. Hope this will help you. With the help of Named Range and Indirect formula you can do this very easily. Regards, Deepak Rai On Wed, Dec 8, 2010 at 7:33 PM

Re: $$Excel-Macros$$ Need help on Excel Dynamic List

You are welcome Sharat. Best Regards, DILIPandey On 12/8/10, Sharath Sambrani wrote: > Fantastic!!! > > Thanks a ton Dilip! > > Sharath > > -- Forwarded message -- > From: Dilip Pandey > Date: Wed, Dec 8, 2010 at 8:43 PM > Subject: Re: $$Exc

Re: $$Excel-Macros$$ Need help on Excel Dynamic List

Hi Sharath, Please check the attached file which has the resolution as per your requirements. :) Best Regards, DILIPandey On Wed, Dec 8, 2010 at 7:38 PM, Sharath Sambrani < sharath.c.sambr...@gmail.com> wrote: > Hi, > > I have two columns A and B. > > column A contains list of tasks and column

Re: $$Excel-Macros$$ Need help on excel sheet

-Macros$$ Need help on excel sheet To: excel-macros@googlegroups.com Date: Wednesday, December 1, 2010, 12:15 AM No,  I have different data (place wise) in 5 tabs, my expectation is that wile pasting the raw data in the first sheet , it should divide the data as per the region or place wise in

Re: $$Excel-Macros$$ Need help on excel sheet

No, I have different data (place wise) in 5 tabs, my expectation is that wile pasting the raw data in the first sheet , it should divide the data as per the region or place wise in the remaining sheet and that needs to be seperated in different individual sheet in my desktop or in a different file

Re: $$Excel-Macros$$ Need help on excel sheet

Hello,   Do you mean that you want to collect the data on all 5 sheets and add it to a 6th sheet and then save the workbook with all 6 sheets? Or do you need to take the data from the 5 sheets and put it on one sheet, then saving a new workbook with only one sheet?       --- On Tue, 11/30/10, Man

Re: $$Excel-Macros$$ Need Help Very Very Urgent...

Hey Daniel, Thank you very much On Nov 22, 8:24 pm, "Daniel" wrote: > Hello, > > With Application.CommandBars(1) >     .Controls(.Controls.Count).Delete > End With > > Regards. > > Daniel > > -Message d'origine- > De : excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com]

RE: $$Excel-Macros$$ Need Help Very Very Urgent...

Hello, With Application.CommandBars(1) .Controls(.Controls.Count).Delete End With Regards. Daniel -Message d'origine- De : excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] De la part de Sayyad1284 Envoyé : lundi 22 novembre 2010 05:44 À : MS EXCEL AND VBA MACROS

Re: $$Excel-Macros$$ Need help list box

> Dear Team, > > I need help with attached file. In this one column "Relay type", we select > any one item (need list box), its display all the corresponding details with > the title its show same sheet or display in another sheet. need urgent > please help. > Thanks in Advance. > -- > Regards, >

Re: $$Excel-Macros$$ Need help list box

Dear Mohammed Idhrees, Please find attach, i hope this is your requirement, i have done only for the 2 rows which are colored in yellow, if you wish you can copy paste and tak the values from the list. If this is not your requirement you can revert to the group for more help. Regards Ahmed Bawaz

Re: $$Excel-Macros$$ Need help list box

Hi, You can use Data Validation for this. Search Google or Excel Help you will get to know about this. Regards, Deepak On Sun, Sep 26, 2010 at 8:49 PM, Idhrees Mohamed wrote: > Dear Team, > > I need help with attached file. In this one column "Relay type", we select > any one item (need list b

Re: $$Excel-Macros$$ Need Help

Hi Friend, You can download Excel addins from www.diddb.com,www.vertex42.com, www.ozgrid.com,www.add-ins.com,www.ablebits.com,www.office-eccel.com etc. For creating excel add-ins you have to be proficient in VBA Coding,writing Macros and also you require knowledge of some excel events and applic

RE: $$Excel-Macros$$ Need help

Hi, Please see the attached. Regards - Dave Date: Tue, 7 Sep 2010 11:23:17 +0530 Subject: $$Excel-Macros$$ Need help From: rajputpanka...@gmail.com To: excel-macros@googlegroups.com Hi all i have a excel sheet need help, i wanted to use excel formula not pivot table or chat -- Warm Reg

Re: $$Excel-Macros$$ Need help

check the attachment Regards Ashish Koul 9953979291 *akoul*.*blogspot*.com *akoul*.wordpress.com My Linkedin Profile On Tue, Sep 7, 2010 at 11:23 AM, Pankaj Kumar wrote: > Hi all i

Re: $$Excel-Macros$$ Need help

Hi Please find the attached file. On Tue, Sep 7, 2010 at 11:23 AM, Pankaj Kumar wrote: > Hi all i have a excel sheet need help, i wanted to use excel formula not > pivot table or chat > > -- > *Warm Regards > Pankaj kumar > M: 9899816107 > e-mail: rajputpanka...@gmail.com >rajputpank

Re: $$Excel-Macros$$ Need help to convert date formate

Hi Vilas, Please find below the macro recorded by me... Sub Date_Format() ' ' Date_Format Macro ' Macro to convert date format- 8/29/2010 by Vinod ' Columns("A:A").Select With Selection Selection.TextToColumns Destination:=Range("A1"), DataType:=xlDelimited, _ TextQualifier:=

Re: $$Excel-Macros$$ Need help to convert date formate

Hi Vinod, Thank you very much, Vinod can you give me vba code for that issue Regards Vilas On Sat, Aug 28, 2010 at 9:11 PM, VILAS CHAVAN wrote: > Hi vinod, > > You are not sending me any attachment please send solve attachment please > > > > > > > > > > > > regards > Vilas > On Sat, Aug 28, 201

Re: $$Excel-Macros$$ Need help to convert date formate

Hi vinod, You are not sending me any attachment please send solve attachment please regards Vilas On Sat, Aug 28, 2010 at 12:26 PM, Vinod N wrote: > Hi Vilas, > Please select column A and use Text-to-Columns under Data menu... Next > choose the desired date format from Format--> Cells

Re: $$Excel-Macros$$ Need help to convert date formate

Oops Missed to attach the file... Now done... On Sun, Aug 29, 2010 at 12:56 AM, Vinod N wrote: > Hi Vilas, > > Please select column A and use Text-to-Columns under Data menu... Next > choose the desired date format from Format--> Cells option.. Solved copy of > your sample file attached... >

Re: $$Excel-Macros$$ Need help to convert date formate

Hi Vilas, Please select column A and use Text-to-Columns under Data menu... Next choose the desired date format from Format--> Cells option.. Solved copy of your sample file attached... Thanks Vinod N On Sat, Aug 28, 2010 at 7:20 PM, VILAS CHAVAN wrote: > Hi friends, > > Need help this is data

Re: $$Excel-Macros$$ Need help in consolidating different excel workbooks in to one work book

Hi Raj, I have copied the following from a site earlier (dont remember the URL) i had a requirement identical to yours Ensure that the consolidation master file(this macro is present) and the other files are saved in a single folder Other details are self explanatory Hope the below co

RE: $$Excel-Macros$$ Need help deleted column in excell sheet

Hi, Do you back-up regularly? If so, it may be in your back-up files. If not, then it is lost lost. Sorry. Regards - Dave. > Date: Fri, 27 Aug 2010 05:24:43 +0400 > Subject: $$Excel-Macros$$ Need help deleted column in excell sheet > From: idhrees...@gmail.com > To: excel-macros@googlegroups.

Re: $$Excel-Macros$$ Need help deleted column in excell sheet

In my opinion, data lost. On Fri, Aug 27, 2010 at 6:54 AM, Idhrees Mohamed wrote: > Dear guys, > > > > I have a excel sheet with big data. Its contain one date column > unfortunately I delete and save it. It’s possible to recover that > column. > > > > Thanks in Advance. > > > > Regards, > >

RE: $$Excel-Macros$$ Need Help in Cross tab

You're welcome. Regards - Dave. To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Need Help in Cross tab From: shariqcoo...@gmail.com Date: Sun, 22 Aug 2010 07:15:09 + Thanks Dave Thanks for your help.I have not checked the sheet coz I'm not on my lap

Re: $$Excel-Macros$$ Need Help in Cross tab

10 15:10:50 To: excel-macros@googlegroups.com Reply-To: excel-macros@googlegroups.com Subject: RE: $$Excel-Macros$$ Need Help in Cross tab Hi, I have re-done your sheet using VBA. It will accommodate as many rows as needed on the report sheet, and up to 10,000 rows on the DATA sheet (although

Re: $$Excel-Macros$$ Need Help in Cross tab

Sender: excel-macros@googlegroups.com Date: Sat, 21 Aug 2010 18:16:12 To: excel-macros@googlegroups.com Reply-To: excel-macros@googlegroups.com Subject: RE: $$Excel-Macros$$ Need Help in Cross tab Thanks Andy. You're welcome. Regards - Dave. Date: Sat, 21 Aug 2010 15:33:03 +0530 Subjec

Re: $$Excel-Macros$$ Need Help in Cross tab

: $$Excel-Macros$$ Need Help in Cross tab Hi Shariq I've done this with worksheet functions, not VBA. The original formula is in B3 on the Report sheet. It's then just copied down, then copied across. If you really need it in VBA, it can be done easily enough, but this way updates instantl

RE: $$Excel-Macros$$ Need Help in Cross tab

Thanks Andy. You're welcome. Regards - Dave. Date: Sat, 21 Aug 2010 15:33:03 +0530 Subject: Re: $$Excel-Macros$$ Need Help in Cross tab From: aind...@gmail.com To: excel-macros@googlegroups.com Hey Dave, This is great!! you never stop amazing me with your simple solutions to co

Re: $$Excel-Macros$$ Need Help in Cross tab

Hey Dave, This is great!! you never stop amazing me with your simple solutions to complex problems.. Keep it up man!! You are a pillar of our group... Cheers!!! Andy On Sat, Aug 21, 2010 at 2:45 PM, Dave Bonallack wrote: > Hi Shariq > I've done this with worksheet functions, not VBA. > The ori

RE: $$Excel-Macros$$ Need help with a formula

Much appreciated! I am upgrading next week! From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] On Behalf Of Dave Bonallack Sent: Friday, August 20, 2010 9:04 AM To: excel-macros@googlegroups.com Subject: RE: $$Excel-Macros$$ Need help

RE: $$Excel-Macros$$ Need help with a formula

Thanks, Michael! -Original Message- From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] On Behalf Of Michael Hayes Sent: Thursday, August 19, 2010 2:37 PM To: MS EXCEL AND VBA MACROS Subject: Re: $$Excel-Macros$$ Need help with a formula Beckie or is it Becky

Re: $$Excel-Macros$$ Need help with a formula

> ____________ > > From: excel-macros@googlegroups.com > [mailto:excel-mac...@googlegroups.com] On Behalf Of Dave Bonallack > Sent: Thursday, August 19, 2010 12:27 AM > To: excel-macros@googlegroups.com > Subject: RE: $$Excel-Macros$$ Need help with a

RE: $$Excel-Macros$$ Need help with a formula

-macros@googlegroups.com Subject: RE: $$Excel-Macros$$ Need help with a formula Hi Becky, If XL has put NA in a cell, you must already have a formula there. You'll need to send a sample workbook so we can see get the whole picture. Regards - Dave. > Date: Wed, 18 Aug 2010 12:15:30 -0700 &

Re: $$Excel-Macros$$ Need help with a formula

As dave said, there is a formula in column Click on the formula. Carefully copy the formula except '=' symbol type the following in the same cell. =iserror(FORMULA, 0, FORMULA) Replace the FORMULA with the copied formula Regards, Kishan Reddy, K On Aug 19, 9:27 am, Dave Bonallack wrote: > Hi

RE: $$Excel-Macros$$ Need help with a formula

Hi Becky, If XL has put NA in a cell, you must already have a formula there. You'll need to send a sample workbook so we can see get the whole picture. Regards - Dave. > Date: Wed, 18 Aug 2010 12:15:30 -0700 > Subject: $$Excel-Macros$$ Need help with a formula > From: rebecca.math...@kraft.co

Re: $$Excel-Macros$$ Need Help

Hi I have responded to your email sent before pl chk and see if this is what u wanted Regards, Andy On Thu, Aug 5, 2010 at 9:48 AM, prabhakar thakur wrote: > Hi All, > Please help. > > Thanks, > Prabhakar Thakur > New Delhi > +919953736776 > > > > On Wed, Aug 4, 2010 at 10:49 PM,

Re: $$Excel-Macros$$ Need help

Yes sir Sent on my BlackBerry® from Vodafone -Original Message- From: Vasant Sender: excel-macros@googlegroups.com Date: Wed, 28 Jul 2010 15:27:53 To: Reply-To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Need help Do u want the data in ms-word as a paragraph ? On 7

Re: $$Excel-Macros$$ Need help

Do u want the data in ms-word as a paragraph ? On 7/28/10, madha...@yahoo.com wrote: > Dear expert > I have some data stored in excel sheet and I wanted to convert the same in > paragraph form can I know how can I convert the same in paragraph form. > > Warm regards > > Madhav Vyas > Sent on my B

Re: $$Excel-Macros$$ Need help with a lookup

We will have to add one more column in Extracted data sheet to concatenate Area & ID. If it is fine then it is easy. Otherwise I do not have solution. Regards, Mathan On Wed, Jun 30, 2010 at 6:09 AM, Nadine S wrote: > The attached file is a sample of my data. I need to write a formula in

Re: $$Excel-Macros$$ Need help on CONCATENATE and SUM function

Hi, You can modify your formula as =CONCATENATE("FY09-Q4",CHAR(10)," (",TEXT(SUM(A2:A4),"0,000"),")") . Regards, Deepak On Tue, Jun 8, 2010 at 8:31 PM, Sharath Sambrani < sharath.c.sambr...@gmail.com> wrote: > thanks Paul, > > it worked amazingly! > > :) > > On Tue, Jun 8, 2010 at 8:19 PM, P

Re: $$Excel-Macros$$ Need help on CONCATENATE and SUM function

the =Text() function diplays numbers in different formats. replace your Round() function with: text(round(sum(a2:a4),0),"#,###") =CONCATENATE("FY09-Q4",CHAR(10)," (",TEXT(ROUND(SUM(A2:A4),0),"#,###"),")") curiously enough, you SHOULD be able to use: ="FY09-Q4" & CHAR(10) & " (" & TEXT(ROUND(SU

Re: Re: $$Excel-Macros$$ Need Help

Hi Group, No success with the problem yet. Anyone else care to take a stab at it ? Thanks. On May 26, 2010 10:06pm, Bill Q wrote: Thanks for the effort Saggi. It is appreciated. Unfortunatly, it seems that I am guilty of not being specific enough.Here is what I need step by step:

Re: $$Excel-Macros$$ Need Help

mail me xl @ ...realsa...@gmail.com On Thu, May 27, 2010 at 7:36 AM, Bill Q wrote: > Thanks for the effort Saggi. It is appreciated. > > Unfortunatly, it seems that I am guilty of not being specific > enough.Here is what I need step by step: > > 1. We start on this URL : > http://contests.co

Re: $$Excel-Macros$$ Need Help

Thanks for the effort Saggi. It is appreciated. Unfortunatly, it seems that I am guilty of not being specific enough.Here is what I need step by step: 1. We start on this URL : http://contests.covers.com/Handicapping/topHandicappers.aspx?sportid=1 2. This page defaults to record 1 through 50. 3.

Re: $$Excel-Macros$$ Need Help

Use those code : Sub Combine() Dim J As Integer On Error Resume Next Sheets(1).Select Worksheets.Add ' add a sheet in first place Sheets(1).Name = "Combined" ' copy headings Sheets(2).Activate Range("A1").EntireRow.Select Selection.Copy Destination:=Sheets(1).

Re: $$Excel-Macros$$ Need help in automating this report

Hi Girish, Thanks a ton for working on this report. You are great. You have made my day. Thanks & Regards, Yogesh On May 20, 10:21 am, girish naik wrote: > Hi Mate your work is done. > > Please check if this meets your requirement.. > > Click on the button which is on Document map sheet to Gen

Re: $$Excel-Macros$$ Need Help for Macro or Formula

Enter Following Formula in Cell D2 =IF(C2="Paid","Process",IF(C2="","",("Not to Process"))) Regards Jagjeet SIngh On May 14, 8:55 pm, Mahesh parab wrote: > Dear All > > for attach sheet i need formula or macro, I will appreciate any help on > this. > 1.if for code in column A ,status in colum

Re: $$Excel-Macros$$ Need Help for Macro or Formula

Thanks Harry i want formula for Column D. the formula what i have mention in email needs to be enhance or change 1. if for code in column A, status in column C is Paid,Not Paid,Awaiting then Final Status should be Not to process in column D 2. if for code in column A, status in column C is only

Re: $$Excel-Macros$$ Need Help for Macro or Formula

check the sheet. On Fri, May 14, 2010 at 9:25 PM, Mahesh parab wrote: > Dear All > > for attach sheet i need formula or macro, I will appreciate any help on > this. > 1.if for code in column A ,status in column C is paid then D column status > should be process > 2.if status in column C is n

RE: $$Excel-Macros$$ Need Help to pickup Rate List for formula

Thanks for reply. With Regards, Hitesh. From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] On Behalf Of ashish koul Sent: Thursday, May 06, 2010 3:55 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Need Help to

Re: $$Excel-Macros$$ Need Help to pickup Rate List for formula

ent in the > solution > > provided? > > > > > > > > 'Inv for Rate'!D8 > > > > > > > > With Regards, > > > > Hitesh > > > > > > > > From: excel-macros@googlegroups.com [mailto: &g

Re: $$Excel-Macros$$ Need Help to pickup Rate List for formula

59 PM > To: excel-macros@googlegroups.com > Subject: Re: $$Excel-Macros$$ Need Help to pickup Rate List for formula > > > > check the attachment > > On Wed, May 5, 2010 at 6:56 PM, vidyut more wrote: > > I have at

RE: $$Excel-Macros$$ Need Help to pickup Rate List for formula

y 05, 2010 10:59 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Need Help to pickup Rate List for formula check the attachment On Wed, May 5, 2010 at 6:56 PM, vidyut more wrote: I have attached sample file. I want formula for picking up rate from excel sheets. Thanks

Re: $$Excel-Macros$$ Need Help to pickup Rate List for formula

You can use both Hlookup and match to solve your problem, try using this formula in the E8 cell: =HLOOKUP(D8,IF(B8="Party1",Party1!2:180,IF(B8="Party2",Party2! 2:180,IF(B8="Party3",Party3!2:180,0))),IF(B8="Party1",MATCH(C8,Party1! A:A,0)-1,IF(B8="Party2",MATCH(C8,Party2!A:A, 0)-1,IF(B8="Party3",MAT

Re: $$Excel-Macros$$ Need Help

copy the data of column A, right click from mouse. there is an option "paste special". Click on it & tick on transpose, and press ok. Naveen On 4/28/10, balbirkumar . wrote: > > Dear Friends, > > > > > I want to arrange the series of data in a coloum to series of row. For > example > > > > Data

Re: $$Excel-Macros$$ Need Help

thanks a lot, 4 immediate reply,,,friends On 29 April 2010 10:53, rf1234 rf1234 wrote: > Hello Dear, > Have a look on attached Vedio. > > > > > > > > > On Wed, Apr 28, 2010 at 5:20 PM, balbirkumar . wrote: > >> Dear Friends, >> >> >> I want to arrange the series of data in a coloum to series

Re: $$Excel-Macros$$ Need Help

USe transpose... Select from A1 to A4,,,--> Copy...--> Select cell A1 and then right clickuse paste special...check transpose and then press ok On Thu, Apr 29, 2010 at 10:53 AM, rf1234 rf1234 wrote: > Hello Dear, > Have a look on attached Vedio. > > > > > > > > > On Wed, Apr 28, 2010 at

Re: $$Excel-Macros$$ Need Help

Dear Balbir, copy the respective data and press popup key in your keyboard, then s then e and press Enter. (copy->paste special-> tanspose > Enter) :) Pivot table is also a good option to give a try. -- Thanks & Regards, DILIP KUMAR PANDEY MBA-HR,B.Com(Hons),BCA Mobile: +91 9810929744 dilipa

Re: $$Excel-Macros$$ Need Help

One way you can do is select and copy A1:A4 for exemple and click and A1 paste special -> Transpose, its in the left corner down, of copy special box. Try there. Lately you can create a macro that do this for you Best Regards André Luiz D´Avila 2010/4/28 balbirkumar . > Dear Friends, > > > I wa

Re: $$Excel-Macros$$ Need Help

Hi , You just copy on range a1:a4 and click on other blank cell then right click and select paste special , select value and transpose it can arrange series as you want. pls note that it can not paste on cell a1 because it was same cell that be copied. Hope it can help you. Worawat 2010/4/28

Re: $$Excel-Macros$$ Need Help

Dear Balbir, Copy the column values and in the destination wile pasting give it Paste Special - in paste special choose "Transpose" your task will be done. Let me know if you still need in detail the steps. This should solve your query On Wed, Apr 28, 2010 at 2:50 PM, balbirkumar . wrote: > D

Re: $$Excel-Macros$$ Need help to complete a Excel Model..

Hello Team, I got the code here http://www.atlaspm.com/faqxlselfclose.html could you please edit the same as to ful fil my requirements below. And it should pomp up msg box at 45 min sayin "This test will over in 15 min" lik that. Thanks. Vinu vinu wrote: > Hello Friends, > > I build a model

Re: $$Excel-Macros$$ Need help to complete a Excel Model..

Hi Paul, I got the code similar to this, but dont exatly how to edit this as per my requirements. http://www.atlaspm.com/faqxlselfclose.html As I said in the first post, once he clik on hyperlink(i.e., in 1st sheet), it will count till 60 Minutes, and before 15 min it shud remind him. after 60

Re: $$Excel-Macros$$ Need help to complete a Excel Model..

That's actually very tricky to do, and has all kinds of potential for circumventing it. The problem is that when VBA macros run, they usually have "control" of Excel. they don't run in "background". that means that a normal macro that runs and monitors the time wouldn't allow the person TAKING th

Re: $$Excel-Macros$$ Need help in function

Paul your solution is working fine thanks, i always get to learn something new from this group Thanks to all On Wed, Apr 7, 2010 at 9:07 AM, ashish koul wrote: > hi > > > yes to avoid making it text u an got right click on cell -> format -> > cutom format -> [mm] > > On Tue, Apr 6, 2010 at

Re: $$Excel-Macros$$ Need help in function

hi yes to avoid making it text u an got right click on cell -> format -> cutom format -> [mm] On Tue, Apr 6, 2010 at 11:36 PM, paulwillekens < paul.johan.willek...@gmail.com> wrote: > Hi Gaurav, > > Did you try my solution? =(D3 - C3) * 24 * 60 > What's wrong about that? The result remains num

Re: $$Excel-Macros$$ Need help in function

Hi Gaurav, Did you try my solution? =(D3 - C3) * 24 * 60 What's wrong about that? The result remains numeric, while Ashish's solution becomes text! cu Paul Willekens -- -- Some important links for excel users: 1. F

Re: $$Excel-Macros$$ Need help in function

Hi, Ashish Koul is right. His formula is working prefectly fine. Superb Ashish. Cheers Gaurav Jain On Tue, Apr 6, 2010 at 10:44 AM, seema mba wrote: > Hi, > > I have attached your sheet with formula for finding the difference in > minutes. > > I have used the formula CONVERT. > If the CONVE

Re: $$Excel-Macros$$ Need help in function

Hi, I have attached your sheet with formula for finding the difference in minutes. I have used the formula CONVERT. If the CONVERT function is not available, install and load the Analysis ToolPak add-in. On the Tools menu, click Add-Ins. In the Add-Ins available list, select the Analysis ToolPak

Re: $$Excel-Macros$$ Need help in function

Dear sandeep, Please Find Attached File Thanks, Chandrabhan 2010/4/6 ╚►♥ѕαη∂єєρ♥◄╝ > > Hi All, > > I want to calculate difference between two date , but i want result > in minute's. > please suggest function, > Please find attached & if u r sending solved reply Please "CC" > sandeepxxxku...@gm

Re: $$Excel-Macros$$ Need help in function

Sandeep, Please check the attached file. I used a custom format of "[m]:ss" (without quotes). Remove ":ss" part if you don't want seconds. Is this what you want ? Best, AJ 2010/4/6 ╚►♥ѕαη∂єєρ♥◄╝ > > Hi All, > > I want to calculate difference between two date , but i want result > in minute'

Re: $$Excel-Macros$$ Need help in function

=TEXT(D5-C5,"[MM]") On Tue, Apr 6, 2010 at 10:06 AM, ashish koul wrote: > =TEXT(D5-C5,"[MM]") > > 2010/4/6 ╚►♥ѕαη∂єєρ♥◄╝ > > >> Hi All, >> >> I want to calculate difference between two date , but i want result >> in minute's. >> please suggest function, >> Please find attached & if u r sending

Re: $$Excel-Macros$$ Need help in function

=TEXT(D5-C5,"[MM]") 2010/4/6 ╚►♥ѕαη∂єєρ♥◄╝ > > Hi All, > > I want to calculate difference between two date , but i want result > in minute's. > please suggest function, > Please find attached & if u r sending solved reply Please "CC" > sandeepxxxku...@gmail.com > > > > -- > > Thanks & Regards: >

Re: $$Excel-Macros$$ need help

Hello Dear You can automate your excel workbook,according to need u can write code. If you are new then you can try to download from net. Some of the example are available here. http://www.excel-business-solutions.com/free_download.htm Please have a view of files,template which are uploaded by

Re: $$Excel-Macros$$ need help

yes. what do you want to automate. On Wed, Mar 31, 2010 at 11:47 PM, Shilpa Rao wrote: > HI > any automation tools getting graphs in excel or any other automation tools > in excel to get report or any free softwares to get report automated. > > > On Sat, Mar 20, 2010 at 2:47 PM, yogananda muthai

Re: $$Excel-Macros$$ need help

HI any automation tools getting graphs in excel or any other automation tools in excel to get report or any free softwares to get report automated. On Sat, Mar 20, 2010 at 2:47 PM, yogananda muthaiah < yogananda.mutha...@gmail.com> wrote: > Hi, > > Kindly specify your requirements for automating

Re: $$Excel-Macros$$ need help

Hi, Kindly specify your requirements for automating the reports. Regards Yogananda.Muthaiah Ph : 9731237267 On 3/19/10, Shilpa Rao wrote: > Hi, > > Do we have any tools to automate financial reports? > > > > -- > Regards, > Shilpa > > -- > --

Re: $$Excel-Macros$$ Need help for macro- changing cell value

Thank u so much Christopher ! On Fri, Feb 26, 2010 at 1:48 PM, Christopher Luka < christopher.l...@gmail.com> wrote: > See attached. > > > On Thu, Feb 25, 2010 at 7:06 AM, Mahesh parab wrote: > >> Dear All >> >> I need macro for when i open workbook, A1 cell value, will display 1 to 4 >> numbers

Re: $$Excel-Macros$$ Need help for macro- changing cell value

See attached. On Thu, Feb 25, 2010 at 7:06 AM, Mahesh parab wrote: > Dear All > > I need macro for when i open workbook, A1 cell value, will display 1 to 4 > numbers one by one, time interval should be 15sec. > i want this to create animation effects in pie chart, cell A1 is link with > data by

Re: $$Excel-Macros$$ Need Help

Once you change the mode of calculation in any file, Excel will use the same mode for all workbook opened subsequently. Have you tried changing the mode with opening a new blank workbook ? If you want to set automatic mode for a specific workbook as default you can use the following code in ThisW

Re: $$Excel-Macros$$ Need Help

Shiv, Are you doing homework for a class? or working on someone else's code? or reading a book? the use of [ ] is called "relative addressing" or using "Relative Addresses" so.. (r[-5]c:r[-1]c) is a range in the CURRENT column (c) and starting 5 rows above to 1 row above the designated cell So,

RE: $$Excel-Macros$$ Need Help

Regards, C.G.Kumar AMW-2 To: Imran , Please find attached Solution file . Hope it serves your purpose. Regards, C.G.Kumar From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] On Behalf Of Imran khan Sent: 07/February/2010 10:40 AM

Re: $$Excel-Macros$$ Need Help

Dear Imran Select A3 to A9 Data-> Text to Column-> Delimited-> other-> choose underscore and that will solve the issue. Sanjoy On Sun, Feb 7, 2010 at 10:40 AM, Imran khan wrote: > Dear Friends, > > Please help me for solution of attached file. I am stuck now and need your > help on this r

Re: $$Excel-Macros$$ Need Help

Thanks Ayush, This will help me lot and save my time also. Thanks a lot once again! you guys and Dilip are doing great job which is appreciated. Imran On Sun, Feb 7, 2010 at 8:54 AM, ayush jain wrote: > Dear Imran, > > Attached is the solution. Use MID function to separate the Text in > dif

Re: $$Excel-Macros$$ Need Help

You are most welcome :) On Sun, Feb 7, 2010 at 11:53 AM, Imran khan wrote: > Thanks Ayush, > > This will help me lot and save my time also. > > Thanks a lot once again! you guys and Dilip are doing great job which is > appreciated. > > Imran > > > > On Sun, Feb 7, 2010 at 8:54 AM, ayush jain wr

Re: $$Excel-Macros$$ Need Help

Dear Imran, Attached is the solution. Use MID function to separate the Text in different cells. Let us know if any further help is required. Best regards, Ayush Jain On Sun, Feb 7, 2010 at 10:40 AM, Imran khan wrote: > Dear Friends, > > Please help me for solution of attached file. I am stuck

Re: $$Excel-Macros$$ need help urgently from excel to word

hi ashish i dont know how to export data in the abovesaid format, taking my code as base other members can modify as per needlet see On 29/01/2010, ashish koul wrote: > thanks a lot bro ... but is it possible to make changes in it so that i can > get the result in in the format attched in

Re: $$Excel-Macros$$ need help urgently from excel to word

thanks a lot bro ... but is it possible to make changes in it so that i can get the result in in the format attched in word document in the first mail On Fri, Jan 29, 2010 at 4:34 PM, ankur wrote: > hi ashish > sorry for late reply > > plz check the attached file , this will help u ..u can

Re: $$Excel-Macros$$ need help urgently from excel to word

need help on this matter On Thu, Jan 28, 2010 at 6:47 PM, ashish koul wrote: > hi > > i have a list in excel file with company name website etc, information a > > > and want to put the same in word as i have given in the word format > > > please can anyone give me the vba coding for the same > >

Re: $$Excel-Macros$$ Need help in using multiple IF's in DO UNTILL LOOP

dude, sumproduct was there to verify the result , i had already changed the macro as per ur requirement, plz chk Thanks & Regards, Harmeet Singh Sent via BlackBerry Wireless On Thu, Dec 31, 2009 at 5:40 PM, Harmeet Singh wrote: > Hi Madhu, > > pfa file. > done some minor ch

Re: $$Excel-Macros$$ Need help on Validation

hi vinod now check this one On 12/23/09, Vinod N wrote: > Hi Ankur, > > When "Tamilnadu" is selected, the Hub validation is not working... all other > regions are working fine... Please check and revert.. > > A new learning about data validation Thanks a lott... > > Thanks > Vinod N > > On

Re: $$Excel-Macros$$ Need help on Validation

Hi Ankur, When "Tamilnadu" is selected, the Hub validation is not working... all other regions are working fine... Please check and revert.. A new learning about data validation Thanks a lott... Thanks Vinod N On Tue, Dec 22, 2009 at 3:44 PM, ankur wrote: > hi mahesh > > thanks for compli

Re: $$Excel-Macros$$ Need help on Validation

hi mahesh thanks for compliment On 12/22/09, Mahesh wrote: > Hi Ankur, > > Thanx a lot... > > jst a simple word for this is "AWESOME" > > > > On Tue, Dec 22, 2009 at 11:19 AM, ankur wrote: > >> hi mahesh >> >> check the sheet, your query has been solved >> On 12/22/09, Mahesh wrote: >> > Hi

Re: $$Excel-Macros$$ Need help on Validation

Hi Ankur, Thanx a lot... jst a simple word for this is "AWESOME" On Tue, Dec 22, 2009 at 11:19 AM, ankur wrote: > hi mahesh > > check the sheet, your query has been solved > On 12/22/09, Mahesh wrote: > > Hi Friends, > > > > Attached herewith is the excel sheet for ur kind consideration.

Re: $$Excel-Macros$$ Need help on Validation

Dear Mahesh Bisht, What i can suggest you is that make use of Pivot Tables for your data if you are familiar. Regards Ahmed Bawazir On Tue, Dec 22, 2009 at 6:53 AM, Mahesh wrote: > Hi Friends, > > Attached herewith is the excel sheet for ur kind consideration. > > Please help. > > -- > With Lo

Re: $$Excel-Macros$$ Need help on Validation

hi mahesh check the sheet, your query has been solved On 12/22/09, Mahesh wrote: > Hi Friends, > > Attached herewith is the excel sheet for ur kind consideration. > > Please help. > > -- > With Love, > Mahesh Bisht > > -- > ---

Re: $$Excel-Macros$$ Need help on Validation

Hi Mahesh, Didn't get what you want. Provide more details. Regards, Swapnil. On Tue, Dec 22, 2009 at 9:23 AM, Mahesh wrote: > Hi Friends, > > Attached herewith is the excel sheet for ur kind consideration. > > Please help. > > -- > With Love, > Mahesh Bisht > > -- > >

Re: $$Excel-Macros$$ need help in excel

This info helped me too. On Tue, Dec 15, 2009 at 1:24 PM, vinod rao wrote: > Thank you for all of my excel experts. > > On Wed, Dec 2, 2009 at 1:50 PM, Shilpa Rao wrote: > >> Hi Friends, >> >> I have 2 excel file having 12 sheets in it, what I want is to merge two >> file into one. I tried usi

Re: $$Excel-Macros$$ need help in excel

Thank you for all of my excel experts. On Wed, Dec 2, 2009 at 1:50 PM, Shilpa Rao wrote: > Hi Friends, > > I have 2 excel file having 12 sheets in it, what I want is to merge two > file into one. I tried using move or copy but it din't work. Is there any > method. Please not that i have formula

Re: $$Excel-Macros$$ need help in excel

e > > Hi Shilpa, > > Just to add to Mahesh's email .. this will work if you open both Excel > workbooks in the same Excel 'window'. > > Thanks, > > Amitabh > > ------ > Date: Wed, 2 Dec 2009 17:00:52 +0530 > Subject: R

<    2   3   4   5   6   7   8   >