$$Excel-Macros$$ US$ currency Format

2014-07-18 Thread Rohan Young
*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,

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

2014-06-18 Thread Rohan Young
On Wed, Jun 18, 2014 at 6:50 PM, Vaibhav Joshi v...@vabs.in 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

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

2014-06-17 Thread Rohan Young
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 v...@vabs.in 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 rohan.j...@gmail.com wrote

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

2014-06-12 Thread Rohan Young
, 2014 9:39 PM, Rohan Young rohan.j...@gmail.com wrote: On Wed, Jun 11, 2014 at 3:11 PM, Rohan Young rohan.j...@gmail.com 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

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

2014-06-12 Thread Rohan Young
Joshi v...@vabs.in 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 rohan.j...@gmail.com wrote: hi, i am talking about the Repeat Top Rows not header or footer thanks

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

2014-06-12 Thread Rohan Young
thanks a lot bro On Thu, Jun 12, 2014 at 4:33 PM, Vaibhav Joshi v...@vabs.in wrote: PFA Cheers!! .*show(Time)* On Thu, Jun 12, 2014 at 4:02 PM, Rohan Young rohan.j...@gmail.com wrote: no bro, i want Repeat Top row should come in print on every individual sheet's first 6 pages

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

2014-06-12 Thread Rohan Young
please also solve my query of folders of mails logbook regds On Thu, Jun 12, 2014 at 5:05 PM, Rohan Young rohan.j...@gmail.com wrote: thanks a lot bro On Thu, Jun 12, 2014 at 4:33 PM, Vaibhav Joshi v...@vabs.in wrote: PFA Cheers!! .*show(Time)* On Thu, Jun 12, 2014 at 4:02 PM

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

2014-06-11 Thread Rohan Young
AM, Rohan Young rohan.j...@gmail.com 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, Jun 11, 2014 at 10:16 AM, Ravinder ravindervbacli...@gmail.com wrote: U want to save exl files

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

2014-06-11 Thread Rohan Young
bro, i want it from .msg file On Wed, Jun 11, 2014 at 2:23 PM, Vaibhav Joshi v...@vabs.in wrote: Rohan you want from .msg file or .pst foder? On Wed, Jun 11, 2014 at 12:45 PM, Rohan Young rohan.j...@gmail.com wrote: Thanks Vaibhav bro its excellent it will help me in future but my

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

2014-06-11 Thread Rohan Young
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

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

2014-06-10 Thread Rohan Young
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

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

2014-06-10 Thread Rohan Young
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 gawlianil8...@gmail.com wrote: Dear Rohan, Pl find attached. Warm Regards, Gawli Anil/. On Tue, Jun 10, 2014 at 2:19 PM, Rohan

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

2014-06-10 Thread Rohan Young
and outgoing 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 Hi, Thanks Anil

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

2014-06-10 Thread Rohan Young
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)

$$Excel-Macros$$

2014-04-08 Thread Rohan Young
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

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

2012-11-14 Thread Rohan Young
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 prince141...@gmail.com wrote: Hi Anjali, Please set the below option in your workbook. Tools - Options - Formulas -

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

2012-11-05 Thread Rohan Young
Congratulation Rajan On Tue, Nov 6, 2012 at 11:28 AM, Rajesh Nair nairra...@gmail.com wrote: Congrats Rajan On Tue, Nov 6, 2012 at 10:23 AM, Kuldeep Singh naukrikuld...@gmail.comwrote: Hi, *Congratulations* Rajan Sir. Regards, Kuldeep Singh Back Office Executive (MIS) Info Edge

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

2012-11-03 Thread Rohan Young
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 isk1...@gmail.com wrote: *Thanks Kuldeep for your reply.* *I want the cursor should go

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

2012-11-03 Thread Rohan Young
hi raja, its not working regds On Sat, Nov 3, 2012 at 10:03 PM, RAJA SEKAR apkra...@gmail.com wrote: On 3 November 2012 15:44, Pravin Gunjal isk1...@gmail.com wrote: *Thanks Kuldeep for your reply.* *I want the cursor should go in the cell D1 when the ENTER key is pressed.* * *

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

