$$Excel-Macros$$ Color base conditional formatting problem

Dear Sir / Madam, I have a problem while doing the color base conditional formatting please see the attachment suppose some of the criteria rows B4 become yellow. I want if b4 become yellow automatically the row of column d where c is written become yellow please help me. Regards thanking yo

$$Excel-Macros$$ regarding vlookup and wildcard function

Dear Sir / Madam, Please see the attachment and help me to solve the problem Thank you in advance Regards Sanjib -- - -- 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 forum @ https://www.facebook.com/di

$$Excel-Macros$$ Re: [XL-VBA Clinic] regarding vlookup and wildcard function

] > > > > > > *Bangalore | Delhi | **Gurgaon** | Hyderabad | Mumbai* > > > > *Awarded Runners up Asia Pacific Customer Relationship of the Year 2012-13 > by HROA* > > > > *From:* excelvbacli...@googlegroups.com [mailto: > excelvbacli...@googlegroups.

$$Excel-Macros$$ regarding not send any mail to Dinesh Kumar

It is jut a reply to your mail Mr Dinesh Kumar. why not sent any mail? My intention was not sent you any mail, as you are registered with the excel group the mail I sent the group automatically sent to you. As I am a member of the excel group I will send to group whenever I required, but If you

Re: $$Excel-Macros$$ regarding vlookup and wildcard function

t; HTH//Cheers > > > On Fri, May 9, 2014 at 2:02 PM, Sanjib Chatterjee < > chatterjee.kolk...@gmail.com> wrote: > >> Dear Sir / Madam, >> >> Here find the attachment, for your quick search i just hide the correct >> portion in the excel sheet >>

$$Excel-Macros$$ need some help from two tables

Dear Sir / Madam, Please see the attachment. There is two table marked with yellow and blue. Both tables has one common field that is Account Code. All the field is present in table yellow. But some field may or may have not present in table blue. I want If table blue Account code is matched

$$Excel-Macros$$ client wise dropdownlist in column b

Dear Sir / Madam, Please see the attachment. There could be thousand clients with their banks. I want wnen I put the client name in the column a, there will be dropdown list in the column B. All the bank name will be shown in the dropdown list of correspondence client name Thanking you in Adva

Re: $$Excel-Macros$$ client wise dropdownlist in column b

. Many many thank you. Please give another solution Thanking you in advance Sanjib On Mon, Jun 30, 2014 at 11:53 PM, Waseem Saifi wrote: > PFA > It might help you. > > > On Mon, Jun 30, 2014 at 4:17 AM, Sanjib Chatterjee < > chatterjee.kolk...@gmail.com> wrot

$$Excel-Macros$$ regarding international process

Dear Sir / Madam, Can anybody explain what is International Process and What kind of Jobs they are doing? -- - -- 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 forum @ https://www.facebook.com/discussexcel

$$Excel-Macros$$ Conditional format base on two criteria

Dear Sir / Madam, Please solve the attached excel sheet and please solve the problem Thanking you Sanjib Chatterjee -- - -- 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 forum @ https

$$Excel-Macros$$ CONDITIONAL FORMAT BASE OF TWO CRITERIA

Dear All Please see the attachment and solve the problem . Sanjib -- - -- 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 forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurat

Re: $$Excel-Macros$$ CONDITIONAL FORMAT BASE OF TWO CRITERIA

Abhishek Jain, Many Many thank you for solving the problem. But will great pleasure if you show me the step Regards, Sanjib On Fri, Jul 29, 2016 at 5:34 PM, Abhishek Jain wrote: > > > On Fri, Jul 29, 2016 at 4:13 PM, Sanjib Chatterjee < > chatterjee.kolk...@gmail.com> w

Re: $$Excel-Macros$$ CONDITIONAL FORMAT BASE OF TWO CRITERIA

thak you very much On Sat, Jul 30, 2016 at 1:55 PM, Abhishek Jain wrote: > Under Condition Formatting Tab, I have put 2 conditions. Please see under > Conditional Format > Manage Rules > > Screenshot attached. > > > > On Sat, Jul 30, 2016 at 12:55 PM, Sanjib Cha

Re: $$Excel-Macros$$ copy data from one sheet to other based on condition

Dear Jitendra Singh, I want automatically doing the task if match it will automatically copy data to other sheets. any help will be appreciated Sanjib Chatterjee On Tue, May 16, 2017 at 3:08 PM, Jitendra Singh wrote: > Use advance filter || > > Sent from BlueMail <http://www.blu

Fwd: $$Excel-Macros$$ copy data from one sheet to other based on condition

-- Forwarded message -- From: Sanjib Chatterjee Date: Tue, May 16, 2017 at 3:14 PM Subject: Re: $$Excel-Macros$$ copy data from one sheet to other based on condition To: excel-macros , jitendra kumar < jitendr...@gmail.com>, jeetexcelt...@gmail.com Dear Jitendra Singh,

Re: $$Excel-Macros$$ copy data from one sheet to other based on condition

Dear Mr Jitendra Singh, I want whenever I am doing entry in the master sheets it will copy the data to correspondence sheets. So, why do I need to delete the sheets every time. Hope Your will understand my problem. I need your help Thanking you in advance Sanjib Chatterjee On Wed, May 17

Fwd: $$Excel-Macros$$ Introduce Yourself !!

I am Sanjib Chatterjee, working in a stock broking firm, name Sunidhi securities and finance ltd,Kolkata, sa Bank office Mis executive. I get lot of support from the excel community whenever I need any help. I have a great passion of Excel. Hope You will continue supporting us. Thanking you

Re: Fwd: $$Excel-Macros$$ copy data from one sheet to other based on condition

he new sheets of JKM. if the person name is HM the the same rule will be follow. thouth Preeti Tomar, help me a lot of doing the project. But I got an error while running the vba code. Please help Thanking you SANJIB CHATTERJEE On Thu, May 18, 2017 at 5:28 PM, Paul Schreiner wrote: &

Re: Fwd: Fwd: $$Excel-Macros$$ copy data from one sheet to other based on condition

.bluemail.me/r?b=9660> > On 19 May 2017, at 1:19 PM, Sanjib Chatterjee < > chatterjee.kolk...@gmail.com> wrote: >> >> >> -- Forwarded message -- >> From: Sanjib Chatterjee >> Date: Fri, May 19, 2017 at 1:18 PM >> Subject: Re: Fwd: $$Exce

Fwd: Fwd: Fwd: $$Excel-Macros$$ copy data from one sheet to other based on condition

Thank you everyone I got the solution Many Many thank you for supporting me Sanjib Chatterjee -- Forwarded message -- From: 'Carmelita Cronin' via MS EXCEL AND VBA MACROS < excel-macros@googlegroups.com> Date: Fri, May 19, 2017 at 9:32 PM Subject: Re: Fwd: Fwd

$$Excel-Macros$$ for multiple condition to calculate A SIMPLE RESULT

uot;BNIS" IF Buy DATE " not equal to C/F" , BD = (B Value + S value) * .05% FOR THE OTHER PERSONS IT TAKES OTHER CALCULATION AL WELL I HOPE I MAKE YOU UNDERSTAND WHAT I WANT PLEASE HELP ME Thanking you in advance Sanjib Chatterjee -- - -- Are you =EXP(E:RT

Fwd: $$Excel-Macros$$ for multiple condition to calculate A SIMPLE RESULT

Sir / Madam, Please go through the mail and help Sanjib -- Forwarded message -- From: Sanjib Chatterjee Date: Sat, 8 Jul 2017 13:22:20 +0530 Subject: $$Excel-Macros$$ for multiple condition to calculate A SIMPLE RESULT To: excel-macros Dear Sir / Madam, Please see the

Fwd: $$Excel-Macros$$ for multiple condition to calculate A SIMPLE RESULT

please help -- Forwarded message -- From: Sanjib Chatterjee Date: Sat, Jul 8, 2017 at 1:22 PM Subject: $$Excel-Macros$$ for multiple condition to calculate A SIMPLE RESULT To: excel-macros Dear Sir / Madam, Please see the attachment and Please help me how to solve the

Re: Fwd: $$Excel-Macros$$ for multiple condition to calculate A SIMPLE RESULT

formula > > > BTW: in case you are unaware, Alt-Enter allows you to move part of the > formula to the next line, > allowing a long formula such as this to be easier to read! > > hope this helps. > > *Paul* > ----- > > > >

$$Excel-Macros$$ Fwd: [EXCEL-VBA CLINIC] Fwd: !! Happy New Year 2015 !!

happy new year and wish you all the best in life in 2015 -- Forwarded message -- From: pankaj soni Date: Thu, Jan 1, 2015 at 11:10 AM Subject: Re: [EXCEL-VBA CLINIC] Fwd: !! Happy New Year 2015 !! To: "Mr. YADAV" Cc: Suraj kumar bharti , xlvbaclinic < xlvbacli...@googlegroups.com>

Re: $$Excel-Macros$$ Re: Introduce Yourself !!

Dear All, I am Sanjib Chatterjee from Kolkata, West Bengal. I am Working in On Thu, Nov 13, 2014 at 3:19 PM, Vaibhav Joshi wrote: > Cheers Mandeep !! > On Nov 13, 2014 2:29 PM, "Mandeep Baluja" wrote: > >> Hello All, >> >> My name is Mandeep , I have be

$$Excel-Macros$$ need solution without vba function

Dear Sir / Madam, Please see the attachment and give a solution. is there any option without the vba function -- - -- 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 forum @ https://www.facebook.com/discusse

Fwd: $$Excel-Macros$$ need solution without vba function

-- Forwarded message -- From: Sanjib Chatterjee Date: Tue, Mar 3, 2015 at 2:51 PM Subject: $$Excel-Macros$$ need solution without vba function To: excel-macros , NOORAIN ANSARI < noorain.ans...@gmail.co>, NOORAIN ANSARI Dear Sir / Madam, Please see the attachment and

$$Excel-Macros$$ Fwd: Delivery Status Notification (Delay)

10.112.132.5 with HTTP; Tue, 3 Mar 2015 01:21:30 -0800 (PST) Date: Tue, 3 Mar 2015 14:51:30 +0530 Message-ID: < ca+rktjy5eehdfdj3cmz0fj9pgave7jyv2vj2jlq_2l5hqed...@mail.gmail.com> Subject: need solution without vba function From: Sanjib Chatterjee To: excel-macros , NOORAIN ANSARI < noorain.ans...

Re: $$Excel-Macros$$ Formula Needed Please

please check the attachment On Fri, Mar 13, 2015 at 11:58 AM, Will Sob wrote: > > Hi, > Please I need help with the attached file. I want a that calculates how > many times 10, 13, 17 has appeared within the range D5:I32 > > > > > > Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wan

$$Excel-Macros$$ cut option is disable in excel 2003

advance Sanjib Chatterjee -- - -- 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 forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like

Fwd: $$Excel-Macros$$ cut option is disable in excel 2003

Dear Sir / madam, Please help -- Forwarded message -- From: Sanjib Chatterjee Date: Mon, Jul 20, 2015 at 10:44 AM Subject: $$Excel-Macros$$ cut option is disable in excel 2003 To: excel-macros , excelvbacli...@googlegroups.com Dear Sir / Madam, I am using Ms Office 2003, When

Re: $$Excel-Macros$$ combo box or list box help

many many thank you N Ansary for you quick reply regards, Sanjib On Fri, Feb 17, 2012 at 2:02 PM, NOORAIN ANSARI wrote: > Dear Sanjib, > > Please find attachment in 2003 Version. > > On Fri, Feb 17, 2012 at 1:16 PM, Sanjib Chatterjee < > chatterjee.kolk...@gmail.com> w

Re: $$Excel-Macros$$ Rounding Numbers

Dear jayaprakash s, You can use the below mentioned formula ROUND(A1,-0.2) sanjib On Wed, Feb 22, 2012 at 1:04 PM, Jayaprakash S wrote: > Dear Experts, > > Good Noon. > > Need help on rounding up of numbers based on the decimal through a > formula... > > the criteria for roudning is : > > a) L

