$$Excel-Macros$$ Need help on Arrey Formula

2016-12-01 Thread Deepak Rawat
Hi, I need to calculate final billing product of several product with respective MRP. sample file is attached. Regards, Deepak -- 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

Re: $$Excel-Macros$$ Sumif multiple column

2016-08-25 Thread Deepak Rawat
thanks a ton! On Fri, Aug 26, 2016 at 11:24 AM, 'ravinder negi' via MS EXCEL AND VBA MACROS wrote: > PFA > > > On Friday, August 26, 2016 10:52 AM, Deepak Rawat > wrote: > > > Hi, > > Need sumif function to sum multiple columns > > sample excel

$$Excel-Macros$$ Sumif multiple column

2016-08-25 Thread Deepak Rawat
Hi, Need sumif function to sum multiple columns sample excel attached. Regards, Deepak -- 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 con

$$Excel-Macros$$ macro code for array

2015-10-16 Thread Deepak Rawat
Hi Fiends, I have a data set of names in excel sheet. I need to create powerpoint slides with title that names. Need a macro code which could perform this exercise. would be more fun if we could keep formatting of the title with our choice also. you can just take any names in excel for refere

Re: $$Excel-Macros$$ Macro for Column to Rows

2015-07-24 Thread Deepak Rawat
ll 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:* Deepak Rawat > *To:* excel-macros > *Sent:* Friday, July 24, 2015 2:3

$$Excel-Macros$$ Macro for Column to Rows

2015-07-23 Thread Deepak Rawat
Hi, attached file I have a huge data to convert from column to row Raw data is in Sheet1 Final data is in Sheet2 Please give me code for vice versa Like if i want to convert data from sheet1 to sheet 2 or if i want to convert data from sheet2 to sheet 1 Regards, Deepak -- Are you

$$Excel-Macros$$ Points distribution formula

