Re: $$Excel-Macros$$ Urgent Help required

2017-07-17 Thread Rakesh kumar
see this attachment. hope it makes you understand. On Mon, Jul 17, 2017 at 11:59 AM, Saleem Ansari <saleem.logic...@gmail.com> wrote: > Question not clear > > On Mon, Jul 17, 2017 at 9:13 AM, Rakesh kumar <rakesh.apt...@gmail.com> > wrote: > >> Hi Friends, >

$$Excel-Macros$$ Urgent Help required

2017-07-16 Thread Rakesh kumar
Hi Friends, I need urgent help, If any one can help me. actually I have got one assignment, I need to solve it, but I'm completely stuck into this. Please see the attachment and help. -- Thanks £ Regards Rakesh Kumar -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna

$$Excel-Macros$$ Avarage calculation

2015-04-09 Thread Rakesh kumar
Hi, I want to put Avarage formulla with multiple conditions in same column. Please see the attechment and put the formulla Please do it on urgent basis if possible. -- Thanks £ Regards Rakesh Kumar +91-9650303464 -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s

$$Excel-Macros$$ Calender Control

2015-03-31 Thread Rakesh kumar
unable to find out. Please guide me how to add this. -- Thanks £ Regards Rakesh Kumar +91-9650303464 -- 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

$$Excel-Macros$$ how to run SQL Query in Excel to retrive a set of Data.

2015-03-23 Thread Rakesh kumar
anybody guide to me. -- Thanks £ Regards Rakesh Kumar +91-9650303464 -- 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

$$Excel-Macros$$ DailyTransport cost tracker.

2015-03-04 Thread Rakesh Kumar Sharma
Hi Team, Request you to share a Daily Transport cost Tracker format, if any one have. -- Regards, Rakesh Kumar Sharma Contact: +91-9971024741 -- 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

$$Excel-Macros$$ Information Required

2015-02-10 Thread Rakesh kumar
in SAS. so that it would be helpfull for me to understand the SAS software. If anyone have Study meterial of SAS please send me. Thanks for time and considration. -- Thanks £ Regards Rakesh Kumar +91-9650303464 # # -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s

$$Excel-Macros$$ Help Required on Dependent Data Validation

2014-12-30 Thread Rakesh kumar
Hi, I need help on Dependent Data validation. and please try to solve it without adding any other column. -- Thanks £ Regards Rakesh Kumar +91-9650303464 # -- 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

$$Excel-Macros$$ Urgent help

2014-12-16 Thread Rakesh kumar
HI frinds, i want split cells value in diffrent row using macros, please see the attechment. Please do it urgent basis if any one can. -- Thanks £ Regards Rakesh Kumar +91-9650303464 # -- 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$$ Urgent help

2014-12-16 Thread Rakesh kumar
at 5:03 PM, Rakesh kumar rakesh.apt...@gmail.com wrote: HI frinds, i want split cells value in diffrent row using macros, please see the attechment. Please do it urgent basis if any one can. -- Thanks £ Regards Rakesh Kumar +91-9650303464 #14a52ee67592ee7c_14a52e08adaa996f_

Re: $$Excel-Macros$$ Urgent help

2014-12-16 Thread Rakesh kumar
I want all, whatever the is available on sheets. On Tue, Dec 16, 2014 at 5:47 PM, Vaibhav Joshi v...@vabs.in wrote: ok, do you want both or unique one? + *I did not do this for you. God is here working through me for you.* On Tue, Dec 16, 2014 at 5:43 PM, Rakesh kumar rakesh.apt

$$Excel-Macros$$ Data validation help