2012-11-03 Thread Rohan Young
HI, TRY DIS =LEFT(B12,2)LEFT(C12,2)LEFT(D12,2) REGDS On Sat, Nov 3, 2012 at 11:14 PM, cyberuser netuser...@gmail.com 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

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

2012-11-03 Thread Rohan Young
plz put range as per ur requirement On Sat, Nov 3, 2012 at 11:24 PM, Rohan Young rohan.j...@gmail.com wrote: HI, TRY DIS =LEFT(B12,2)LEFT(C12,2)LEFT(D12,2) REGDS On Sat, Nov 3, 2012 at 11:14 PM, cyberuser netuser...@gmail.com wrote: Hi, Is there a formula that would the 2 first

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

2012-11-03 Thread Rohan Young
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 netuser...@gmail.com 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$$ Pls help

2012-11-01 Thread Rohan Young
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 macro ,

Re: $$Excel-Macros$$ Serial no

2012-10-31 Thread Rohan Young
hi Prashant, PFA regds On Wed, Oct 31, 2012 at 5:35 PM, Prashant Pawle ppawle.ex...@gmail.comwrote: 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

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

2012-10-30 Thread Rohan Young
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:

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

2012-08-05 Thread Rohan Young
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 sagarkasangottu...@gmail.com wrote: Congratulations Noorain, All

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

2012-07-10 Thread Rohan Young
screen shot. On Fri, Jul 6, 2012 at 10:11 AM, Rohan Young rohan.j...@gmail.com wrote: Dear Ashish Ji, thanks but i m not getting the result, can you please send me the add in or anything else for it regds ROHAN On Thu, Jul 5, 2012 at 10:58 PM, ashish koul koul.ash...@gmail.com wrote: try

$$Excel-Macros$$ Mails IDs from Outlook

2012-07-05 Thread Rohan Young
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

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

2012-07-05 Thread Rohan Young
On Thu, Jul 5, 2012 at 3:52 PM, Rohan Young rohan.j...@gmail.com 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 (986+ members already BANNED for violation) 1) Use concise

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

2012-07-05 Thread Rohan Young
Next End Sub On Thu, Jul 5, 2012 at 4:39 PM, Rohan Young rohan.j...@gmail.com wrote: Dear Sanjib, Its not working improting i need to import all Mail IDs from My Sent Inbox Folder, i need any macro for this thanks On Thu, Jul 5, 2012 at 4:01 PM, Sanjib Chatterjee

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

2012-07-01 Thread Rohan Young
Congratulations to both of you and thanks for being with us On Sun, Jul 1, 2012 at 11:32 PM, Dilip Pandey dilipan...@gmail.com 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..

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

2012-06-26 Thread Rohan Young
Dear Neeraj, See the attachment, if help Regds ROHAN On Tue, Jun 26, 2012 at 2:11 PM, Neeraj Chauhan neerajchauhan...@gmail.comwrote: Siwaya Sikhera 1 Maithna Inder Singh Salarpur Niit Pela Sofipur Ganga Nagar Pallavpuram Pallav Puram

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

2012-06-22 Thread Rohan Young
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 ksuman1...@gmail.com wrote: Hi Dear ! Please use this formula if its help you. =Text(Today()-that cell which contain ur birth date,yy) Regards, @Suman

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

2012-03-15 Thread Rohan Young
*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 gjmothi...@gmail.com

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

2012-02-24 Thread Rohan Young
Gud1 Noorain Bhai - carry on On Fri, Feb 24, 2012 at 6:09 PM, Shaik Waheed waheedb...@gmail.com 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 kalx...@gmail.com wrote: NOORAIN ROCKS ONCE

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

2012-02-04 Thread Rohan Young
CONGRATULATION NOORAIN BHAI, CARRY ON. On Sat, Feb 4, 2012 at 10:47 AM, Venkat CV venkat1@gmail.com wrote: Congrats... Noorain Everyone... *Best Regards,* *Venkat * *Chennai* *My Linked in profile http://in.linkedin.com/pub/venkatesan-c/21/492/a71 * On Wed, Feb 1, 2012 at 10:11

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