2015-02-26 Thread Deepak Rawat
Hi, I have some target achievement data. I need to make a formula to which increase points as target achievement increases gradually. sheet is attached, It is little complicated for me to how to increase gradually by a formula automatically. regards, Deepak -- Are you =EXP(E:RT) or =NOT(EXP(

$$Excel-Macros$$ Subtotal mystery

2015-01-09 Thread Deepak Rawat
HI friends, pls find attached there are 2 subtotals, there is difference coming in both on same values pls clarify how it is happening? Regards, Deepako -- 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$$ Data Clean

2014-11-02 Thread Deepak Rawat
Hi I need to clean the following mark (don't what to say) at top of the "u" *Aklūj* what i Want as *Akluj* it sa massive data to clean is there any short command in Find n Replace?? Regards, Deepak -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N

Re: $$Excel-Macros$$ Get photographs name

2014-09-16 Thread Deepak Rawat
exactly.. On Tue, Sep 16, 2014 at 12:27 PM, Vaibhav Joshi wrote: > Is your pic stored in folder & you want to list name of that pics?? > > + > *I did not do this for you. God is here working through me for you.* > > On Tue, Sep 16, 2014 at 12:20 PM, Deepak Rawat >

Re: $$Excel-Macros$$ Get photographs name

2014-09-15 Thread Deepak Rawat
* > > On Tue, Sep 16, 2014 at 11:10 AM, Deepak Rawat > wrote: > >> Hi, >> >> I need to get photograph names in excel >> I tried , i insert all the pictures in to excel and run the below macro >> but its givint >> names like Picture 1, Pcture 2

$$Excel-Macros$$ Get photographs name

2014-09-15 Thread Deepak Rawat
Hi, I need to get photograph names in excel I tried , i insert all the pictures in to excel and run the below macro but its givint names like Picture 1, Pcture 2.. But i need the actural picture name (I think we say it caption name) Kindly provide the solution Sub GetShapeNames() Dim shp

Re: $$Excel-Macros$$ Macro for data indexing

2014-04-02 Thread Deepak Rawat
Dear Ravinder, i was making mistake in selection but its working correct, kindly give me a code to reverse it my point is after doing all words in one line i could make them unique but after that i need to put in that form again Regards, Deepak Rawat On Wed, Apr 2, 2014 at 2:42 PM, Ravinder

Re: $$Excel-Macros$$ Macro for data indexing

2014-04-02 Thread Deepak Rawat
hi thanx for your reply but its not working correctly On Wed, Apr 2, 2014 at 2:42 PM, Ravinder wrote: > pfa > > > > *From:* excel-macros@googlegroups.com [mailto: > excel-macros@googlegroups.com] *On Behalf Of *Deepak Rawat > *Sent:* Wednesday, April 02, 2014 11:51 AM

$$Excel-Macros$$ Macro for data indexing

2014-04-01 Thread Deepak Rawat
Dear friends, I attached a sheet it has a data set A I need to convert data into data set B for cleaning (value is comma separated) & after cleaning and unique i have to put that data into same format as data set A i.e. comma separated on appropriate serial number i have a huge data set to clea

$$Excel-Macros$$ Need Formula

2014-03-25 Thread Deepak Rawat
Hi, is there any solution in someproduct formula to get intersect text value in 2D range: Below is the data; Bran Model - 1 Model - 2 Model - 3 Model - 4 Audi A4 A6 A8 A10 BMW Series 3 Series 5 Series 7 X6 Mercedes A Class C Class E Class S Class Brand Model Answer BMW Model - 2 Ser

Re: $$Excel-Macros$$ Need Macro or a simple easy sorting technique

2014-03-25 Thread Deepak Rawat
erstand other's program and you can also modify > according your need. > > > On Tue, Mar 25, 2014 at 10:38 AM, Deepak Rawat wrote: > >> Hi, >> >> Could u see the error.. >> >> Regards >> >> >> >> On Sun, Mar 23, 2014 at 6:29 PM

Re: $$Excel-Macros$$ Need Macro or a simple easy sorting technique

2014-03-24 Thread Deepak Rawat
Hi, Could u see the error.. Regards On Sun, Mar 23, 2014 at 6:29 PM, Deepak Rawat wrote: > i tried the code but giving ubound error, sample is attached, > kindly check > > > On Sun, Mar 23, 2014 at 6:19 PM, Deepak Rawat wrote: > >> Hi, >> i tried but not wor

Re: $$Excel-Macros$$ Need Macro or a simple easy sorting technique

2014-03-23 Thread Deepak Rawat
tempstrArr(i)) = Trim(tempstrArr(j))) Then > Exit For > End If > Next > If j = count Then >ReDim Preserve newArr(count) > newArr(count) = tempstrArr(i) > count = count + 1 >End If > > Next > > removeDupli

Re: $$Excel-Macros$$ Need Macro or a simple easy sorting technique

2014-03-20 Thread Deepak Rawat
duplicate value be deleted by macro, kindly help Regards, Deepak Rawat On Thu, Mar 20, 2014 at 2:40 PM, Divaker Pandey wrote: > use this macro > > > Sub sortCellsValue() > Dim tempStr As String, resultSet As String > Dim tempStrArr() As String > Dim i As Inte

Re: $$Excel-Macros$$ Need Macro or a simple easy sorting technique

2014-03-20 Thread Deepak Rawat
Thanx a lot Divaker!! its working the way i need Regards, Deepak Rawat On Thu, Mar 20, 2014 at 2:40 PM, Divaker Pandey wrote: > use this macro > > > Sub sortCellsValue() > Dim tempStr As String, resultSet As String > Dim tempStrArr() As String > Dim i As Inte

Re: $$Excel-Macros$$ Need Macro or a simple easy sorting technique

2014-03-20 Thread Deepak Rawat
yes but its very time consuming to do mannually sort... On Thu, Mar 20, 2014 at 2:26 PM, VJ IR wrote: > Have u tried using text to columns?? > > Its a simple way to do so. > > Regards, > Vijay Iyer > On 20 Mar 2014 14:23, "Deepak Rawat" wrote: > >>

$$Excel-Macros$$ Need Macro or a simple easy sorting technique

2014-03-20 Thread Deepak Rawat
Dear All, I have attached a sheet with rawa data & final data. I need a macro to sort coma separated data in each cell, like example is given below: NDTV, BBC, Aaj Tak, Facebook we need to change it as below *Aaj Tak, BBC, Facebook, NDTV* i have lots of data to sort, but not getting any solut

Re: $$Excel-Macros$$ Sumif Based on 2 conditions

2014-02-11 Thread Deepak Rawat
Hi, PFA Regards, Deepak Rawat On Tue, Feb 11, 2014 at 1:27 PM, Kundan Tiwary wrote: > Hi, > > Attached is the sample file, > > In the monthly part I need only monthly details and in the annual part > annual data. > > The data has to meet the condition based on branch

Re: $$Excel-Macros$$ Macro Code??

2014-01-11 Thread Deepak Rawat
Thanks Ravi its working fine! On Fri, Jan 10, 2014 at 3:29 PM, Ravinder wrote: > PFA > > > > *From:* excel-macros@googlegroups.com [mailto: > excel-macros@googlegroups.com] *On Behalf Of *Deepak Rawat > *Sent:* Thursday, January 09, 2014 10:55 AM > *To:* excel-macros >

$$Excel-Macros$$ Macro Code??

2014-01-08 Thread Deepak Rawat
Dear All, I need macro to update multiple sheets from one sheet Ref data is attached Kindly provide the best code, as if macro run once it couldn't be undo. Regards, Deepak Rawat -- 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 off

Re: $$Excel-Macros$$ Count Names City Wise

2013-05-31 Thread Deepak Rawat
Thanx !! Regards, Deepak On Fri, May 31, 2013 at 1:20 PM, priti verma wrote: > have u enter it with CSE, > PFA for better clarification > > > On Fri, May 31, 2013 at 1:17 PM, Deepak Rawat wrote: > >> its giving 1 for delhi rather than 3 >> >> Kindly check &

Re: $$Excel-Macros$$ Count Names City Wise

2013-05-31 Thread Deepak Rawat
quot;,ROW($G$4:$G$13),""),""))>0)) > > > On Fri, May 31, 2013 at 12:59 PM, Deepak Rawat wrote: > >> Hi, >> >> I need a formula to count names of managers city wise, attached >> >> Pls advise >> >> Regards, >> Deepak &g

