RE: $$Excel-Macros$$ Replacing a specific tag/text based on a value

2010-09-18 Thread Dave Bonallack
Hi, The answer to all your questions is Yes. But what we need in order to offer specific help, is a framework - at least a sort of skeleton of a workbook, with as much info as you know how to put in. From there, we can probably help you little by little. Regards - Dave. > Date: Fri, 17 Sep

$$Excel-Macros$$ Re: Help Excel alert

2010-09-18 Thread Kishan Reddy, K
Mr Rasheed, We can write a macro such that can pass through number of dates, compare with the current date and return the details of the bills to be paid today in a message box. Regards, Kishan Reddy, K On Sep 17, 9:46 pm, Abdul Rasheed wrote: > HI > > Can any one have idea how to build particu

$$Excel-Macros$$ Question about list box

2010-09-18 Thread neil johnson
Hi Sir, - *I am not understanding that Code : When I use listbox.value it shows index number like 0 in excel sheet. While When I use listbox.list(listindex) display the value correctly. * *What is difference between them. * Thanks and Regards -- -

$$Excel-Macros$$ Need Help

2010-09-18 Thread rajasekhar praharaju
Hi friends, Dear Adorable group... please share if any one of us are having excel addin's . Moreover i am having query regarding the excel addin's. Can any one suggest how to create the excel addins i just tried creating this addins . but could not use properly. Thanks for your help in advance.

Re: $$Excel-Macros$$ Hi

2010-09-18 Thread siti Vi
you have to send your posting from your email-client, not from the group web. On Thu, Sep 16, 2010 at 4:03 PM, dinoabeer wrote: > > Can somebody help. I m a newbie here. how do I upload I file when I > post something> -- -

$$Excel-Macros$$ Stock Monitoring from Raw data

2010-09-18 Thread Kal xcel
Dear Experts, I am facing a problem to lookup data from another sheet. Please help me. Details is in attached file. Thanks in advance Kalyan -- -- Some important links for excel users: 1. Follow us on TWITTER for

$$Excel-Macros$$ Help: Date to Days conversion

2010-09-18 Thread janet dickson
Hi Team, I have challenge, see attached file. I want to see days instead of dates Hugs en Love -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exc

Re: $$Excel-Macros$$ Help: Date to Days conversion

2010-09-18 Thread Aindril De
Hi Janet, This can be possible if you have the dates in proper date format. >From the data it seems that the dates are not in the proper format. If you can enter the dates in a consistent format, then you can easily use the following formula in Column C to get the days =DATEDIF(A2,B2,"d") - Paste

Re: $$Excel-Macros$$ Stock Monitoring from Raw data

2010-09-18 Thread Aindril De
You can use a pivot Table to resolve this issue On Sat, Sep 18, 2010 at 4:16 PM, Kal xcel wrote: > Dear Experts, > > I am facing a problem to lookup data from another sheet. Please help me. > > Details is in attached file. > > Thanks in advance > > Kalyan > > -- > > -

Re: $$Excel-Macros$$ Help: Date to Days conversion

2010-09-18 Thread Vinod N
Hi Janet, Please enter the date in Excel recognizable format i.e., mm/dd/ instead of dd/mm/. Then days can be calculated with the formula you have already entered. Thanks Vinod N On Sat, Sep 18, 2010 at 1:48 PM, janet dickson wrote: > Hi Team, > > I have challenge, see attached file. I

Re: $$Excel-Macros$$ Digest for excel-macros@googlegroups.com - 1 Message in 1 Topic

2010-09-18 Thread chinmay kamat
try using the today() function my friend On Sat, Sep 18, 2010 at 5:40 AM, > wrote: > Today's Topic Summary > > Group: http://groups.google.com/group/excel-macros/topics > >- Help Excel alert <#12b222dbf0801d3f_group_thread_0> [1 Update] > > Topic: Help Excel > alert

RE: $$Excel-Macros$$ Stock Monitoring from Raw data

2010-09-18 Thread Dave Bonallack
Hi Kalyan, Have a look at the attached. The solution I've come up with is rather cumbersome, but I couldn't think of how to shorten it. Regards - Dave. Date: Sat, 18 Sep 2010 16:16:27 +0530 Subject: $$Excel-Macros$$ Stock Monitoring from Raw data From: kalx...@gmail.com To: excel-macros@goo

Re: $$Excel-Macros$$ Stock Monitoring from Raw data

2010-09-18 Thread Vinod N
Hi Kalyan, Please find attached the solution. Thanks Vinod On Sat, Sep 18, 2010 at 4:16 PM, Kal xcel wrote: > Dear Experts, > > I am facing a problem to lookup data from another sheet. Please help me. > > Details is in attached file. > > Thanks in advance > > Kalyan > > -- > >

Re: $$Excel-Macros$$ Help: Date to Days conversion

2010-09-18 Thread ALAM
dear all plz find an enclosed files aftab ali On Sat, Sep 18, 2010 at 5:00 PM, Vinod N wrote: > Hi Janet, > > Please enter the date in Excel recognizable format i.e., mm/dd/ instead > of dd/mm/. Then days can be calculated with the formula you have already

$$Excel-Macros$$ Data Browse VB Component

2010-09-18 Thread Nurdin Budi Mustofa
You are having difficulty in making the program in VB on the input data in table form or grid or browse, like in Excel application? We have the solution, you simply download the component and its source code examples on the following link: http://www.ziddu.com/download/11588429/LogicsDataBrowse.zi

$$Excel-Macros$$ copy, Paste macro needed

2010-09-18 Thread SUJAL AGARWAL
Hello All, Can someone write a macro for the following 1) If I have 10 files open. 2) copy from cell A3 to last but one row and copy till 'column U' 3)copy the whole data from 10 files, 4) paste in the new excel workbook one after the other 5) next for 'Column V' it should take the file name 6) a

$$Excel-Macros$$ Cubic spline interpolation macro in VBA

2010-09-18 Thread Pratik
Hi, Can anybody help me find VBA macro to perform cubic spline interpolation? -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join