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 wrote: > Question not clear > > On Mon, Jul 17, 2017 at 9:13 AM, Rakesh kumar > wrote: > >> Hi Friends, >> >> I need urgent help, If any one can help me. >>

$$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 wan

$$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
can 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, acc

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

$$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 o

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

Re: $$Excel-Macros$$ Urgent help

2014-12-16 Thread Rakesh kumar
t; > On Tue, Dec 16, 2014 at 5:03 PM, Rakesh kumar > 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. >> >> >> --

$$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:I

$$Excel-Macros$$ Data validation help

2014-06-17 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) or =NOT

$$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$$ Help Needed

2014-06-17 Thread Rakesh kumar
Thanks Brother, But how you Did this. Please explain the process. On Tue, Jun 17, 2014 at 1:02 PM, Dhaval Shah wrote: > fyi > > Warm Regards, > > Dhaval Shah > M) 98240 35253 > *E-mail : todhavals...@gmail.com * > > > > > On Tue, Jun 17, 2014 at 12:51 PM,

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

$$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 pa

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

2014-02-14 Thread Rakesh Kumar Sharma
. 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://www.facebook.c

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

2014-02-01 Thread Rakesh Kumar Sharma
gt; > > On Sat, Feb 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: >> >>>

$$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 wrote: > Hi , > > Attachment is missing dear. > > > > > On Sat, Feb 1, 2014 at 11:58 AM, Rakesh Kumar Sharma < > rakeshks@gmail.com> wrote: > >> Dear Experts, >> >

$$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 of

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 wrote: > =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 &g

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 wrote: > Hi Experts, > > pl find the attached data file. > > -- > Regards, > > Rakesh Kumar Sharma > Contact: +91-9971024741 > > -- > Are you =EXP(E:RT) or

Re: $$Excel-Macros$$ Help Required

2014-01-24 Thread Rakesh kumar
Thanks Ravinder. On Fri, Jan 24, 2014 at 4:37 PM, Ravinder wrote: > 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.

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

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

$$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 wrote: > > 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-9650

$$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 of

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

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

2013-07-03 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 wrote: > PFA > > > On Thu, Jul 4, 2013 at 11:42 AM, Rakesh Kumar Sharma < > rakeshks@gmail.com> wrote: > >> Dear Experts, >> I want Result o

$$Excel-Macros$$ required Result on Conditions

2013-07-03 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$$ 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 wrote: > 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 ku

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 wrote: > Hi Rakesh, > Please see the attachment. > Regards, > Priti verma > > > On Tue, Apr 30, 2013 at 5:22 PM, Rakesh kumar wrote: > >> Th

Re: $$Excel-Macros$$ Help Required

2013-04-30 Thread Rakesh kumar
dea just google it to learn Pivot tables / go to >> youtube to learn pivot table. You will learn less time. >> >> Start exploring. >> >> Thanks, >> >> >> >> >> On Tue, Apr 30, 2013 at 2:04 PM, Rakesh kumar wrote: >> >>> Hi Friends, &

$$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$$ 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 wrote: > 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 <

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

$$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 th

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

2012-12-03 Thread Rakesh Kumar Sharma
RULES > > 1) Use concise, accurate thread titles. Poor thread titles, like Please > Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice > will not get quick attention or may not be answered. > 2) Don't post a question in the thread of another member. > 3) D

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

2012-11-20 Thread Rakesh Kumar Sharma
> >>> Hi experts, >>> I want to split a cell to multiple cells. Pls help me. >>> >>> -- >>> Regards, >>> >>> Rakesh Kumar Sharma >>> Contact: +91-9971024741 >>> >>> >>> -- >> Join offi

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

2012-10-11 Thread Rakesh Kumar Sharma
*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

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 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 the form

$$Excel-Macros$$ How we use CHOOSE function with VLOOKUP in Excel

2012-10-09 Thread Rakesh Kumar Sharma
Dear Experts, I want to know How we can use CHOOSE function with VLOOKUP in Excel. -- 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) 1

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

2012-09-03 Thread Rakesh Kumar Sharma
:07 PM UTC+5:30, 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, &g

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

2012-09-03 Thread Rakesh Kumar Sharma
, Manoj Kumar wrote: > 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 n