$$Excel-Macros$$ Count Names City Wise

2013-05-31 Thread Deepak Rawat
Hi, I need a formula to count names of managers city wise, attached Pls advise Regards, Deepak -- 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$$ Uniqe date count citywise

2013-05-30 Thread Deepak Rawat
Tnanx for ur kind reply!! working f9. Regards, Deepak On Thu, May 30, 2013 at 2:26 PM, xlstime wrote: > Hi Deepak, > > Please find attached solution > > > > . > > Enjoy > Team XLS > > > > On Thu, May 30, 2013 at 1:34 PM, De

$$Excel-Macros$$ Uniqe date count citywise

2013-05-30 Thread Deepak Rawat
Hi, I have to count unique count of date citywise Kindly help on both ( formula & macro) file is attached Thanx & Regards, Deepak -- 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.faceboo

$$Excel-Macros$$ Addition of Balance

2013-05-15 Thread Deepak Rawat
Hi PFA the i have to add all the balance of three bank between two dates in "Sheet2" Kindly show the way Regards, Deepak -- 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.co

Re: $$Excel-Macros$$ split address one bye one based on "," comma

2013-05-14 Thread Deepak Rawat
HI you can use "text to column" under Data on ribbon Regards, Deepak On Mon, May 13, 2013 at 8:43 PM, Paul Schreiner wrote: > Are you wanting to do it with a macro? or simply within Excel? > > If you want to do it one time, with Excel, > it's simply a matter of selecting the column, and use Dat

Re: $$Excel-Macros$$

2013-05-14 Thread Deepak Rawat
HI, PFA Regards, Deepak On Tue, May 14, 2013 at 4:41 PM, GRKRISHNA NAIDU wrote: > Dear expert will you please help me > > i have attached file > > *I have region code under column "A" > > i need the sheet to be split according to the regions names and all values > under ROWS > > THNKS IN ADV

Re: $$Excel-Macros$$ Graph Auto Update

2013-04-23 Thread Deepak Rawat
cation please ask me again >> Thanks >> Priti verma >> >> i >> >> >> >> >> >> On Tue, Apr 23, 2013 at 6:38 PM, Deepak Rawat wrote: >> >>> HI >>> >>> how did u do this will u clarify a bit >>> >&g

Re: $$Excel-Macros$$ Graph Auto Update

2013-04-23 Thread Deepak Rawat
I think other graph is not updating automatically Regards, Deepak Rawat On Tue, Apr 23, 2013 at 7:41 PM, priti verma wrote: > I hope you got your solution > > > On Tue, Apr 23, 2013 at 7:19 PM, Deepak Rawat wrote: > >> thanx for ur consideration >> >> i need

Re: $$Excel-Macros$$ Graph Auto Update

