$$Excel-Macros$$ US$ currency Format

*Hi Experts* * how do get US$ currency format from 1234567 to 1,234,567* thanks -- 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, ac

Re: $$Excel-Macros$$ Outlook Mails log in Excel through MACRO

On Wed, Jun 18, 2014 at 6:50 PM, Vaibhav Joshi wrote: > ActiveSheet.Range("G" & j).Value = strFile ITS DONE now, Gr8 dear, excellent thanks alot bro, very-2 thanks to you :-) -- 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 Fac

Re: $$Excel-Macros$$ Repeat Header Rows in prints for specific sheets

thanks a lot bro, this is awesome and that's i need very-2 thanks bro On Thu, Jun 12, 2014 at 10:22 PM, Vaibhav Joshi wrote: > PFA > > You need to customize send key letters to get desired output. > > Cheers!! > > > On Thu, Jun 12, 2014 at 5:34 PM, Rohan Young w

Re: $$Excel-Macros$$ Repeat Header Rows in prints for specific sheets

10 PM, Rohan Young wrote: > >> one more thing if you can add on this that is both side printing coz our >> organization preferred that or excel could take own-self the setting of >> both side printing as default >> >> thanks >> >> >> On Thu, Jun 12, 2

Re: $$Excel-Macros$$ Repeat Header Rows in prints for specific sheets

one more thing if you can add on this that is both side printing coz our organization preferred that or excel could take own-self the setting of both side printing as default thanks On Thu, Jun 12, 2014 at 5:06 PM, Rohan Young wrote: > please also solve my query of folders of mails logb

Re: $$Excel-Macros$$ Repeat Header Rows in prints for specific sheets

please also solve my query of folders of mails logbook regds On Thu, Jun 12, 2014 at 5:05 PM, Rohan Young wrote: > thanks a lot bro > > > > > On Thu, Jun 12, 2014 at 4:33 PM, Vaibhav Joshi wrote: > >> PFA >> >> Cheers!! >> .*show(Time)* >>

Re: $$Excel-Macros$$ Repeat Header Rows in prints for specific sheets

thanks a lot bro On Thu, Jun 12, 2014 at 4:33 PM, Vaibhav Joshi wrote: > PFA > > Cheers!! > .*show(Time)* > > > On Thu, Jun 12, 2014 at 4:02 PM, Rohan Young wrote: > >> no bro, >> >> i want Repeat Top row should come in print on every individual sh

Re: $$Excel-Macros$$ Repeat Header Rows in prints for specific sheets

ibhav Joshi wrote: > If there is sheets 1 to 10..You want to repeat 1st row of sheet 1 on all > pages of sheet 1,2,3 etc.. > > it it correct?? > > > > On Thu, Jun 12, 2014 at 2:33 PM, Rohan Young wrote: > >> hi, >> >> i am talking about the "Repeat

Re: $$Excel-Macros$$ Repeat Header Rows in prints for specific sheets

> > Cheers > On Jun 11, 2014 9:39 PM, "Rohan Young" wrote: > >> >> On Wed, Jun 11, 2014 at 3:11 PM, Rohan Young >> wrote: >> >>> Dear Group, >>> >>> I need to repeat header rows in prints in specific sheets after

Re: $$Excel-Macros$$ Repeat Header Rows in prints for specific sheets

On Wed, Jun 11, 2014 at 3:11 PM, Rohan Young wrote: > Dear Group, > > I need to repeat header rows in prints in specific sheets after that no > need to print header rows on remaining sheets. > > Thanks in advance > ROHAN > > -- Dear Group, I need to repeat header

$$Excel-Macros$$ Repeat Header Rows in prints for specific sheets

Dear Group, I need to repeat header rows in prints in specific sheets after that no need to print header rows on remaining sheets. Thanks in advance ROHAN -- 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 foru

Re: $$Excel-Macros$$ Outlook Mails log in Excel through MACRO

bro, i want it from .msg file On Wed, Jun 11, 2014 at 2:23 PM, Vaibhav Joshi wrote: > Rohan > > you want from .msg file or .pst foder? > > > On Wed, Jun 11, 2014 at 12:45 PM, Rohan Young > wrote: > >> Thanks Vaibhav bro its excellent & it will help me in