2011-09-29 Thread Rohan Young
Dear Paul, please do the needful thanks regds ROHAN On Wed, Sep 28, 2011 at 11:31 AM, Rohan Young rohan.j...@gmail.com 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, 2011 at 6:50 PM, Paul

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

2011-09-28 Thread Rohan Young
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 - From: Rohan Young rohan.j

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

2011-09-27 Thread Rohan Young
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 - From: Rohan Young rohan.j...@gmail.com

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

2011-09-27 Thread Rohan Young
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 rohan.j...@gmail.com To: excel-macros@googlegroups.com Sent: Tue, September 27, 2011 8:25

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

2011-09-27 Thread Rohan Young
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, dguillett1 dguille...@gmail.com wrote: Can

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

2011-05-31 Thread Rohan Young
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 rohan.j...@gmail.com wrote: Dear Ashish Ji, Please help me out

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

2011-05-28 Thread Rohan Young
...@yahoo.co.in 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 Message From: Rohan Young rohan.j...@gmail.com To: excel

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

2011-05-28 Thread Rohan Young
waiting for reply, please someone can help on it Regd ROHAN On Sat, May 28, 2011 at 11:09 AM, Rohan Young rohan.j...@gmail.com 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 have

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

2011-05-28 Thread Rohan Young
Dear Ashish Ji, Please help me out on this, THANKS ROHAN On Sat, May 28, 2011 at 3:01 PM, Rohan Young rohan.j...@gmail.com wrote: waiting for reply, please someone can help on it Regd ROHAN On Sat, May 28, 2011 at 11:09 AM, Rohan Young rohan.j...@gmail.com wrote: Dear Hanumat

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

2011-05-10 Thread Rohan Young
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

2011-04-26 Thread Rohan Young
Thank you very much Ashish Ji, very sorry for late reply Redgs ROHAN On Thu, Apr 21, 2011 at 4:00 PM, ashish koul koul.ash...@gmail.com wrote: rohan try this =IF(ABS(C3-B3)=0.1,B3,C3) On Thu, Apr 21, 2011 at 1:49 PM, Rohan Young rohan.j...@gmail.com wrote: Dear Ashish, please

Re: $$Excel-Macros$$ Need Help