2013-04-23 Thread Deepak Rawat
gt; > > > > On Tue, Apr 23, 2013 at 6:38 PM, Deepak Rawat wrote: > >> HI >> >> how did u do this will u clarify a bit >> >> Regards, >> Deepak >> >> >> On Tue, Apr 23, 2013 at 6:33 PM, Deepak Rawat wrote: >> >>>

Re: $$Excel-Macros$$ Graph Auto Update

2013-04-23 Thread Deepak Rawat
range by using offset. > > Regards > priti verma > > > On Tue, Apr 23, 2013 at 4:16 PM, Deepak Rawat wrote: > >> Dear all, >> >> I have a problem regarding graph auto update... >> >> I have to add date daily then i select data manually, is there an

Re: $$Excel-Macros$$ Graph Auto Update

2013-04-23 Thread Deepak Rawat
HI how did u do this will u clarify a bit Regards, Deepak On Tue, Apr 23, 2013 at 6:33 PM, Deepak Rawat wrote: > Thanx!! > exactly what i need... > > Regards, > Deepak > > > > On Tue, Apr 23, 2013 at 6:13 PM, priti verma wrote: > >> Hi Deepak, >>

Re: $$Excel-Macros$$ Graph Auto Update

2013-04-23 Thread Deepak Rawat
Thanx!! exactly what i need... Regards, Deepak On Tue, Apr 23, 2013 at 6:13 PM, priti verma wrote: > Hi Deepak, > > Please see the attachement.Here I used Dyanamic name range by using offset. > > Regards > priti verma > > > On Tue, Apr 23, 2013 at 4:16 PM, Deepak

$$Excel-Macros$$ Graph Auto Update

2013-04-23 Thread Deepak Rawat
Dear all, I have a problem regarding graph auto update... I have to add date daily then i select data manually, is there any idea that i add date and the graph update automatically? Sample is attached. regards, Deepak -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wa

Re: $$Excel-Macros$$ Need help on Graph

2013-04-11 Thread Deepak Rawat
using Macro. >>> >>> Please confirm the same whether it is correct or not . >>> >>> Regard, >>> Prafull Jadhav. >>> >>> On Wed, Apr 3, 2013 at 10:08 AM, अनिल नारायण गवली < >>> gawlianil8...@gmail.com> wrote: >>>

Re: $$Excel-Macros$$ Need help on Graph

2013-04-02 Thread Deepak Rawat
Thanx Ashish!! Regards, Deepak On Tue, Apr 2, 2013 at 7:24 PM, ashish koul wrote: > Try the attachment . double click on cell f3-f5 > > Regards > Ashish > > > On Tue, Apr 2, 2013 at 5:18 PM, Deepak Rawat wrote: > >> Hi >> >> Kindly find attached ,

$$Excel-Macros$$ Need help on Graph

2013-04-02 Thread Deepak Rawat
Hi Kindly find attached , i need a graph which change as i select the desired cell. suppose if i want to see sales then when i wil select "Sale" cell the graph should show "Sale" bars Only and so on. Regards, Deepak Rawat -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel?

$$Excel-Macros$$ Need formula for sum

2013-02-27 Thread Deepak Rawat
Hi, need formula for sum in attach Regards, Deepak -- 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 th

Re: $$Excel-Macros$$ Macro to create muliple sheets from excel

2013-02-26 Thread Deepak Rawat
still not solved On Tue, Feb 26, 2013 at 11:27 AM, Deepak Rawat wrote: > Hi, > > I have attached 2 sheets: 1-Form 2-data > I need to create multiple sheets of the form, as much is data exists. > and data should fill accordingly in each form. > > > Regards, > Deepak

$$Excel-Macros$$ Macro to create muliple sheets from excel

2013-02-25 Thread Deepak Rawat
Hi, I have attached 2 sheets: 1-Form 2-data I need to create multiple sheets of the form, as much is data exists. and data should fill accordingly in each form. Regards, Deepak -- 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 F

$$Excel-Macros$$

2013-01-31 Thread Deepak Rawat
Hi All, I need a macro for the attached file what exactly is to do, merge and center all the cells which are same macro should work on selected cells only and not on complete sheet. Thanx for ur kind help to uplift all us on same platform! Regards, Deepak -- Join official Facebook page of thi

Re: $$Excel-Macros$$ Need formula

2013-01-17 Thread Deepak Rawat
Hi, thax for reply but still unsolved in panchayat it should come 2 rather than 5 Regards, Deepak Rawat On Thu, Jan 17, 2013 at 12:27 PM, Amresh Maurya wrote: > On Thu, Jan 17, 2013 at 12:21 PM, Deepak Rawat > wrote: > > Dear Anoop, > > > > I need as i given table. >