Re: $$Excel-Macros$$ how can i convert nomber to test

On Thu, Feb 23, 2012 at 9:06 AM, wrote: > Hi Team, pl help Ex :- 301 Ans :- Three hundread one rupees > > > Mail sent via way2sms. > > -- > FORUM RULES (986+ members already BANNED for violation) > > 1) Use concise, accurate thread titles. Poor thread titles, like Please

Re: $$Excel-Macros$$ how can i convert nomber to test

Vic Kumar, Please see the attachent On Sat, Feb 25, 2012 at 10:53 PM, Vic Kumar wrote: > Hi, > > Please advice i need this same macro for converting figures in words > for Rupees as this macro is working for Dollars only. > > Kindly help in this regard. > > Regards, > > Vikram > > > On 2/23/1

Re: $$Excel-Macros$$ Most Helpful Member Feb'12 - Noorain Ansari

Congratulation for you achievement. Hoping for a good luck. sanjib On Thu, Mar 15, 2012 at 4:19 AM, Ayush Jain wrote: > Hello Everyone, > > Noorain Ansari has been selected as 'Most Helpful Member' for the month of > Feb'12 > He has posted 156 posts in Feb'12 and helped many people through his

Re: $$Excel-Macros$$ Simple VBA to Fill in blanks

you can also assign the macro task 1 select column a 2 press f5 3 press special 4 select blank 5 ok 6 edit menue 7 press delete 8 shift cells up ok On Fri, Mar 23, 2012 at 7:04 AM, Jim Schug wrote: > Hi, > I'm nearly brain dead (tired) and can't think straight. I have a simple > issue. A macro

