Re: $$Excel-Macros$$ Please help to make my project good.

Hi check whether attach file helps. On Wed, May 11, 2011 at 3:51 PM, karan 1237 wrote: > Respected Sirs/Mam, > > I need your help making my project good. Please find attachment. I will be > very obliged if someone can help me as earlier as possible. > > -- > Basically I have to do that

Re: $$Excel-Macros$$ Please help to make my project good.

please check the attachment if it helps.. best regards, STDEV(i) note: we need dynamic* Max Value* of ScrollBar so we use Scroolbar from ActiveX Control, instead of from FORM. A little macro wil work each time you change the "career" On Wed, May 11, 2011 at 5:21 PM, karan 1237 wrote: > Resp

Re: $$Excel-Macros$$ Calculate Due dates

Got it ashish bhayya..thanks a lot.played with the formula and got the desired result.. Thanks a lot. On Wed, May 11, 2011 at 8:37 PM, Mr excel wrote: > what i meant is instead of the period,the formula is showing as a result > the formula should return only the month with the year. > For exampl

Re: $$Excel-Macros$$ Calculate Due dates

what i meant is instead of the period,the formula is showing as a result the formula should return only the month with the year. For example,*05-Apr-2011 TO 04-May-2011*. should return apr'2011. hope this is not confusing you...ashish... On Sat, May 7, 2011 at 1:25 PM, ashish koul wrote: > >

$$Excel-Macros$$

Dear Experts, I am typing Name and place name day 2 day different excel files, what is easy method i type these names and place names. -- J.Mohilal Universal Computer Systems # 16, Brindavan Complex Otteri, Vellore-2 -- -

$$Excel-Macros$$ A macro to parse a wordlist in Excel

Hi to all VBA gurus, I need help with an Excel macro which can do the following: I have a long list of dictionary headwords in column A (sorted alphabetically), something like this: abnormal termination abnormal abort about absolute absolute address absolute code accent access access address acc

$$Excel-Macros$$ Please help to make my project good.

Respected Sirs/Mam, I need your help making my project good. Please find attachment. I will be very obliged if someone can help me as earlier as possible. -- Basically I have to do that when I click on drop down list & select another career i.e. Building and Construction so In sub career

$$Excel-Macros$$

Hi I have following code for filtering It works fine but the problem is in red font color code, this field is date field & when I put this it gives wrong information May be because of data type conversion problem can any one correct this code for date data type field... Thanks Pr

Re: $$Excel-Macros$$ .Refresh Background:-False

Thanks Ashish. It helped Sent from my iPhone On May 9, 2011, at 2:53 AM, ashish koul wrote: > see if it helps > > CODE: > With ActiveSheet.QueryTables.Add(Connection:=Array(Array( _ > > "ODBC;DSN=PP;UID=ris;PWD=ri;DBQ=PP;DBA=W;APA=T;EXC=F;FEN=T;QTO=T;FRC=10;FDL=10;LOB=T;RST=T;GDE=F;FR

Re: $$Excel-Macros$$ Total of sum of Diff. criteria according to date

Thanks very much Ashish Ji & Zafar Regds ROHAN On Tue, May 10, 2011 at 9:30 PM, ashish koul wrote: > to find total --- > > > =INDEX($C$12:$K$12,0,MATCH($N$2,$C$2:$K$2,0)) > > > > > On Tue, May 10, 2011 at 5:39 PM, Rohan Young wrote: > >> Thanks Ashish Ji, >> >> as i knew that i will g

Re: $$Excel-Macros$$ How to start Excel-Macro

Thanks for reply Sir... On Tue, May 10, 2011 at 6:21 PM, rajan verma wrote: > Hi pramod, > its good you have joined this group.. First of all try to record macro and > understand abt Excel Object and Their Property.. you can take help from > Ozgrid.com and MrExcel.com.. these are very Good T