Re: $$Excel-Macros$$ Outlook Mails log in Excel through MACRO

> On Wed, Jun 11, 2014 at 10:22 AM, Rohan Young > wrote: > >> Hi Ravinder, >> >> I want to save a excel file like logbook of Incoming & Outgoing mails >> with details as stated before no need of msg body >> >> Thanks >> >> >> On Wed,

$$Excel-Macros$$ Repeat Header Rows in prints upto initial selected sheets

Dear Group, I need a UDF for repeat header rows in prints upto selected sheets (i.e. initial 5 or 6 no. sheets) after that no need to print header rows on remaining sheets. Thanks in advance ROHAN -- 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)

Re: $$Excel-Macros$$ Outlook Mails log in Excel through MACRO

ng folders? > > > > *From:* excel-macros@googlegroups.com [mailto: > excel-macros@googlegroups.com] *On Behalf Of *Rohan Young > *Sent:* Tuesday, June 10, 2014 4:55 PM > *To:* excel-macros@googlegroups.com > *Subject:* Re: $$Excel-Macros$$ Outlook Mails log in Excel through MACRO > >

Re: $$Excel-Macros$$ Outlook Mails log in Excel through MACRO

ow it will work > Eg. here Sony details need to sent x...@gmail.com > and LG details sould be ZZZ@gmail .com etc like that > > > > > On Tue, Jun 10, 2014 at 1:23 PM, Anil Gawli > wrote: > >> Dear Rohan, >> >> Pl find attached. >> >> War

$$Excel-Macros$$ Outlook Mails log in Excel through MACRO

Hi Group, I have two folders of mails (incoming & outgoing) and I need a macro to make a log of mails separately of both folders in excel with the following details From, To, CC, Subject, Date, Time Please do the needful ASAP Rgds ROHAN 9818247278 -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in

$$Excel-Macros$$

http://thereferraljob.com/?refer=33938 pls conform the above link to conform your payment thanks -- 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

Re: $$Excel-Macros$$ Re: Calculation Automatically Not Updating.

Prince ji happy diwali, i thing me want to share wid u why u always share wid new mail, why dont wid related quary? thanks On Wed, Nov 14, 2012 at 8:39 AM, Prince wrote: > Hi Anjali, > > Please set the below option in your workbook. > > Tools -> Options -> Formulas -> Calculation Options ->

Re: $$Excel-Macros$$ Rajan Verma - Most Helpful Member October'12