Re: $$Excel-Macros$$ regarding pivot table problem

Dear Mr. Sourbh Salgotra, I am already done it please check my attachment.. But I want rather differently which I mentioned. Thanking you Sanjib On Mon, Apr 9, 2012 at 5:28 PM, Sourabh Salgotra wrote: > plz check attachement > > On Mon, Apr 9, 2012 at 4:48 PM, Sanjib C

$$Excel-Macros$$ Fwd: regarding pivot table problem

Dear Experts, Would you please help me regarding the problem. Thanking you Sanjib -- Forwarded message -- From: Sanjib Chatterjee Date: Mon, Apr 9, 2012 at 4:48 PM Subject: regarding pivot table problem To: excel-macros Dear Sir, previously i sent you the mail. But I got

Fwd: $$Excel-Macros$$ Fwd: regarding pivot table problem

Dear Sir / Madam, I am facing a problem regarding pivot table. Please go through the mail . Waiting for your reply. Thanking you Regards, Sanjib -- Forwarded message -- From: Sanjib Chatterjee Date: Tue, Apr 10, 2012 at 10:24 AM Subject: $$Excel-Macros$$ Fwd: regarding

Re: $$Excel-Macros$$ regarding pivot table problem

yes, This is is excetly what I am looking for. would you explain please. regards, sanjib On Wed, Apr 11, 2012 at 12:45 PM, Shaik Waheed wrote: > Hi Sanjib, > > PFA check sheet 2. Hope this helps > > On Wed, Apr 11, 2012 at 10:54 AM, Sanjib Chatterjee < > chatterjee.kol