Re: $$Excel-Macros$$ Need formula

2013-01-16 Thread Deepak Rawat
Dear Anoop, I need as i given table. regards, Deepak rawat On Thu, Jan 17, 2013 at 11:43 AM, Anoop K Sharma wrote: > Hi Deepak, > > PFA. You need to refresh the pivot on first sheet. > > Regards, > Anoop > Sr. Developer > > > On Thu, Jan 17, 2013 at 11:16 A

$$Excel-Macros$$ Need formula

2013-01-16 Thread Deepak Rawat
HI, Could u suggest any formula to get summary from the data attached in summary sheet. -- 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 Pr

Re: $$Excel-Macros$$ Data Input with times in given numbers

2012-09-28 Thread Deepak Rawat
Dear Paul Thanx for your kind reply, job done!! Regards, Deepak On Fri, Sep 28, 2012 at 3:58 PM, Deepak Rawat wrote: > Dear All > > I have a querry that i have to put date & names in number of times given > in next cell, but how to do Pls suggest > > file is attached

$$Excel-Macros$$ Data Input with times in given numbers

2012-09-28 Thread Deepak Rawat
Dear All I have a querry that i have to put date & names in number of times given in next cell, but how to do Pls suggest file is attached -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use conc

$$Excel-Macros$$ Need help in mandays

2012-08-06 Thread Deepak Rawat
Hi, I have a data where i have to calculate mandays, i hv attached a sample data in which a field is Working/OFF What i need 1. I have to calculate mandays working day + one off or weekday. 2. i have to make a date wise pivot table in wich i want, 1 where working , off where off, WOFF where Weekl

Re: $$Excel-Macros$$ Need Macro to make multiple sheets

2012-07-05 Thread Deepak Rawat
Hi Its counts are not coming correct Pls check on this. On Thu, Jul 5, 2012 at 7:16 PM, Deepak Rawat wrote: > Its working well > > Thanx!! > > > On Thu, Jul 5, 2012 at 7:12 PM, NOORAIN ANSARI > wrote: > >> Dear Deepak, >> >> Please use below code...

Re: $$Excel-Macros$$ Need Macro to make multiple sheets

2012-07-05 Thread Deepak Rawat
lTypeVisible).Copy > Sheets(Sheets.Count).Cells(1, 1) > Sheets(Sheets.Count).Columns.AutoFit > sh.Range("A1:M1").AutoFilter > Next i > End With > On Error GoTo 0 > End sub > > > See attached sheet...Ho

Re: $$Excel-Macros$$ Need Formula !!

