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
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
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
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
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
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
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(
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
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
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
>
*
>
> 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
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
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
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
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
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
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
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
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
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
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
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:
>
>>
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
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
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
>
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
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
&
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
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)
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
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
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
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
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
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
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
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:
>>
>>>
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
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,
>>
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
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
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:
>>>
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 ,
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?
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
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
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
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
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.
>
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
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
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
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
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
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...
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
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
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
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,&
=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
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
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
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
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
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:
>
>>
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
.
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
>
> 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.
>>
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
--
-
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
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
--
--
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
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
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
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
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
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
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
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
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
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
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)
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
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 - 100 of 103 matches
Mail list logo