Re: $$Excel-Macros$$ regarding pivot table problem

e u can see i have added a formual "Net Quantity" >> = B- S. >> >> To add a formula u need to click on the items in the pivot >> -->Toolbar(above) --> formulas--> Calculate Item---> u can enter the >> required formula.. >> >> Hope i ex

Re: $$Excel-Macros$$ regarding pivot table problem

formulas ---> there u can see i have added a formual "Net Quantity" >> = B- S. >> >> To add a formula u need to click on the items in the pivot >> -->Toolbar(above) --> formulas--> Calculate Item---> u can enter the >> required formula.. >

Fwd: $$Excel-Macros$$ Format cells for Number

please check the attachment regards Sanjib -- Forwarded message -- From: Ashish Bhalara Date: Tue, Apr 17, 2012 at 11:56 AM Subject: $$Excel-Macros$$ Format cells for Number To: excel-macros@googlegroups.com Dear expert, Is there any formula to written in cells format for th

Re: $$Excel-Macros$$ Financial Analysis Dashboard

The file is blocking by the antivirous for suspecting virus. regds, Sanjib On Mon, Apr 30, 2012 at 10:07 PM, hilary lomotey wrote: > Hi Guys, > > i just completed my Financial Analysis Dashboard, pls have a look at it at > the address below > > cheers > > http://www.sendspace.com/file/tlim30 >

Re: $$Excel-Macros$$ Row to repeat at the bottom of each page

Dear Siraj Momin, please follow the steps 1. go to file 2. paresetup 3. choose sheets 4 rows to repeat at top ok regards, Sanjib On Thu, May 17, 2012 at 11:17 AM, Siraj Momin (BTG) wrote: > Dear Excel Group Friends > > ** ** > > Is there any way that certain rows of a sheet is repeated

Re: $$Excel-Macros$$ regarding font color based condition

world.blogspot.com > > > On Tue, May 29, 2012 at 1:54 PM, Sanjib Chatterjee < > chatterjee.kolk...@gmail.com> wrote: > >> Dear Sir / Madam, >> >> Please see the attachment. I have given you only 10 or 12 data. But >> there could have been more >> th

Re: $$Excel-Macros$$ regarding font color based condition

roworld.blogspot.com > > On Tue, May 29, 2012 at 3:23 PM, Sanjib Chatterjee < > chatterjee.kolk...@gmail.com> wrote: > >> Dear Nooranin Ansari, >> >> This is working fine. But would you explain the below mentioned >> formula. >> >> You have mention

Re: $$Excel-Macros$$ Need formula for Current Date Access

Dear Friend, Can you please send a formula how to use a FIFO method in MS ACCESS? Waiting for your reply Thanking you Sanjib On Thu, Jul 7, 2011 at 11:50 AM, ankur wrote: > * my pleasure > * > Have A Nice Time & Enjoy Life > > Regards: > CMA Ankur Pandey > (Someone Different) > > I'm not the

Re: $$Excel-Macros$$ Need formula for Current Date Access

Dear Friend, Would you please send a formula of MS Access regarding FIFO Thanking you Sanjib On Sat, Jul 9, 2011 at 12:46 PM, Sanjib Chatterjee < chatterjee.kolk...@gmail.com> wrote: > Dear Friend, > Can you please send a formula how to use a FIFO method in MS ACCESS? > >

Re: $$Excel-Macros$$ Convert Txt file into Excel into proper Columns