2014-06-18 Thread Rakesh kumar
Dear Friends, i want to use data validation in excel. first validation - Value would not be repeat in list. and In second Validation , show only those value which is belongs to first value. please find the Sample sheets. -- Thanks £ Regards Rakesh Kumar -- Are you =EXP(E:RT

$$Excel-Macros$$ Help Needed

2014-06-17 Thread Rakesh kumar
Hi Guys, I want to use formula on pivot table data. Kindly help me. -- Thanks £ Regards Rakesh Kumar +91-9650303464 -- 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

Re: $$Excel-Macros$$ Help Needed

2014-06-17 Thread Rakesh kumar
kumar rakesh.apt...@gmail.com wrote: Hi Guys, I want to use formula on pivot table data. Kindly help me. -- Thanks £ Regards Rakesh Kumar +91-9650303464 -- 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

$$Excel-Macros$$ Needs help in Data validation

2014-06-17 Thread Rakesh kumar
PFA -- Thanks £ Regards Rakesh Kumar +91-9650303464 -- 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

Re: $$Excel-Macros$$ Re: [XL-VBA Clinic] Extracting Google spreadsheet data on MS Excel daily automatically

2014-03-20 Thread Rakesh Kumar Sharma
Dear Experts, Please solve the query if possible. On Wed, Mar 19, 2014 at 2:16 PM, Rakesh Kumar Sharma rakeshks@gmail.com wrote: Dear Varun, Pls find the attached format. Same file will be shared with team also. thwy will update location wise on sheets On Wed, Mar 19, 2014 at 2

$$Excel-Macros$$ Extracting Google spreadsheet data on MS Excel daily automatically

2014-03-19 Thread Rakesh Kumar Sharma
data as team insert or summarized, does not matters. Pls suggest me, is this possible, if Yes, then How? -- Regards, Rakesh Kumar Sharma Contact: +91-9971024741 -- 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

$$Excel-Macros$$ Fwd: [XL-VBA Clinic] PIVOT TABLE BASED ON CELL VALUE

2014-02-14 Thread Rakesh Kumar Sharma
...@googlegroups.com. For more options, visit https://groups.google.com/groups/opt_out. -- Regards, Rakesh Kumar Sharma Contact: +91-9971024741 -- 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$$ Re: [XL-VBA Clinic] Offset Query

2014-02-01 Thread Rakesh Kumar Sharma
1, 2014 at 12:38 PM, Rakesh Kumar Sharma rakeshks@gmail.com wrote: Pls find the attached file. On Sat, Feb 1, 2014 at 12:03 PM, saurabh kumar saurabhkumar8...@gmail.com wrote: Hi , Attachment is missing dear. On Sat, Feb 1, 2014 at 11:58 AM, Rakesh Kumar Sharma rakeshks

$$Excel-Macros$$ Offset Query

2014-01-31 Thread Rakesh Kumar Sharma
Dear Experts, Pls suggest me where is mistake in attached sheet. why the last Row not showing data. -- Regards, Rakesh Kumar Sharma Contact: +91-9971024741 -- 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

$$Excel-Macros$$ Re: [XL-VBA Clinic] Offset Query

2014-01-31 Thread Rakesh Kumar Sharma
Pls find the attached file. On Sat, Feb 1, 2014 at 12:03 PM, saurabh kumar saurabhkumar8...@gmail.comwrote: Hi , Attachment is missing dear. On Sat, Feb 1, 2014 at 11:58 AM, Rakesh Kumar Sharma rakeshks@gmail.com wrote: Dear Experts, Pls suggest me where is mistake in attached

Re: $$Excel-Macros$$ Please Help

2014-01-29 Thread Rakesh kumar
Well done Ravindre, Thanks On Thu, Jan 30, 2014 at 11:59 AM, Ravinder ravinderexcelgr...@gmail.comwrote: =TEXT(MAX((H2=$B$2:$B$1944)*$D$2:$D$1944),MM/DD/ H:MM) with CSE *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *Rakesh kumar *Sent

$$Excel-Macros$$ Help Required

2014-01-24 Thread Rakesh kumar
Hi Friends, Please find the attachment. Help Please -- Thanks £ Regards Rakesh Kumar +91-9650303464 -- 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

$$Excel-Macros$$ Required Chart with multiple criteria

2014-01-24 Thread Rakesh Kumar Sharma
Hi Experts, pl find the attached data file. -- Regards, Rakesh Kumar Sharma Contact: +91-9971024741 -- 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

Re: $$Excel-Macros$$ Help Required

2014-01-24 Thread Rakesh kumar
Thanks Ravinder. On Fri, Jan 24, 2014 at 4:37 PM, Ravinder ravindervbacli...@gmail.comwrote: PFA *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *Rakesh kumar *Sent:* Friday, January 24, 2014 4:26 PM *To:* excel-macros@googlegroups.com

Re: $$Excel-Macros$$ Required Chart with multiple criteria

2014-01-24 Thread Rakesh Kumar Sharma
Dear Experts, Pls consider on chart query. On Fri, Jan 24, 2014 at 4:59 PM, Rakesh Kumar Sharma rakeshks@gmail.com wrote: Hi Experts, pl find the attached data file. -- Regards, Rakesh Kumar Sharma Contact: +91-9971024741 -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel

$$Excel-Macros$$ Urgent Help.

2013-10-04 Thread Rakesh kumar
Dear Friend, i want to use total no of present or absent list using pivot table. Please find the attachment. -- Thanks £ Regards Rakesh Kumar +91-9650303464 -- 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

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

2013-10-04 Thread Rakesh kumar
Please find the attachment. On Sat, Oct 5, 2013 at 11:22 AM, Rakesh kumar rakesh.apt...@gmail.comwrote: Dear Friend, i want to use total no of present or absent list using pivot table. Please find the attachment. -- Thanks £ Regards Rakesh Kumar +91-9650303464 -- Thanks

$$Excel-Macros$$ Query in Pivot Table

2013-07-11 Thread Rakesh Kumar Sharma
Dear Experts, I have a query related to Pivot Table. Pls refer to attachment. -- Regards, Rakesh Kumar Sharma Contact: +91-9971024741 -- 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$$ required Result on Conditions

2013-07-04 Thread Rakesh Kumar Sharma
Dear Experts, I want Result on conditions. Pls find the attachment. -- Regards, Rakesh Kumar Sharma Contact: +91-9971024741 -- 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

Re: $$Excel-Macros$$ required Result on Conditions

2013-07-04 Thread Rakesh Kumar Sharma
Thank you so much Abhishek ji, it's working fine. On Thu, Jul 4, 2013 at 11:51 AM, Abhishek Jain abhishek@gmail.comwrote: PFA On Thu, Jul 4, 2013 at 11:42 AM, Rakesh Kumar Sharma rakeshks@gmail.com wrote: Dear Experts, I want Result on conditions. Pls find the attachment

$$Excel-Macros$$ Help Required

2013-04-30 Thread Rakesh kumar
£ Regards Rakesh Kumar +91-9650303464 -- 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

Re: $$Excel-Macros$$ Help Required

2013-04-30 Thread Rakesh kumar
Hi priti, thanks for the help, Is it possible without using another column. On Tue, Apr 30, 2013 at 5:49 PM, priti verma pritiverma1...@gmail.comwrote: Hi Rakesh, Please see the attachment. Regards, Priti verma On Tue, Apr 30, 2013 at 5:22 PM, Rakesh kumar rakesh.apt...@gmail.comwrote

Re: $$Excel-Macros$$ Help Required

2013-04-30 Thread Rakesh kumar
Hi Priti Great work, Thanku so much. Thank Raeksh k On Wed, May 1, 2013 at 9:56 AM, priti verma pritiverma1...@gmail.comwrote: Hi Rakes, Yes you can do this without using another column.Please see the attachement. Regards, Priti verma On Tue, Apr 30, 2013 at 6:12 PM, Rakesh kumar

$$Excel-Macros$$ Need formula to retrieve value

2013-02-18 Thread Rakesh Kumar Sharma
Dear Experts, I need a formula/function which can give required value. Sample file attached. Thanks in Advance -- Regards, Rakesh Kumar Sharma Contact: +91-9971024741 -- 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

Re: $$Excel-Macros$$ Need formula to retrieve value

2013-02-18 Thread Rakesh Kumar Sharma
Dear Abhishek, Working fine Will yo please explain this how it works? On Tue, Feb 19, 2013 at 12:55 PM, Abhishek Jain abhishek@gmail.comwrote: Check attached. Let us know if there is any further query. HTH Abhi On Tue, Feb 19, 2013 at 12:31 PM, Rakesh Kumar Sharma rakeshks

$$Excel-Macros$$ Formula to Calculate Age in Excel

2012-12-06 Thread Rakesh Kumar Sharma
Dear Team, Can you help me how to calculate age ( in Year, month day) in Excel -- Regards, Rakesh Kumar Sharma Contact: +91-9971024741 -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread

Re: $$Excel-Macros$$ Paul Schreiner - Most Helpful Member November'12

2012-12-03 Thread Rakesh Kumar Sharma
/group/excel-macros?hl=en. -- Regards, Rakesh Kumar Sharma Contact: +91-9971024741 -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula

Re: $$Excel-Macros$$ Re: Split a cell into multiple cells in Excel 2010

2012-11-20 Thread Rakesh Kumar Sharma
, Rakesh Kumar Sharma Contact: +91-9971024741 -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice

Re: $$Excel-Macros$$ Should Highlighted formula cell reference cell also

2012-10-11 Thread Rakesh Kumar Sharma
Dear, Pls Find the Excel file as a sample On Thu, Oct 11, 2012 at 5:39 PM, Rakesh Kumar Sharma rakeshks@gmail.com wrote: Dear Experts, Pls resolve this query. when we use any formula and press F2 then it goes highlighted and reference cells also. i want when i only select

Re: $$Excel-Macros$$ Should Highlighted formula cell reference cell also

2012-10-11 Thread Rakesh Kumar Sharma
...@gmail.comwrote: *Select Formula Cell and press Ctrl+ [ * * * * * *Regards* *Rajan verma* *+91 7838100659 [IM-Gtalk]* * * *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *Rakesh Kumar Sharma *Sent:* 11 October 2012 5:44 *To:* excel-macros

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

2012-09-03 Thread Rakesh Kumar Sharma
. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. -- Regards, Rakesh Kumar Sharma Contact: +91-9971024741 -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation

$$Excel-Macros$$ Lookup data when there are repeated data with diff amt

2012-09-03 Thread Rakesh Kumar Sharma
Hi Experts, I need the actual remit amt agnst tracking on sheet2 when data was found repeated on sheet1 with positive or nigative amt. See the attachment... -- Regards, Rakesh Kumar Sharma Contact: +91-9971024741 -- Join official facebook page of this forum @ https://www.facebook.com

Re: $$Excel-Macros$$ Lookup data when there are repeated data with diff amt

2012-09-03 Thread Rakesh Kumar Sharma
, Manoj Kumar kumarmanoj.11...@gmail.comwrote: Dear Rakesh, Use *=SUMIFS(Sheet1!$D$2:$D$18,Sheet1!$B$2:$B$18,A2)* Regd Manoj On Mon, Sep 3, 2012 at 1:00 PM, Rakesh Kumar Sharma rakeshks@gmail.com wrote: Hi Experts, I need the actual remit amt agnst tracking on sheet2 when data

Re: $$Excel-Macros$$ Re: Lookup data when there are repeated data with diff amt

2012-09-03 Thread Rakesh Kumar Sharma
, rakesh sharma wrote: Hi Experts, I need the actual remit amt agnst tracking on sheet2 when data was found repeated on sheet1 with positive or nigative amt. See the attachment... -- Regards, Rakesh Kumar Sharma Contact: +91-9971024741 -- Join official facebook page of this forum

Re: $$Excel-Macros$$ Merging Two excel sheets on single sheet

2012-08-29 Thread Rakesh Kumar Sharma
: excel-macros@googlegroups.com] *On Behalf Of *Rakesh Kumar Sharma *Sent:* Tuesday, August 21, 2012 6:27 PM *To:* excel-macros@googlegroups.com *Subject:* Re: $$Excel-Macros$$ Merging Two excel sheets on single sheet** ** ** ** Dear Noorain, Plz find the sample file. I need to combine

Re: $$Excel-Macros$$ How can i reduce file size of a Excel file

2012-08-22 Thread Rakesh Kumar Sharma
Hi Noorain, If i want to pick data of column2 then how it works? See attachment. On Fri, Aug 17, 2012 at 4:33 PM, NOORAIN ANSARI noorain.ans...@gmail.comwrote: Dear Rakesh, See attached sheet. On Fri, Aug 17, 2012 at 4:13 PM, Rakesh Kumar Sharma rakeshks@gmail.com wrote: Hi

Re: $$Excel-Macros$$ Merging Two excel sheets on single sheet

2012-08-21 Thread Rakesh Kumar Sharma
21, 2012 at 5:17 PM, Rakesh Kumar Sharma rakeshks@gmail.com wrote: Dear Experts, Is there any way to merge or combine data of two sheets on a single sheet. -- Regards, Rakesh Kumar Sharma Contact: +91-9971024741 -- Join official facebook page of this forum @ https

Re: $$Excel-Macros$$ How can i reduce file size of a Excel file

2012-08-17 Thread Rakesh Kumar Sharma
Hi Noorain, As you told to use INDEX MATCH to replace VLOOKUP . plz find the attached file share how to use these On Thu, Aug 16, 2012 at 6:11 PM, Rakesh Kumar Sharma rakeshks@gmail.com wrote: Dear Noorain/ Amresh, Thank u so much for great helping. On Thu, Aug 16, 2012 at 4:21

Re: $$Excel-Macros$$ How can i reduce file size of a Excel file

2012-08-17 Thread Rakesh Kumar Sharma
Hi Noorain, As you told to use INDEX MATCH to replace VLOOKUP . Plz find the attached file share how to use these On Thu, Aug 16, 2012 at 6:11 PM, Rakesh Kumar Sharma rakeshks@gmail.com wrote: Dear Noorain/ Amresh, Thank u so much for great helping. On Thu, Aug 16, 2012 at 4:21

Re: $$Excel-Macros$$ How can i reduce file size of a Excel file

2012-08-17 Thread Rakesh Kumar Sharma
plz ignore On Fri, Aug 17, 2012 at 5:34 PM, Rakesh Kumar Sharma rakeshks@gmail.com wrote: Hi Noorain, As you told to use INDEX MATCH to replace VLOOKUP . Plz find the attached file share how to use these On Thu, Aug 16, 2012 at 6:11 PM, Rakesh Kumar Sharma rakeshks@gmail.com

$$Excel-Macros$$ How can i reduce file size of a Excel file

2012-08-16 Thread Rakesh Kumar Sharma
Hi Experts, I have a sheet of 70MB. I am facing problem when using formulas filters. It gets slow. I am using Excel 2010. Is there any way to prevent to being slow process or any format where i can work on a reduced file size. -- Regards, Rakesh Kumar Sharma Contact: +91-9971024741

Re: $$Excel-Macros$$ How can i reduce file size of a Excel file

2012-08-16 Thread Rakesh Kumar Sharma
Dear Kuldeep, It's too large size On Thu, Aug 16, 2012 at 1:03 PM, Kuldeep Singh naukrikuld...@gmail.comwrote: Hi Rakesh, Please Share a sample worksheet. Regards, Kuldeep Singh On Thu, Aug 16, 2012 at 1:01 PM, Rakesh Kumar Sharma rakeshks@gmail.com wrote: Hi Experts, I have

Re: $$Excel-Macros$$ How can i reduce file size of a Excel file

2012-08-16 Thread Rakesh Kumar Sharma
at 1:01 PM, Rakesh Kumar Sharma rakeshks@gmail.com wrote: Hi Experts, I have a sheet of 70MB. I am facing problem when using formulas filters. It gets slow. I am using Excel 2010. Is there any way to prevent to being slow process or any format where i can work on a reduced file size

$$Excel-Macros$$ I want to learn macro from basic level

2012-06-12 Thread Rakesh Kumar Sharma
Hi Masters, If you have any attachment which can help me to learn excel macro from starting point, plz share. -- *Regards, Rakesh Kumar Sharma Contact: +91-9971024741 * -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles

Re: $$Excel-Macros$$ I want to learn macro from basic level

2012-06-12 Thread Rakesh Kumar Sharma
.. Really nice book to start from scratch. * * *Regards* *Rajan verma* *+91 7838100659 [IM-Gtalk]* ** ** *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *Rakesh Kumar Sharma *Sent:* 12 June 2012 3:00 *To:* excel-macros@googlegroups.com

$$Excel-Macros$$ Query for Merging two excel sheets using Command Prompt

2012-05-14 Thread Rakesh Kumar Sharma
Hi, Plz suggest me how i can merge two excel files data to single sheet using command prompt. -- Thanks Regards, Rakesh Kumar Sharma -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help

Re: $$Excel-Macros$$ Drop down button in cell

2011-04-12 Thread rakesh kumar
that's nice.. very handy On Tue, Apr 12, 2011 at 12:30 AM, Ramkesh Maurya sunscel...@gmail.comwrote: ll the options in the Range:List -- Rakesh kumar khowal -- -- Some important links for excel users: 1

$$Excel-Macros$$ Drop down button in cell

2011-04-11 Thread rakesh kumar
HI Group, I have been trying to put one drop down menu in cell, which should be visible only when the particular cell is clicked. I have seen such drop down menu to appear in many spreadsheets posted here for examples, but couldn't achieve that. -- Rakesh --

Re: $$Excel-Macros$$ Pivot table - Pivot tabel row Range

2011-04-04 Thread rakesh kumar
Could you tell me what have you done ??? On Sun, Apr 3, 2011 at 8:42 PM, Jaideep Panchal jai.ca...@gmail.com wrote: if it helps... -- Rakesh kumar khowal +91 9868532105 -- -- Some important links for excel

$$Excel-Macros$$ - Pivot table .Calculation = xlPercentOfColumn

2011-04-04 Thread rakesh kumar
.Position = 1 End With End With -- Rakesh kumar khowal -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http

Re: $$Excel-Macros$$ Pivot table - Pivot tabel row Range

2011-04-03 Thread rakesh kumar
the excel sheet Regards Umesh Dev On Fri, Apr 1, 2011 at 4:29 PM, rakesh kumar rakeshshail2...@gmail.comwrote: Hi ! Group members, I have a pivot table, which shows 5 income groups in row Range and their counts. However, when I apply a filter it leaves 3 income groups in the row range

$$Excel-Macros$$ Pivot table - Pivot tabel row Range

2011-04-01 Thread rakesh kumar
match the filter criteria it should show 0 or anything else will just do. any idea ??? Thanks !! -- Rakesh kumar khowal -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks

Re: $$Excel-Macros$$ Remove text from a string

2011-03-18 Thread rakesh kumar
, Just follow below link http://www.facebook.com/discussexcel -- Rakesh kumar khowal +91 9540084660 +91 9868532105 -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links

Re: $$Excel-Macros$$ Pls help!!! Macro for Editi link

2011-03-18 Thread rakesh kumar
search for the string using FindReplace Feb 11 - Circle\AA\GA - AA_FF_FEB and replace with Mar 11 - Circle\AA\GA - AA_FF_MAR On Thu, Mar 17, 2011 at 10:38 PM, Ankit ankit.ha...@gmail.com wrote: _MAR_ -- Rakesh kumar khowal +91 9540084660 +91 9868532105

Re: $$Excel-Macros$$ regd: drop down button

2011-02-28 Thread rakesh kumar
How does that drop down button auto hides. Could you please tell me ? How do I place same in my excel sheet. Regards On Mon, Feb 28, 2011 at 12:56 PM, §»VIPER«§ viper@gmail.com wrote: at this, i did something by using function, find the attachment. -- Rakesh kumar khowal +91

Re: $$Excel-Macros$$ Concatenation in formula

2011-02-24 Thread rakesh kumar
://www.facebook.com/discussexcel -- Rakesh kumar khowal +91 9540084660 +91 9868532105 -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com

Re: $$Excel-Macros$$ Macro DataMatchError

2011-02-22 Thread rakesh kumar
-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- Rakesh kumar khowal +91 9540084660 +91 9868532105 -- -- Some important links for excel

Re: $$Excel-Macros$$ -- Please Help Code Doesn't Work

2011-02-21 Thread rakesh kumar
Hi Dearests, Please Help Code Doesn't Work On Mon, Feb 21, 2011 at 2:05 AM, rakesh kumar rakeshshail2...@gmail.comwrote: *thanks Daniel Ji for the reply... here what I need and what the code doesn't do.* * * *This code runs as long as the Sheets(1).Cells(2, ColNumber) = Sheets(Name).Cells

Re: $$Excel-Macros$$ CODE DOESN'T WORK

2011-02-21 Thread rakesh kumar
-macros@googlegroups.com] *De la part de* rakesh kumar *Envoyé :* dimanche 20 février 2011 21:35 *À :* excel-macros@googlegroups.com *Objet :* Re: $$Excel-Macros$$ CODE DOESN'T WORK *thanks Daniel Ji for the reply... here what I need and what the code doesn't do.* *This code runs