2011-04-21 Thread Rohan Young
Dear rajan, i need output figure not blank cell thanks On Wed, Apr 20, 2011 at 3:46 PM, rajan verma rajanverma1...@gmail.comwrote: =IF((C3-B3)0.01,C3, -- -- Some important links for excel users: 1. Follow us on

Re: $$Excel-Macros$$ Need Help

2011-04-21 Thread Rohan Young
Dear Ashish, please sought it out my problem as attached thanks Rohan On Thu, Apr 21, 2011 at 12:02 PM, Rohan Young rohan.j...@gmail.com wrote: Dear rajan, i need output figure not blank cell thanks On Wed, Apr 20, 2011 at 3:46 PM, rajan verma rajanverma1...@gmail.comwrote: =IF((C3

$$Excel-Macros$$ Need Help

2011-04-20 Thread Rohan Young
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

Re: $$Excel-Macros$$ Need Help

2011-04-20 Thread Rohan Young
? 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@googlegroups.com *Objet :* $$Excel-Macros$$ Need Help Dear gurus

Re: $$Excel-Macros$$ Need Help

2011-04-20 Thread Rohan Young
? 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@googlegroups.com *Objet :* $$Excel-Macros$$ Need Help Dear gurus

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

2011-02-24 Thread Rohan Young
Hi, see the attachment if it help thanks regds, ROHAN On Thu, Feb 24, 2011 at 8:05 PM, John A. Smith johnasmit...@gmail.comwrote: 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

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

2011-02-24 Thread Rohan Young
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 *Ex-n-Trick-in-XL (Excentric in Excel)* Thanks Regds, ROHAN

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

2011-02-22 Thread Rohan Young
Password:=ashish End Sub On Tue, Feb 22, 2011 at 12:10 PM, Rohan Young rohan.j...@gmail.comwrote: 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

$$Excel-Macros$$ Help on Macro Code

2011-02-22 Thread Rohan Young
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$$ Macro Help - Please!

2011-02-22 Thread Rohan Young
HI Kamal, Please see the attachment if it helps, Regards ROHAN On Tue, Feb 22, 2011 at 6:33 PM, NOORAIN ANSARI noorain.ans...@gmail.comwrote: Dear Kamal, Please see attached sheet..if it help.. On Mon, Feb 21, 2011 at 11:25 PM, kamal shah kamal...@gmail.com wrote: Hello Excel Gurus,

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

2011-02-21 Thread Rohan Young
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

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

2011-02-06 Thread Rohan Young
Hi Dave, wonderful its a great job Regards ROHAN On Sun, Feb 6, 2011 at 4:40 AM, Dave Bonallack davebonall...@hotmail.comwrote: 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

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

2011-02-02 Thread Rohan Young
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 hanumant_5...@yahoo.co.inwrote: Congrats ashish. He is really

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

2011-02-02 Thread Rohan Young
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 =(11)

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

2011-01-31 Thread Rohan Young
may it help you http://www.islamicfinder.org/Hcal/index.php On Mon, Jan 31, 2011 at 8:30 PM, Ahmed Honest ahmedhon...@gmail.com wrote: Georgian Date -- -- Some important links for excel users: 1. Follow us on

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

2011-01-31 Thread Rohan Young
find the attachment, it may help Regards ROHAN On Tue, Feb 1, 2011 at 12:02 PM, Rohan Young rohan.j...@gmail.com wrote: may it help you http://www.islamicfinder.org/Hcal/index.php On Mon, Jan 31, 2011 at 8:30 PM, Ahmed Honest ahmedhon...@gmail.comwrote: Georgian Date

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

2011-01-19 Thread Rohan Young
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

2011-01-18 Thread Rohan Young
HI, See the attachment Regards ROHAN On Tue, Jan 18, 2011 at 11:58 AM, San Pat myitems2...@gmail.com 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.

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

2011-01-13 Thread Rohan Young
Hi, see attachment hope it may help thanks Regards ROHAN 9818247278, 8860567680 On Thu, Jan 13, 2011 at 8:51 PM, ashish koul koul.ash...@gmail.com wrote: attachement missing On Thu, Jan 13, 2011 at 7:11 PM, mikeb mb...@allstate.com wrote: I would appreciate some help with the

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

2011-01-13 Thread Rohan Young
Hi, i got it, in the tab homefind selectselection panehide all or as you want thanks regards ROHAN 9818247278, 8860567680 On Fri, Jan 14, 2011 at 12:14 PM, Rohan Young rohan.j...@gmail.com wrote: Hi, see the attachement for my prob., i made a drop down but after removing the list

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

2011-01-12 Thread Rohan Young
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 give us a

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

2011-01-12 Thread Rohan Young
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 rohan.j...@gmail.com wrote: please try =A1+1 (if A1 has the date 1/1/2011) On Wed

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

2011-01-04 Thread Rohan Young
is worng. Thanks Regards ROHAN 9818247278, 8860567680 On Tue, Jan 4, 2011 at 3:37 PM, Rohan Young rohan.j...@gmail.com wrote: Hi, Please find the attachment Thanks Regards ROHAN 9818247278, 8860567680 On Tue, Jan 4, 2011 at 2:10 PM, ashish koul koul.ash...@gmail.com wrote: ignore

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

2011-01-03 Thread Rohan Young
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 nvino...@gmail.com wrote: Congratulations!! Dilipji... On Mon, Jan 3, 2011 at 3:31 PM, Ayush

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

2010-12-31 Thread Rohan Young
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

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

2010-12-30 Thread Rohan Young
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

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

2010-12-27 Thread Rohan Young
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 jva.ch...@gmail.com wrote: how to attach excel sheet to this blog posts --

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

2010-12-20 Thread Rohan Young
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

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

2010-12-17 Thread Rohan Young
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 arsfan2...@yahoo.co.inwrote: hey guys, need some help here. 1. how can i get to know if a specific

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

2010-12-15 Thread Rohan Young
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.com] *De la part de* Rohan Young *Envoyé :* mardi