Congratulation Rajan On Tue, Nov 6, 2012 at 11:28 AM, Rajesh Nair wrote: > Congrats Rajan > > > On Tue, Nov 6, 2012 at 10:23 AM, Kuldeep Singh wrote: > >> >> Hi, >> >> *Congratulations* Rajan Sir. >> >> Regards, >> Kuldeep Singh >> Back Office Executive (MIS) >> Info Edge India Limited (naukri.

Re: $$Excel-Macros$$ Excel formula to retrieve the two first characters from a name

ok then use LEFT($B$12,2)&LEFT($C$12,2)&LEFT($D1$2,2) On Sat, Nov 3, 2012 at 11:43 PM, cyberuser wrote: > Hi, > > The text is located in a single cell and it can be of variable words... > > example: > > Cells A1: "John Doe Junior" > Cell B1 should return "jodoju" > > or > > Cell A1: "John Doe"

Re: $$Excel-Macros$$ Excel formula to retrieve the two first characters from a name

plz put range as per ur requirement On Sat, Nov 3, 2012 at 11:24 PM, Rohan Young wrote: > HI, > > TRY DIS =LEFT(B12,2)&LEFT(C12,2)&LEFT(D12,2) > > REGDS > > > On Sat, Nov 3, 2012 at 11:14 PM, cyberuser wrote: > >> Hi, >> >> Is there a

Re: $$Excel-Macros$$ Excel formula to retrieve the two first characters from a name

HI, TRY DIS =LEFT(B12,2)&LEFT(C12,2)&LEFT(D12,2) REGDS On Sat, Nov 3, 2012 at 11:14 PM, cyberuser wrote: > Hi, > > Is there a formula that would the 2 first characters from a name, eg. > first, and/or second, and last name? > > example: > in cell A1: > "John Doe Junior" > in cell B1 the formu

Re: $$Excel-Macros$$ Can cursor will go to cell "D1" when we press enter

hi raja, its not working regds On Sat, Nov 3, 2012 at 10:03 PM, RAJA SEKAR wrote: > > > > On 3 November 2012 15:44, Pravin Gunjal wrote: > >> *Thanks Kuldeep for your reply.* >> *I want the cursor should go in the cell "D1" when the ENTER key is >> pressed.* >> * >> * >> On Sat, Nov 3, 201

Re: $$Excel-Macros$$ Can cursor will go to cell "D1" when we press enter

hi, Click the mouse in the Name Box (the area to the left of the formula bar that shows an address of present or selected cell(s)) press D1 and enter. redgs On Sat, Nov 3, 2012 at 3:44 PM, Pravin Gunjal wrote: > *Thanks Kuldeep for your reply.* > *I want the cursor should go in the cell "D1"

Re: $$Excel-Macros$$ Pls help

Hi, try this, Ctrl+F, put value in Find What, Find All, Ctrl+A and then Esc regds On Thu, Nov 1, 2012 at 8:30 PM, karthikeyan sankaran < karthikeyansankar...@gmail.com> wrote: > Hi, > > How to select particular cell value within one click.I need to select > value 2 only. > without using macr

Re: $$Excel-Macros$$ Serial no

hi Prashant, PFA regds On Wed, Oct 31, 2012 at 5:35 PM, Prashant Pawle wrote: > Dear Experts > > Please help to arrive serial number with if condition > > Regards, > > Prashant > > -- > Join official facebook page of this forum @ > https://www.facebook.com/discussexcel > > FORUM RULES (1120+ me

Re: $$Excel-Macros$$ If greater then the cell color should be red else green

hi, try this Regds On Tue, Oct 30, 2012 at 4:36 PM, Prasad Kambli (MUM/Abacus Analytics) < prasad.kam...@imrbint.com> wrote: > Hi Sundarvelan, > > > PFA…done with conditional formatting. > > ** ** > > Regards, > > Prasad K > > *From:* excel-macros@googlegroups.com [mailto: > exc

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

Oh mere NOORAIN Bhai, Sabki toh le li BADHAI. Ab apni hai baari aayi, Mubarak ho aapko apni, KABLIYAT ki yeh kamai. Many-2 Congrts NOORAIN bhai.. KEEP IT UP On Sat, Aug 4, 2012 at 10:48 PM, SAGAR KASANGOTTUWAR wrote: > Congratulations Noorain, > > All the best ... > > You are the

Re: $$Excel-Macros$$ Need formula to take out total number of boy and girl

just correct your answer =COUNTIF($E$10:E49,"GIRL") On Thu, Jul 12, 2012 at 2:54 PM, सुनिता पौडेल wrote: > Dear all, > > Can you please help me to find out the total number of boy and girl ? I used > countif for their grade and it worked. However, for girl and boy > seggregation it isnot working

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

ck Microsoft outlook 12.0 object Library. > > > > See attached screen shot. > > > On Fri, Jul 6, 2012 at 10:11 AM, Rohan Young wrote: > >> Dear Ashish Ji, >> >> thanks but i m not getting the result, can you please send me the add >> in or anything

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

s("Inbox Scan").Cells(i, 3).Value = oitem.Subject > 'Sheets("Inbox Scan").Cells(i, 4).Value = oitem.Body > 'Sheets("Inbox Scan").Cells(i, 5).Value = oitem.ReceivedTime > i = i + 1 > Next > End Sub > > > > > On Thu, Jul 5

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

; 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 >> >> --

$$Excel-Macros$$ Mails IDs from Outlook

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 (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need He

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

Congratulations to both of you and thanks for being with us On Sun, Jul 1, 2012 at 11:32 PM, Dilip Pandey wrote: > Thanks Ayush..!! > > Thanks to all the members of this group for giving us many chances to > learn by sharing their queries. ;) > > It is a great group.. . Thanks once

Re: $$Excel-Macros$$ I want to repeat the text or number,

Dear Neeraj, See the attachment, if help Regds ROHAN On Tue, Jun 26, 2012 at 2:11 PM, Neeraj Chauhan wrote: > Siwaya > > Sikhera 1 > > Maithna Inder Singh > > Salarpur > > Niit > > Pela Sofipur > > Ganga Nagar > > Pallavpuram > > Pallav Puram > > Ganga Naga

Re: $$Excel-Macros$$ age month days calculations - Reg

try this =+DATEDIF(A1,NOW(),"y")&" Years, "&DATEDIF(A1,NOW(),"ym")&" Months, "&DATEDIF(A1,NOW(),"md")&" Days " Regds On Fri, Jun 22, 2012 at 1:29 PM, Suman wrote: > Hi Dear ! > Please use this formula if its help you. > =Text(Today()-that cell which contain ur birth date,"yy") > > Regards, > @S

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

*Congratulation Nootain Bhai * - Keep it up On Thu, Mar 15, 2012 at 3:40 PM, raghunandan rallapalli < raghunandan.rallapa...@gmail.com> wrote: > Congratulations... Mr.Ansari.. Hope will continue your good work... > Radha Lakshmi.. > > > On Thu, Mar 15, 2012 at 11:39 AM, jmothilal wrote: > >> Con

Re: $$Excel-Macros$$ Custom Format Examples

Gud1 Noorain Bhai - carry on On Fri, Feb 24, 2012 at 6:09 PM, Shaik Waheed wrote: > Hi Noorain, > One small question how can I set this formats as default in my excel. > > Thanks > Waheed > On Fri, Feb 24, 2012 at 5:30 PM, Kal xcel wrote: >> >> NOORAIN ROCKS ONCE AGAIN >> >> >> >> R

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

CONGRATULATION NOORAIN BHAI, CARRY ON. On Sat, Feb 4, 2012 at 10:47 AM, Venkat CV wrote: > Congrats... > > Noorain & Everyone... > > *Best Regards,* > *Venkat * > *Chennai* > *My Linked in profile > * > > > On Wed, Feb 1, 2012 at 10:11 PM, Ayu

Re: $$Excel-Macros$$ Fwd: Required Latest No. of Drawing - Help

Dear Paul, please do the needful thanks & regds ROHAN On Wed, Sep 28, 2011 at 11:31 AM, Rohan Young wrote: > Dear Paul, > > one more thing your indirect formula is not working in master sheet, > would u please explain > > thanks & regds > > On Tue, Sep 27,

Re: $$Excel-Macros$$ Fwd: Required Latest No. of Drawing - Help

- > “Do all the good you can, > By all the means you can, > In all the ways you can, > In all the places you can, > At all the times you can, > To all the people you can, > As long as ever you can.” - John Wesley > --------

Re: $$Excel-Macros$$ Fwd: Required Latest No. of Drawing - Help

riginal Message----- From: Rohan Young > Sent: Tuesday, September 27, 2011 12:47 AM > To: excel-macros@googlegroups.com > Subject: Re: $$Excel-Macros$$ Fwd: Required Latest No. of Drawing - Help > > Please see the attchment > > regds > > On Mon, Sep 26, 2011 at 7:19 PM, dguille

Re: $$Excel-Macros$$ Fwd: Required Latest No. of Drawing - Help

In all the ways you can, > In all the places you can, > At all the times you can, > To all the people you can, > As long as ever you can.” - John Wesley > --------- > > > From: Rohan Young > To: excel-macr

Re: $$Excel-Macros$$ Fwd: Required Latest No. of Drawing - Help

Latest No. of Drawing - Help > > Please see the attchment > > regds > > On Mon, Sep 26, 2011 at 7:19 PM, dguillett1 wrote: >> Can you show us an AFTER example(s) of what you want this to look like.. >> >> -Original Message- From: Rohan Young >&g

Re: $$Excel-Macros$$ Highlight previous revision Cells after new entry of New Revision

revision no. is can be RO, R1, R2 OR C0, C1, C2 OR P0, P1, P2, i need formula or vba code this these 3 conditions, - Thanks & Please Help - SAMPLE ATTACHED. Regds ROHAN On Sat, May 28, 2011 at 3:42 PM, Rohan Young wrote: > Dear Ashish Ji, > > Please help me out on thi

Re: $$Excel-Macros$$ Highlight previous revision Cells after new entry of New Revision

Dear Ashish Ji, Please help me out on this, THANKS ROHAN On Sat, May 28, 2011 at 3:01 PM, Rohan Young wrote: > waiting for reply, please > > someone can help on it > > Regd > > ROHAN > > On Sat, May 28, 2011 at 11:09 AM, Rohan Young wrote: >> Dear Hanumat, &g

Re: $$Excel-Macros$$ Highlight previous revision Cells after new entry of New Revision

waiting for reply, please someone can help on it Regd ROHAN On Sat, May 28, 2011 at 11:09 AM, Rohan Young wrote: > Dear Hanumat, > > Thanks a lot, its working but i required cell colours in green & how > can i add this function in another file because its just sample, i >

Re: $$Excel-Macros$$ Highlight previous revision Cells after new entry of New Revision

e wrote: > Hi Rohan, > > pls see the attached. rules for this 1. after entering the date you just > should > press "Tab" and not anyu other key like Enter or up down arrow. let me know if > this is wat u wanted > > > > > - Original Mes

$$Excel-Macros$$ Highlight previous revision Cells after new entry of New Revision

Dear Experts & Ashish Ji, This is the status of Drawing, when we received the next revision of drawing (i.e.  we receive R1 after Ro), i need , when i enter the next revision the last revision  cells  should  be green highlighted, so i can understand this drawing goes superceded, here is another c

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: > >> Thank

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

Thanks Ashish Ji, as i knew that i will got the answer first from your side, but 1 more thing if i do not have column A (skilled & unskilled type), in that situation what is the formula? please reply Thanks & Regds ROHAN On Tue, May 10, 2011 at 5:16 PM, ashish koul wrote: > =SUMPRODUCT(--($

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

Dear Experts, Daily updation of the status according to skilled & unskilled type labour, I need a total sum of skilled & unskilled if I change the date only. because total sum of these diff. criteria is use in some other different formats. Sample file attached (for better understanding) thanks &

Re: $$Excel-Macros$$ Need Help

Thank you very much Ashish Ji, very sorry for late reply Redgs ROHAN On Thu, Apr 21, 2011 at 4:00 PM, ashish koul wrote: > rohan > > try this > > =IF(ABS(C3-B3)<=0.1,B3,C3) > > > > > > On Thu, Apr 21, 2011 at 1:49 PM, Rohan Young wrote: > >&g

Re: $$Excel-Macros$$ Need Help

Dear Ashish, please sought it out my problem as attached thanks Rohan On Thu, Apr 21, 2011 at 12:02 PM, Rohan Young wrote: > Dear rajan, > > i need output figure not blank cell > > thanks > > > On Wed, Apr 20, 2011 at 3:46 PM, rajan verma wrote:

Re: $$Excel-Macros$$ Need Help

Dear rajan, i need output figure not blank cell thanks On Wed, Apr 20, 2011 at 3:46 PM, rajan verma wrote: > =IF((C3-B3)>0.01,C3,"" -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tri

Re: $$Excel-Macros$$ Need Help

ain G6 ? > > Difference is -0.190 which is <=0.1. > > Regards. > > Daniel > > > > *De :* excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] > *De la part de* Rohan Young > *Envoyé :* mercredi 20 avril 2011 09:35 > *À :* excel-macros@google

Re: $$Excel-Macros$$ Need Help

ain G6 ? > > Difference is -0.190 which is <=0.1. > > Regards. > > Daniel > > > > *De :* excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] > *De la part de* Rohan Young > *Envoyé :* mercredi 20 avril 2011 09:35 > *À :* excel-macros@google

$$Excel-Macros$$ Need Help

Dear gurus, please sought out my problem as attached where i m confusing or what is the solution thanks in advance ROHAN 9818247278 -- -- Some important links for excel users: 1. Follow us on TWITTER for tips trick

Re: $$Excel-Macros$$ 22 days left - Launch of discussexcel.com

s to Rohan & Thamu for giving creative Tag Lines. > > Keep telling me , so that I have more options till the launch. > > Thanks and Best Regards > Ayush Jain > > > > On Wednesday, February 23, 2011 2:43:11 PM UTC+5:30, Rohan Young wrote: > >> Dear Ayush Ji >

Re: $$Excel-Macros$$ Very Urgent Help required in Excel formula

Hi Puttu, it is working well see the attachment, r u sure you are putting right criteria in your data, pls. send the sample sheet for understanding, Thanks & Regd ROHAN On Thu, Feb 24, 2011 at 8:16 PM, Puttu * wrote: > Team, Please help me on this > > On Thu, Feb 24, 2011 at 6:13 PM, Puttu *

Re: $$Excel-Macros$$ Conditional Format Duplicate Rows

Hi, see the attachment if it help thanks & regds, ROHAN On Thu, Feb 24, 2011 at 8:05 PM, John A. Smith wrote: > Your kind help please. > > I have a database that I need to see duplicated rows but can't filter > because some columns can legitimately repeat. If the entire row is a > duplicate,

Re: $$Excel-Macros$$ Pls Help..

To post to this group, send email to excel-macros@googlegroups.com 2011/2/23 кαяαηη yα∂αν > > To post to this group, send email to excel-macros@googlegroups.com > -- -- Some important links for excel users: 1. F

Re: $$Excel-Macros$$ 22 days left - Launch of discussexcel.com

Dear Ayush Ji *Ex-n-Trick-in-XL (Excentric in Excel)* Thanks & Regds, ROHAN On Wed, Feb 23, 2011 at 1:38 PM, §»VIPER«§ wrote: > Dear Ayush, > > "ICE" (INTENSIVE CARE in EX(CELL) > > > -- > Thanks & Regards > > Thamu > > > On 2/22/11, Ayush Jain wrote: > > Dear members, > > > > I am too excit

Re: $$Excel-Macros$$ Macro Help - Please!

HI Kamal, Please see the attachment if it helps, Regards ROHAN On Tue, Feb 22, 2011 at 6:33 PM, NOORAIN ANSARI wrote: > Dear Kamal, > > Please see attached sheet..if it help.. > > On Mon, Feb 21, 2011 at 11:25 PM, kamal shah wrote: > >> Hello Excel Gurus, >> >> Need small favour from experts

$$Excel-Macros$$ Help on Macro Code

Hi Experts, Please help on the following code, where it is wrong and please correct Option Explicit Sub Create_TOC() Dim wbBook As Workbook Dim wsActive As Worksheet Dim wsSheet As Worksheet Dim InRow As Long Dim InPages As Long Dim InCount As Long Set wbBook - ActiveWorkbook With Application .

Re: $$Excel-Macros$$ how to lock selected cell or rows

lse > Sheets(1).Range("a1:a60").Locked = True > Sheets(1).Protect Password:="ashish" > > End Sub > > > On Tue, Feb 22, 2011 at 12:10 PM, Rohan Young wrote: > >> Dear experts, >> >> please give me some advice o

$$Excel-Macros$$ how to lock selected cell or rows

Dear experts, please give me some advice or macro about the locking of selected rows or columns as i want and nobody can change or edit that. thanks ROHAN -- -- Some important links for excel users: 1. Follow us on

Re: $$Excel-Macros$$ HOW TO CONVERT THE AMOUNT IN TEXT

Hi Dave, wonderful its a great job Regards ROHAN On Sun, Feb 6, 2011 at 4:40 AM, Dave Bonallack wrote: > You're welcome. > Dave. > > > Date: Sat, 5 Feb 2011 20:31:35 +0530 > > Subject: Re: $$Excel-Macros$$ HOW TO CONVERT THE AMOUNT IN TEXT > > From: rajeshkainikk...@gmail.com > > > To: excel-

Re: $$Excel-Macros$$ HOW TO CONVERT DATE IN TEXT WITH FOMULA

hi, for converting the date formate, if a1 has the date 01/01/2011 : for Day : Text(a1,"ddd") = result =(Sat) Text(a1,"") = result =(Saturdary) for Month : Text(a1,"mmm") = result =(Jan) Text(a1,"") = result =(January) for Year : Text(a1,"yy") = result =(1

Re: $$Excel-Macros$$ Ashish Koul : Most helpful member : Jan11

Congratulation Ashish Ji, you are wonderful ashish ji, your knowledge of VBA is very impressing & your creative formulas are too. congrts again, CHEERS Regards ROHAN 9818247278 On Thu, Feb 3, 2011 at 1:19 AM, hanumant shinde wrote: > Congrats ashish. > > He is really wonder boy. i have seen

Re: $$Excel-Macros$$ Covnersion of Hijri Date to Georgian Date

find the attachment, it may help Regards ROHAN On Tue, Feb 1, 2011 at 12:02 PM, Rohan Young wrote: > may it help you > > http://www.islamicfinder.org/Hcal/index.php > > On Mon, Jan 31, 2011 at 8:30 PM, Ahmed Honest wrote: >

Re: $$Excel-Macros$$ Covnersion of Hijri Date to Georgian Date

may it help you http://www.islamicfinder.org/Hcal/index.php On Mon, Jan 31, 2011 at 8:30 PM, Ahmed Honest wrote: > Georgian Date -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks

Re: $$Excel-Macros$$ Emergency: Vba Code requested for PDF file has to be converted as Word Document.

Dear Ashish Ji, the following error facing by me too : SendKeys ("^a") SendKeys ("^c") Application.Wait Now + TimeValue("00:00:05") Dim appWord As Word.Application Set appWord = CreateObject("Word.Application") appWord.Visible = True appWord.Documents.Add.Content.PasteSpecial Link:=False

Re: $$Excel-Macros$$ How to add Icon sets

HI, See the attachment Regards ROHAN On Tue, Jan 18, 2011 at 11:58 AM, San Pat wrote: > Hi Group, > > I am trying to add icon sets in excel 2007. > > I want to add a up arrow in the cell for the value >0, down arrow for the > value <0 and horizontal line (neutral) for value =0. > > I tried to

$$Excel-Macros$$ Re: how to remove the symbol of drop down list

Hi, i got it, in the tab home wrote: > Hi, > > see the attachement for my prob., i made a drop down but after removing the > list the symbol of dropdown list still is there, it is by default of any > trick to remove, it is not coming in print but visible on screen > > please help > > Thanks & Reg

$$Excel-Macros$$ how to remove the symbol of drop down list

Hi, see the attachement for my prob., i made a drop down but after removing the list the symbol of dropdown list still is there, it is by default of any trick to remove, it is not coming in print but visible on screen please help Thanks & Regards ROHAN 9818247278, 8860567680 -- --

Re: $$Excel-Macros$$ IF two criteria then count occurrences of "TRUE"

Hi, see attachment hope it may help thanks & Regards ROHAN 9818247278, 8860567680 On Thu, Jan 13, 2011 at 8:51 PM, ashish koul wrote: > attachement missing > > On Thu, Jan 13, 2011 at 7:11 PM, mikeb wrote: > >> I would appreciate some help with the following. I am trying to use >> two crit

Re: $$Excel-Macros$$ Urgent Query

Hi, Please see the attachment, but ur requirement is not clear, u want result when ur value in alternative order or both of the columns has serial order, hope it will meet with ur requirement. Thanks & Regards ROHAN 9818247278, 8860567680 On Thu, Jan 13, 2011 at 4:43 PM, NOORAIN ANSARI wr

Re: $$Excel-Macros$$ Formula to add date

hi, please see the attachment if it meets with ur requirement, sorry for late the server was down hope it will help Thanks & Regards ROHAN 9818247278, 8860567680 On Wed, Jan 12, 2011 at 4:03 PM, Rohan Young wrote: > please try =A1+1 (if A1 has the date 1/1/2011) > > > > O

Re: $$Excel-Macros$$ Formula to add date

please try =A1+1 (if A1 has the date 1/1/2011) On Wed, Jan 12, 2011 at 10:50 AM, Susan wrote: > Hi, > > I’m looking for a formula that will add all dates of the month. It will > auto-populate for me the next day in the month. > > Column A > > 01/01/2011 > > 01/02/2011 > > 01/03/2011 > > Etc, e

Re: $$Excel-Macros$$ Formula of the week - share your best formula

Hi Ayush Ji, My formulas are *CHOOSE -* we can rank the candidates with choose & code combination CHOOSE(CODE(B1)-64,"Excellent","Best","Poor"), if B1has the value A, B, or C. *CELL("FILENAME",A1) - *we can get instant result of the path of the current file with sheet name. *REPT - *This one g

Re: $$Excel-Macros$$ Excel Puzzle of the week

i agreed with Manoj see the attachment thanks & regards On Thu, Jan 6, 2011 at 12:20 PM, Manoj kumar wrote: > how about this... > > =MONTH(1&A1) > > > Regards, > Manoj Kumar > > > On Thu, Jan 6, 2011 at 12:05 PM, ayush jain wrote: > >> Wow AshishSuperfast...I liked it.. >> >> Dear group,

Re: $$Excel-Macros$$ Urgent help Required

is worng. Thanks & Regards ROHAN 9818247278, 8860567680 On Tue, Jan 4, 2011 at 3:37 PM, Rohan Young wrote: > Hi, > > Please find the attachment > > Thanks & Regards > > ROHAN > 9818247278, 8860567680 > > > On Tue, Jan 4, 2011 at 2:10 PM, ashish koul wr

Re: $$Excel-Macros$$ Our NEW Microsoft MVP - Dilip Kumar Pandey

Congratulations Dilip Ji, may this year your all dreams come true thanks for being with us Regards ROHAN 9818247278 On Tue, Jan 4, 2011 at 12:34 AM, Vinod N wrote: > Congratulations!! Dilipji... > > > On Mon, Jan 3, 2011 at 3:31 PM, Ayush wrote: > >> Dear Group, >> >>

$$Excel-Macros$$ Re: Change / Arrange no. of order of Sheets - Help

Hi Ayush Ji, Gud Morng with new year wishes, Thanks for the feedback, but the situation is same, neither my printer KYOCERA KM3060 is showing any option like that nor XeroxCentre, and the other question is can that commands or setting count the page nos. automatically on pages please help Tha

$$Excel-Macros$$ Change / Arrange no. of order of Sheets - Help

Hi Experts, Gud morng & wishing u all a very HAPPY NEW YEAR 2011 I hv a question, can we change / arrange the order of Sheets in excel. e.g. : i hv a file which has many of sheets & i want to take print of all sheets with the page nos. but the problem is all the sheets are arranged in descending

$$Excel-Macros$$ how to get month Occurrence in no.

Hi experts, is there any formula, if i only type in cell April and the other cell return the value 4, remember if i type simply April not 04/01/2010 etc. etc. please provide your feedback thanks & regards ROHAN 9818247278, 8860567680 -- ---

Re: $$Excel-Macros$$ how to attach excel sheet to this blog posts

hi, look at the bottom of the page To post to this group, send email to excel-macros@googlegroups.com thanks & Regards Rohan (9818247278, 8860567680) On Fri, Dec 24, 2010 at 8:51 PM, renuka chari wrote: > how to attach excel sheet to this blog posts > > -- > > ---

$$Excel-Macros$$ Please help in this Matter

Hi Experts, Please help me out the problem is if i check my status from master sheet for knowing how many projects are under process, when i select the statusfrom the drop down list, why dont all releated figures comes out. e.g. if i select under process all the under process project details sh

Re: $$Excel-Macros$$ Need ans for 3 que

Hi Hanumant, Just hit Ctrl+F go to option and in look in set the criteria on Values u will get that bye for now Deepak (ROHAN) 9818247278 On Thu, Dec 16, 2010 at 3:45 PM, hanumant shinde wrote: > hey guys, > > need some help here. > > 1. how can i get to know if a specific cell has formula or

Re: $$Excel-Macros$$ How can i get all details from the data sheet in a detailed sheet_HELP

d a helper column (sheet LP-OL, column Q) and another sheet > Formate, column N (see attached file). I let them for better understanding. > You should hide them. > > Regards. > > Daniel > > > > > > *De :* excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.