Open excel data=>import External Data = >select datasource=>select the appropriate option=>ok On Tue, Jul 12, 2011 at 8:22 AM, Susan 1 wrote: > Hi, > Need your help. How can I do this project faster than manually CTRL+ X , > then CTRL+ V , to delete and paste contact information into appropria

Re: $$Excel-Macros$$ Re: Can you please help regd. lists

This is excellent work. Would you please explain how you have done it. Your Formula Bar is showing nothing. Sanjib On Thu, Aug 11, 2011 at 12:58 AM, Haseeb Avarakkan < haseeb.avarak...@gmail.com> wrote: > Hello Naresh, > > See the attached. You can Add/Delete New/Old entries. > > HTH > Haseeb

Re: $$Excel-Macros$$ Export of Personal Macro Book

you can find it in personal.xls file in you system. Which is stays in \Microsoft Office\xlstart folder. copy it and paste in you new location On 8/16/11, Amit Desai (MERU) wrote: > Dear Masters, > > I am currently using a temporary laptop & in few days will receive another > one. I have created

$$Excel-Macros$$ ragarding FIFO METHOD in Ms Access

Dear Sirs, anybody please help regarding FIFO method in Ms Access 2003. Please see the attachment. I want the fifo method will continue automatically in Ms Access. I have mentioned only one scripts but there could be more than 100 scripts Thanking you in Advance Sanjib -- --

Fwd: $$Excel-Macros$$ ragarding FIFO METHOD in Ms Access

Dear Sir, Please go through the mail and help me. -- Forwarded message -- From: Sanjib Chatterjee Date: Fri, Aug 19, 2011 at 4:06 PM Subject: $$Excel-Macros$$ ragarding FIFO METHOD in Ms Access To: excel-macros Dear Sirs, anybody please help regarding FIFO method in Ms

Re: $$Excel-Macros$$ reference auto copy in shee2

x27; Macro10 Macro > ' > ' Keyboard Shortcut: Ctrl+r > ' > *If TypeName(Selection) = "Range" Then > Selection.Copy Sheets("Sheet2").Range("A" & > Sheets("Sheet2").UsedRange.Rows.Count + 1) > End If > * > En

Re: $$Excel-Macros$$ Run Macro at OPEN of an Excel file

Dear Amit, pest the code in the in vba Private Sub Workbook_Open() your code() End Sub On Mon, Jun 25, 2012 at 1:26 PM, Amit Gandhi wrote: > Hi Experts > > Pls help me with a way, so that a Macro runs whenever I open a particular > excel file. (Macro is in that excel file only). > > > Regar

Re: $$Excel-Macros$$ Re: Regarding control tab in the scroll bar

Many many thank you Regards, Sanjib On Tue, Jun 26, 2012 at 2:37 PM, Rajan_Verma wrote: > Hi > In Developer Tab > Goto Insert -> More Controll ( Bottom Right) then Find Microsoft ScrollBar > > Rajan. > > > On Tuesday, 26 June 2012 14:09:19 UTC+5:30, friend wrote: > >> >> Dear Sir/ Madam, >> >>

Re: $$Excel-Macros$$ MVP Award....Congratulations Ashish Koul and Dilip Pandey !!

congratulation both of you Regards, Sanjib On Sun, Jul 1, 2012 at 9:54 PM, Ayush Jain wrote: > Dear members, > > I am extremely happy to inform you that two members of the group are > awarded Microsoft Most Valuable Professional Award. > My heartiest congratulations to *Ashish koul* and *Dilip