$$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$$ Noorain Ansari - Most Helpful Member August 2012

2012-09-02 Thread Rakesh Kumar Sharma
Jobs posting is not allowed. >> >> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. >> >> NOTE : Don't ever post personal or confidential data in a workbook. Forum >> owners and members are not responsible for any loss. >> --- >&g

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

2012-08-29 Thread Rakesh Kumar Sharma
-macros@googlegroups.com [mailto: > 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** > ** > > ** ** >

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 wrote: > Dear Rakesh, > > See attached sheet. > > > On Fri, Aug 17, 2012 at 4:13 PM, Rakesh Kumar Sharma < > rakeshks@gmail.com> wro

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

2012-08-21 Thread Rakesh Kumar Sharma
, Aug 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, >

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

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 wrote: > Dear Noorain/ Amresh, > > > Thank u so much for great helping. > > > > On Thu, Aug

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 wrote: > Dear Noorain/ Amresh, > > > Thank u so much for great helping. > > > > On Thu,

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

2012-08-16 Thread Rakesh Kumar Sharma
w.noorainansari.com>noorainansari.com<http://www.noorainansari.com> >> http:// >> <http://www.excelvbaclinic.blogspot.com>excelvbaclinic.com<http://www.excelvbaclinic.blogspot.com> >> >> >> On Thu, Aug 16, 2012 at 1:01 PM, Rakesh Kumar Sharma < >

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 wrote: > > 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&g

$$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-997102

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

2012-06-12 Thread Rakesh Kumar Sharma
ok 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

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

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

2012-05-13 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

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 wrote: > ll the options in the Range:List -- Rakesh kumar khowal -- -- Some important links for excel users: 1. Follow us on

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

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

2011-04-04 Thread rakesh kumar
ields("Q3_Village") .Orientation = xlDataField .Position = 1 End With End With -- Rakesh kumar khowal -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and li

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

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

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

2011-04-03 Thread rakesh kumar
ach the excel sheet > > Regards > Umesh Dev > > > On Fri, Apr 1, 2011 at 4:29 PM, rakesh kumar wrote: > >> 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 leav

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

2011-04-01 Thread rakesh kumar
esn't 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

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

2011-03-18 Thread rakesh kumar
search for the string using Find&Replace Feb 11 - Circle\AA\GA - AA_F&F_FEB and replace with Mar 11 - Circle\AA\GA - AA_F&F_MAR On Thu, Mar 17, 2011 at 10:38 PM, Ankit wrote: > _MAR_ -- Rakesh kumar khowal +91 9540084660

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

2011-03-18 Thread rakesh kumar
spot.com > > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><><><><><><><><><><><><><><><> > Like our page on facebook , Just follow below

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«§ wrote: > at this, i did something by using function, > find the attachment. > -- Rakesh kumar khowal +91 954008

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

2011-02-24 Thread rakesh kumar
ks and links : > http://twitter.com/exceldailytip > 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 > 3. Excel tutorials at http://www.excel-macros.blogspot.com > 4. Learn VBA Macros at

Re: $$Excel-Macros$$ Insert Row after Change in Value in a Selection

2011-02-23 Thread rakesh kumar
gt;<><><><><><><><><><><><><><><><><><><> > Like our page on facebook , Just follow below link > http://www.facebook.com/discussexcel > > -- > >

Re: $$Excel-Macros$$ Macro DataMatchError

2011-02-22 Thread rakesh kumar
os at http://www.quickvba.blogspot.com > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><>

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

2011-02-21 Thread rakesh kumar
st. > > As in: > A B C D E > 1 1 0 0 1 > becomes: > A B C D E > 1 1 0 1 > when column C is deleted, the loop then checks column D > in the next iteration. > > When deleting rows or columns, I prefer to work "backwards", like: > > For ColNo = 750 To 1 S

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 wrote: > *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) = &

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

2011-02-20 Thread rakesh kumar
What is not working ? Do you get an error ? > > What are you trying to do ? > > Daniel > > > > *De :* excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] > *De la part de* rakesh kumar > *Envoyé :* dimanche 20 février 2011 11:16 > *À :* excel-macros@googlegrou