2012-06-27 Thread Deepak Rawat
PFA Deepak Rawat On Wed, Jun 27, 2012 at 6:46 PM, Shaikh Iqbal wrote: > Dear Exports, > > Please find attached a file and help for formula as per required. > > > > > > Regards, > > Iqbal Shaikh > > -- > -- > FORUM RULES (986+ members already BANNE

Re: $$Excel-Macros$$ extract data from table

2012-06-06 Thread Deepak Rawat
Hi PFA, the solution. Regards, Deepak Rawat On Wed, Jun 6, 2012 at 12:51 AM, joseph camill wrote: > Hi, > > I have a table and need to extract data that is non-zero. > > Attached is the sample file for your reference. > > Thanks, > Joseph > > -- > FORUM RULES

Re: $$Excel-Macros$$ Find duplicates in Column B based on Column A and write a note in Column C

2012-05-24 Thread Deepak Rawat
Hi It doesn't work properly, if i add Z 45 at the end it would show closed but its should be open. Regards, Deepak Rawat On Thu, May 24, 2012 at 8:54 PM, NOORAIN ANSARI wrote: > Dear Sreenivas, > > Please try it and see attached sheet.. > > *=IF(COUNTIF($B$1:$B$6,B1)>1,&

Re: $$Excel-Macros$$ Round off function query

2012-05-10 Thread Deepak Rawat
=ROUND(E12,0) Regards, Deepak Rawat On Thu, May 10, 2012 at 5:08 PM, Ashish Bhalara wrote: > Dear expert, > > The function Round(value,0) display result i.e. 125.55 to 126 and 125.45 > to 125. > > My result: If the value 125.55 or 125.45 or 125.01 or 125.99 then output > i

$$Excel-Macros$$ Find the month of sales cross the target

2011-09-23 Thread Deepak Rawat
Hil All I have attached the file of data. My problem is i have to find the qualifying month of sales by a formula. if it does not qualify then it should reflect as "Not Qualify" Pls Help!! Regards, Deepak -- -- So

$$Excel-Macros$$ Calculation by Formula and VBA

2011-06-10 Thread Deepak Rawat
Hi All I have a problem attached herewith. I have to calculate a desired result in a cell sample data is in attached file. Is it possible to calculate the same by formula? then please provide and vba code too. this calculation is done on each row as data is row wise. One other problem is how can

Re: $$Excel-Macros$$ Help! Filtering/subtotal issue in Excel2007

2011-06-02 Thread Deepak Rawat
Hi See the attached file apply pivot table on the data, like what i have done & see the grand total. which have 3 in subtotal that is the person you want. Regards, Deepak On Thu, Jun 2, 2011 at 10:17 AM, Rajan_Verma wrote: > See if it help > > -Original Message- > From: excel-macros@g

$$Excel-Macros$$ Seperate the data in proper fomat

2011-05-24 Thread Deepak Rawat
Hi Friends, I have to seperate the data in proper formatting, Pls suggest the best worksheet is attached. Regards, Deepak -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links

Re: $$Excel-Macros$$ Simple VBA code for filter data in ascending

2011-05-24 Thread Deepak Rawat
yes Sorting On Fri, May 20, 2011 at 5:41 PM, STDEV(i) wrote: > do you mean SORTING ? > > Ascending / descending order are parameters of SORTING action > not Filtering.. > > CMIIW > > > > > On Fri, May 20, 2011 at 2:57 PM, Deepak Rawat wrote: > >>

Re: $$Excel-Macros$$ How to remove space in excel cell

2011-05-20 Thread Deepak Rawat
Hi all, Its a v good information and i also did not know this. but i want to share another way to perform the same by find an replace. copy both the spaces and put in find textbox and replace with single space " " Regards, Deepak On Wed, May 18, 2011 at 8:20 PM, STDEV(i) wrote: > check whethe

$$Excel-Macros$$ Simple VBA code for filter data in ascending

2011-05-20 Thread Deepak Rawat
Hi All I need the simplest VBA code to filter any data in ascending. Regards, Deepak -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip

$$Excel-Macros$$ Download data of Shares from NSE

2011-05-20 Thread Deepak Rawat
Hi All I want to make a dashboard in excel by downloading data from NSE website. currently i do manually, I want to do it by macro. Is there any way to do the same by running the macro. Regards, Deepak -- -- Some i

$$Excel-Macros$$ Excel Utility for retrieving data from website

2011-04-13 Thread Deepak Rawat
Hi All I want to make a utility to extract data from website or refresh after desired time and save option too. What i want exactly is : i want to extract share prices from website and want to make a dashboard type to see & save the price. otherwise i have the option to type that data manually f

$$Excel-Macros$$ How to make excel addins

2011-04-06 Thread Deepak Rawat
Hi Friends, I have made some macros for some purpose and i want to use that in my all the excels. i got information from the net that is i change the extension of file to xla and put in addin folder then it will work. But its giving error that the file is not in proper fomat. Pls help me on this

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

2011-03-18 Thread Deepak Rawat
Hi Masters, My query is to remove all the characters after the last "@" from the text. Example: The Raw test is deepak@gmail.comkaml...@yahoo.com The final text i want is deepak@gmail.comkamlesh Regards, De

Re: $$Excel-Macros$$ Pivot table problem

2011-02-01 Thread Deepak Rawat
20 | Mobile - 90290 32123 > > > > *From:* excel-macros@googlegroups.com [mailto: > excel-macros@googlegroups.com] *On Behalf Of *Deepak Rawat > *Sent:* Tuesday, February 01, 2011 11:11 AM > *To:* excel-macros@googlegroups.com > *Subject:* $$Excel-Macros$$ Pivot table probl

$$Excel-Macros$$ Pivot table problem

2011-01-31 Thread Deepak Rawat
Hi All I have a problem in fetching the data from the raw data, pls suggest the best way. Problem file is attached. There are two worksheets, 1st one is Raw Data & 2nd one is Required data. Regards, Deepak -- -- Som

$$Excel-Macros$$ Auto Reference

2011-01-21 Thread Deepak Rawat
My problem is, I want max amount in the last column but whenever i insert any column before the Max column the Max range should change automatically. I want a macro for the maximum value calculation at the last column. The sample file is attached. Regards, Deepak Rawat

Re: $$Excel-Macros$$ Is it a Challenge!!!!!

2010-12-26 Thread Deepak Rawat
Hi Daniel I really appreciate your cooperation for this problem. Special thanx to you Regards, Deepak Rawat On Fri, Dec 24, 2010 at 7:07 PM, Daniel wrote: > Hi, > > Have a look at the attached file. Deafault is current date and time. But, > if you change the date with the cale

Re: $$Excel-Macros$$ Is it a Challenge!!!!!

2010-12-23 Thread Deepak Rawat
Hi i didnt mean to hurt anybody!! Thanx Daniel for ur friendly support!!! One thing i also want in this file that the calender should take current date & time by itself. Thanx Deepak On Fri, Dec 17, 2010 at 10:27 AM, Deepak Rawat wrote: > Hi i have posted this problem two times but got n

$$Excel-Macros$$ Is it a Challenge!!!!!

2010-12-17 Thread Deepak Rawat
Enter For Example I would select in first ComboBox("cboType) "Milk" then there should come automatically some items like "Full Cream Milk", "Poly Pack" in the in second combobox("cboItem") and finally all the data should be entered in the excel sheet

$$Excel-Macros$$ UserForm Programming

2010-12-06 Thread Deepak Rawat
t;Milk" then there should come automatically some items like "Full Cream Milk", "Poly Pack" in the in second combobox("cboItem") and finally all the data should be entered in the excel sheet

$$Excel-Macros$$ UserForm Programming

2010-12-03 Thread Deepak Rawat
t;Milk" then there should come automatically some items like "Full Cream Milk", "Poly Pack" in the in second combobox("cboItem") and finally all the data should be entered in the excel sheet

$$Excel-Macros$$ Mail Merge

2010-12-01 Thread Deepak Rawat
Hi All I have a problem, I have to print stickers according to different sizes but i dont know the techniqe. Only i know that it can be done by Mail merge. please get me the way how can learn this. Regards, Deepak Rawat

$$Excel-Macros$$ Show Values in List

2010-09-19 Thread Deepak Rawat
Dear all I attached a sample file, the problem is there are two lists one is Sales_head & other is cities comes under that sales head my problem is when i select the sales head in one list then all the cities should show under that sales head in another list. Please suggest the solutions Regard

Re: $$Excel-Macros$$ Pivot table problem

2010-08-11 Thread Deepak Rawat
Thanx!! Flemos On Sat, Aug 7, 2010 at 2:50 PM, Deepak Rawat wrote: > Hi all > > I have attached a file containg pivot table with some data. > I have two qurries > 1. I want to put a foruma next to pivot table and want to copy and paste > all formula to all rows but its taking

$$Excel-Macros$$ Pivot table problem

2010-08-07 Thread Deepak Rawat
. 2. if i able to put formula in all cells then when i click on plus sign and open it i.e. if i click on Arind then when it open all cells in Arind the formula got the error #REF! how could i make the formula to sick there. Regards, Deepak Rawat

Re: $$Excel-Macros$$ date format

2010-07-20 Thread Deepak Rawat
> > Your prob will get resolved > > -- > Regards, > Prashant > > > On Tue, Jul 20, 2010 at 11:46 AM, Deepak Rawat > wrote: > >> Hi all >> >> My problem is, there is a field *Date* i want to change the format of all >> the dates. >>

$$Excel-Macros$$ date format

2010-07-19 Thread Deepak Rawat
Hi all My problem is, there is a field *Date* i want to change the format of all the dates. I used alt+shift+# but all dates are not changing then i tried to value them but the problem remains same. file is attached. Could u pls tell the exect problem with the data. Regards, Deepak -- -

Re: $$Excel-Macros$$ Outlook Problem

2010-07-15 Thread Deepak Rawat
e sent and save. The message will be sent after > that time and provided your outlook is connected. > > > > > > Regards, > > > > C.G.Kumar > > > > *From:* excel-macros@googlegroups.com [mailto: > excel-mac...@googlegroups.com] *On Behalf Of *Deepak

$$Excel-Macros$$ Outlook Problem

2010-07-14 Thread Deepak Rawat
Hi guys Sorry for outlook but i just wnat to know that is it possible to send any saved mail in outlook at any specified time automatically. Suppose i want to send any mail automatically at 10 PM, is it possible. Regards, Deepak -- --

Re: $$Excel-Macros$$ VBA code for insert data from user form

2010-07-13 Thread Deepak Rawat
Thanx!! Regards, Deepak Rawat On Tue, Jul 13, 2010 at 6:16 PM, irfan khan wrote: > Hi Deepak, > > For last row > Cells(1, 1).End(xlDown).Select > > For last column > Cells(1, 1).End(xlToRight).Select > > ---Irfan > > > On Tue, Jul 13, 2010 at 4:38 P

$$Excel-Macros$$ VBA code for insert data from user form

2010-07-13 Thread Deepak Rawat
Hi all, I want to know the code how to insert data entered in user form in excel sheet, *workbook is attached*. I also want to know the easiest code to find the last row or last column. Regards, Deepak -- -- Some i

Re: $$Excel-Macros$$ Require Froumula for change data in some other format

2010-07-02 Thread Deepak Rawat
Thanks Paul!! Its working absolutely fine. is there any formula to perfome the same. Deepak -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceld

$$Excel-Macros$$ Require Froumula for change data in some other format

2010-07-02 Thread Deepak Rawat
Hi Friends I have attached a file, there are two sheets 1st is the raw data and 2nd sheet has final data. actually i have a large number of data to work on. is there any formula or simple technique to do the same in quickly. Deepak Rawat

Re: $$Excel-Macros$$ Pivot table not showing

2010-06-21 Thread Deepak Rawat
Hi Friends Thanx for ur kind reply. Deepak On Fri, Jun 18, 2010 at 8:45 AM, Vijay Aggarwal wrote: > hi Deepak, > > This file has been shared. Please remove sharing (tools-->share workbook) > and then Pivot will start working. > > regards, > Vijay > > On Wed, Ju

Re: $$Excel-Macros$$ Macro File Access

2010-06-03 Thread Deepak Rawat
wn menu in menu bar. > If you search on google you will get code for it. I have a code for it, if > you want I can forward it to you. > > Regards, > > Swapnil. > > > > On Wed, Jun 2, 2010 at 2:48 PM, Deepak Rawat wrote: > >> Hi all, >> >> I have ma

$$Excel-Macros$$ Macro File Access

2010-06-02 Thread Deepak Rawat
Hi all, I have made some macros for some data cleaning, my problem is that whenever i have to use that macros in some other file, i have to open the file which contains that macros. is it possible to make some buttons in Excel Ribbon to use that utility every time hassel free without opening that

Re: $$Excel-Macros$$ total for unique values

2010-05-22 Thread Deepak Rawat
Hi Murali Find the attached solution. Regards, Deepak Rawat -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN

$$Excel-Macros$$ Re: Lookup Query

2009-09-22 Thread Deepak Rawat
Hi Gyanesh PFA the solution u want!! Regsrds, Deepak Rawat On Mon, Sep 7, 2009 at 11:46 PM, gyanesh jain wrote: > > Hi friends, > I have some Query related with Lookup. its in attachment. > > can any provide the solution? > > -- > Thanks, > Gyanesh Jain, BE, MBA

$$Excel-Macros$$ Macro for Retrieve Messages of Outlook mails

2009-09-01 Thread Deepak Rawat
Hi All I have to Retrieve messages of Outlook mails of selected folders. could it be done by macro, please help!! Regards, Deepak --~--~-~--~~~---~--~~ -- Some important links for excel

$$Excel-Macros$$ Re: Value all the Selection

2009-07-18 Thread Deepak Rawat
Thanx!! for your help Dave. Regards, Deepak Rawat On Fri, Jul 17, 2009 at 5:39 AM, Dave Bonallack wrote: > Hi, > Try putting the following code in a module, then Run: > > Sub ChangeToValue() > A = 2 > Do Until Cells(A, 1) = "" > Cells(A, 1)

$$Excel-Macros$$ Re: want a macro code

2009-05-20 Thread Deepak Rawat
Hi thanks for revert but i dont want to use vlookup. I want macro code for entering name n nos. for example: if i put Delhi in City field then name and phone nos of ADM and GM of Delhi should automatically come in theri fields. Same as i put Mumbai . Regards Deepak Rawat On Wed, May 20

$$Excel-Macros$$ want a macro code

2009-05-20 Thread Deepak Rawat
s well. regards, Deepak rawat --~--~-~--~~~---~--~~ - Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelite

  1   2   >