Re: $$Excel-Macros$$ Rajan Verma - Most helpful Member(June '12)

Cong Mr. Ranjan Verma. Hoping for the est of life. Regds, Sanjib On Wed, Jul 4, 2012 at 10:18 PM, Born to Win wrote: > Congrats Ranjan...j > > have seen really great commitment towards group. > > and helping us with your expertise. > > > Cheer's, > CS > > > > On Wed, Jul 4, 2012 at 9:50 PM,

Re: $$Excel-Macros$$ MVP Award....Congratulations Ashish Koul and Dilip Pandey !!

cong both of you Regards, Sanjib On Wed, Jul 4, 2012 at 8:45 PM, Divaker Pandey wrote: > *Congrats..Ashish & Dilip, for your gr8 Achievement.* > > But it will be awesome.if you explore with group member, your journey to > plan, execution and finally getting award. > > Hope another group membe

Re: $$Excel-Macros$$ Mails IDs from Outlook

Just follow follow the link http://support.microsoft.com/kb/295664 On Thu, Jul 5, 2012 at 3:52 PM, Rohan Young wrote: > Dear Group, > > how can i get all mail IDs from my outlook to excel to make a list of > all IDs and Co., please help me out > > Thanks & Regds > > ROHAN > > -- > FORUM RULES

Re: $$Excel-Macros$$ Noorain Ansari - Most Helpful Member July 2012

Dear Noorain Ansari Congratulation for your achievement. As I stated early that you are the God of Excel. Please keep it going so that many excel lovers are get help. Thanking you Regards, Sanjib Chatterjee On Fri, Aug 3, 2012 at 11:10 PM, Ayush Jain wrote: > Dear members, > >

Fwd: $$Excel-Macros$$ Excel Dashboard with example

Dear Sirs, I show the *Chandoo.Org. *There is nice example but I can not understand how to prepare it. Would u Please explain me the steps with a single example. Thanking you Regards, Sanjib -- Forwarded message -- From: Kuldeep Singh Date: Fri, Sep 21, 2012 at 9:36 AM S

$$Excel-Macros$$ regarding use of double minus

Dear Noorain Ansari, Would you please tell why have you used the -- sing in the formula. for you reference i have highlighted the portion.. *=SUMPRODUCT(**--**(B4:B14="Karthik")*($C$4:$C$14="Collected"))* Thanking you Regards, Sanjib -- - -- Join official facebook page of this forum @

Re: $$Excel-Macros$$ regarding use of double minus

Thank you sir Regards, Sanjib On Sat, Oct 6, 2012 at 8:46 PM, ashish koul wrote: > visit > http://www.excelbanter.com/showthread.php?t=182549 > > > > On Sat, Oct 6, 2012 at 2:22 PM, Sanjib Chatterjee < > chatterjee.kolk...@gmail.com> wrote: > >> Dear No

Fwd: $$Excel-Macros$$ date format in Excel

Dear all members please help to solve the problem Sanjib -- Forwarded message -- From: Sanjib Chatterjee Date: Fri, Sep 30, 2011 at 11:03 AM Subject: $$Excel-Macros$$ date format in Excel To: excel-macros Dear I like to put the date format in Excel as "dd/mm/"

$$Excel-Macros$$ Fwd: date format help

Dear All Please go through the mail and help me. Ragards, sanjib -- Forwarded message -- From: Sanjib Chatterjee Date: Fri, Sep 30, 2011 at 12:15 PM Subject: date format help To: excel-macros Dear All members, please help me regarding date format in Excel. I want to put

Re: $$Excel-Macros$$ regarding date format in excel vba

il.com> wrote: > Hi, > > Use format function. > > ex. MsgBox Format(CDate("03/10/2011"), "dd-mmm-") > Regards, > > Swapnil. > On Mon, Oct 3, 2011 at 11:33 AM, Sanjib Chatterjee < > chatterjee.kolk...@gmail.com> wrote: > >> Dear Fri

Re: $$Excel-Macros$$ regarding date format in excel vba

uot;dd/mm/" in Type text box > > Regards, > > Swapnil > > On Mon, Oct 3, 2011 at 12:28 PM, Sanjib Chatterjee < > chatterjee.kolk...@gmail.com> wrote: > >> thank you for your quick responce Swapnil Palande . But i want to say is >> there any opti

Re: $$Excel-Macros$$ Want to separate Alphabet and Numeric Values

hi Suman, check the below mentioned link sanjib http://office.microsoft.com/en-us/excel-help/extracting-numbers-from-alphanumeric-strings-HA001154901.aspx On Wed, Oct 5, 2011 at 3:12 PM, Suman wrote: > Hi Group > I have multiple data in column A (Alphabet with numeric values) n i want to > s

Re: $$Excel-Macros$$ Extract 6 & 7 Digit Number

check the below mentioned linked regards sanjib http://office.microsoft.com/en-us/excel-help/extracting-numbers-from-alphanumeric-strings-HA001154901.aspx On Fri, Oct 7, 2011 at 11:37 AM, karan 1237 wrote: > Dear All, > > Hope you all are doing well ! > > I need your assistance to sort out my

Re: $$Excel-Macros$$ Selecting a date from a database, which equal to or lesser than the selected date

dear B Sharma please send me the sheets sanjib On Wed, Oct 12, 2011 at 12:37 PM, B Sharma wrote: > Dear Excel Experts > I want to select a date which is either equals to or lesser than the > select date. > > For Example > > in Column 1 I have different dates > > 01-Apr-2010 > 01-Jul-2010 >

Re: $$Excel-Macros$$ Unable to change date fromate

Dear Suman, Please use the below mentioned formula Function put_date(input_your_date As String) As String Dim splt splt = Split(input_your_date, "/") put_date = Format(DateSerial(splt(2), splt(1), splt(0)), "mm-dd-") End Function On Tue, Oct 11, 2011 at 6:38 PM, Suman wrote: > Hi, > Good

Re: $$Excel-Macros$$ file browser

reference : Microsoft Office 10 object libarary need to download Private Sub Command0_Click() Dim fd As FileDialog Set fd = Application.FileDialog(msoFileDialogFilePicker) Dim vrtSelectedItem As Variant With fd If .Show = -1 Then For Each vrtSelectedItem In .SelectedItems MsgBox "The path is: " &

Re: $$Excel-Macros$$ Selecting a date from a database, which equal to or lesser than the selected date

B. sharma. goto vba = module1=>paste the code in excel write a date = inset the function from userdefined function Sanjib On Wed, Oct 12, 2011 at 4:43 PM, B Sharma wrote: > Dear Sanjib. > there is no option there to attach the file > please help > > > On Oct

$$Excel-Macros$$ unable to do any operation with this data

Dear Members, Please see the attachment. I am unable to do any operation with this figure in the excel file. (i.e. Addition, multiplication, division etc) please help regards, Sanjib -- -- Some importan

Re: $$Excel-Macros$$ unable to do any operation with this data

> use functions. > > Regards, > > Swapnil. > > On Tue, Oct 25, 2011 at 1:30 PM, Sanjib Chatterjee < > chatterjee.kolk...@gmail.com> wrote: > >> Dear Members, >> >> Please see the attachment. I am unable to do any operation with this >>

Re: $$Excel-Macros$$ unable to do any operation with this data

gt; End Sub > > Don Guillett > SalesAid Software > dguille...@gmail.com > > *From:* Sanjib Chatterjee > *Sent:* Tuesday, October 25, 2011 3:00 AM > *To:* excel-macros > *Subject:* $$Excel-Macros$$ unable to do any operation with this data > > Dear Members, > >

$$Excel-Macros$$ copy from sheets1 to sheets2 automatically

Dear Members, I have two sheets in my excel file. In sheets1 i have data but sheets2 is blank. I want when i select a value of sheet1 it copy and paste in sheets2 automatically this will repeat again and again for each value. Thanking you in Advance Regards, Sanjib -- -- FORUM RULES (925+ m

Re: $$Excel-Macros$$ copy from sheets1 to sheets2 automatically

ko (GL) > > > On Tue, Nov 1, 2011 at 10:42 AM, Sanjib Chatterjee < > chatterjee.kolk...@gmail.com> wrote: > >> >> Dear Members, >> >> I have two sheets in my excel file. In sheets1 i have data but sheets2 >> is blank. >> I want when i select

Re: $$Excel-Macros$$ copy from sheets1 to sheets2 automatically

thank you sam and thank you Ashish regards sanjib On Tue, Nov 1, 2011 at 2:12 PM, Sanjib Chatterjee < chatterjee.kolk...@gmail.com> wrote: > > Dear Members, > > I have two sheets in my excel file. In sheets1 i have data but sheets2 is > blank. > I want when i select a

Re: $$Excel-Macros$$ Seeking help small letters to capital letters

=UPPER(A1) 2011/11/10 ♥.•:*¨¨*:•.♥.•:V.Kiran Kumar :•.♥.•:*¨¨*:•.♥ < vadnalaki...@gmail.com> > Hi > > Anybody can help me out > how to make small letter to capital letter in Ms excel > > V.Kiran > > > -- > FORUM RULES (934+ members already BANNED for violation) > > 1) Use concise, accurate thre

$$Excel-Macros$$ regarding date changing method

Dear Members, In excel 2003 I want to put the value in the cell (A1) as 15.11. But while changing(i.e. press enter or tab) the cell I want to convert the figure as 15.11.2011 and so on. Thanking you in Advance Regards, Sanjib -- - -- FORUM RULES (934+ members already BANNED for viola

Re: $$Excel-Macros$$ regarding date changing method

Dear Ranjan Verma, But I want I only put 15.11 in a cell, it will convert into 15.11.2011 Thanking you in advance Sanjib On Tue, Nov 15, 2011 at 2:12 PM, rajan verma wrote: > HI, > You can change Cell Format as you required like dd.mm or mm.dd > > On Tue, Nov 15, 2011 at 1:4

Re: $$Excel-Macros$$ regarding date changing method

Dear Mambers, any body please help. regards, Sanjib On Tue, Nov 15, 2011 at 1:40 PM, Sanjib Chatterjee < chatterjee.kolk...@gmail.com> wrote: > > Dear Members, > > In excel 2003 I want to put the value in the cell (A1) as 15.11. But > while changing(i.e. press enter

Re: $$Excel-Macros$$ regarding date changing method

> Noorain Ansari > *http://excelmacroworld.blogspot.com/*<http://excelmacroworld.blogspot.com/> > *http://noorain-ansari.blogspot.com/*<http://noorain-ansari.blogspot.com/> > On Tue, Nov 15, 2011 at 4:07 PM, Sanjib Chatterjee < > chatterjee.kolk...@gmail.com> wrote: > >> Dear M

$$Excel-Macros$$ how to open a 2007 excel file in previous version of excel

Dear Members, Would you please help regarding How to open a excel file saved on 2007 format in 2003 format Thanking you in Advance Sanjib -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Hel

Re: $$Excel-Macros$$ how to open a 2007 excel file in previous version of excel

Excel 2003. > > Regards, > Sam > > > On Mon, Nov 28, 2011 at 6:58 PM, Bé Trần Văn wrote: > >> >> >> 2011/11/28 Kenil Gala >> >>> Rename the file. >>> 2003 format : .xls >>> 2007 format : .xlsx >>> >>> --- On

Re: $$Excel-Macros$$ Instead of using Isempty(), what other ways can be used for filling up the data

please check the below mentioned code Sub Macro_del() ' ' ' Keyboard Shortcut: Ctrl+q ' Selection.SpecialCells(xlCellTypeBlanks).Select Selection.EntireRow.Delete ActiveWindow.SmallScroll Down:=-15 End Sub On Tue, Dec 20, 2011 at 12:25 PM, Asa Rossoff wrote: > Hi Darwin, > Instead o

Fwd: $$Excel-Macros$$ Fwd: date of birth

plz see the attachemnt -- Forwarded message -- From: Ansar Ellahi Date: Tue, Dec 27, 2011 at 2:01 PM Subject: $$Excel-Macros$$ Fwd: date of birth To: excel-macros@googlegroups.com -- Forwarded message -- From: Ansar Ellahi Date: Tue, Dec 27, 2011 at 1:29 PM Su

Re: $$Excel-Macros$$ Rajan verma : Most Helpful Member- Dec'2011

Congt, Ranjan Verma. Keep the good work going. Wish you happy and pros new year Sanjib On Tue, Jan 3, 2012 at 11:50 PM, Ayush Jain wrote: > Hello Everyone, > > Wish you a very happy new year !! > > Rajan Verma has been selected as 'Most Helpful Member' for the month of > December'2011 > He h

Re: $$Excel-Macros$$ Dairy 2012

thank you Muralidhar, It is nice. sanjib On Mon, Jan 16, 2012 at 2:21 PM, muralidhar e wrote: > > Hi, > > Dear all wish u happy sankranti(Pongal) and a digital dairy gift for all. > > -- > *Thanks & Regards,* > ** > *Muralidhar E.* > > -- > FORUM RULES (986+ members already BANNED for violati

$$Excel-Macros$$ regarding number to text

Dear NOORAIN ANSARI, This is great. Would you please explain why it is showing just thiousant, (e.i. If i put the figure as 123654.59, I like to display as "one lakh twenty three thousand six hundred fifty four and paise fifty nine only) why lakh is not coming here? regards, Sanjib -- - -

Re: $$Excel-Macros$$ regarding number to text

vba for million and billion format. >> For lakh you use other vba code >> >> >> *From:* Sanjib Chatterjee >> *To:* noorain.ansari ; excel-macros < >> excel-macros@googlegroups.com> >> *Sent:* Tuesday, 17 January 2012 1:19 PM >> *Subject:* $$Excel-Macros

Re: $$Excel-Macros$$ unable to open file of 2007 in 2003

d drop. > > ** ** > > Asa > > ** ** > > *From:* excel-macros@googlegroups.com [mailto: > excel-macros@googlegroups.com] *On Behalf Of *Sanjib Chatterjee > *Sent:* Tuesday, February 07, 2012 10:07 PM > *To:* excel-macros > > *Subject:* $$Excel-Macros$$ unable

Re: $$Excel-Macros$$ seeking help on Date format

please see the attachment, may be it can help you sanjib 2012/2/13 ♥.•:*¨¨*:•.♥.•:V.Kiran Kumar :•.♥.•:*¨¨*:•.♥ < vadnalaki...@gmail.com> > Dear Excel Experts > > I have a problem in excel date format in column A > whenever i enter the date dd/mm/ it changes to mm/dd/ > > I tried to chan

Re: $$Excel-Macros$$ combo box or list box help

Once again thank you Sir for quick reply. But would you please show me the process. Regards, Sanjib On Thu, Feb 16, 2012 at 4:57 PM, Shaik Waheed wrote: > Hi, > Please chek it > > On Thu, Feb 16, 2012 at 4:39 PM, Sanjib Chatterjee < > chatterjee.kolk...@gmail.com>

$$Excel-Macros$$ HAPPY NEW YEAR 2014

Wish you a happy a glorious new year 2014 and all the best for the coming year -- - -- 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 forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise

  1   2   >