Hi Hammod, please try attached macro
Rgds,
[dp]
On 26/07/2013 10:32, ha...@mst.edu wrote:
Hi All
I'm trying to write an excel vba code that return a number with respct to
the value of the 2nd number.
There are 5 number copied into one column(it has to be one
column,project requiremnt)
and
Dear Laxman,
PFA with solution.
This is little lengthy and I am not satisfied.
But it's working.
Regards,
Waseem Saifi
On Sat, Jul 27, 2013 at 10:22 AM, LAKSHMAN PRASAD lakshman_...@yahoo.comwrote:
Dear expert
I have a sheet in which money receipt details maintain, I want to filter
like
Hi,
how to make a file expire after a period of time.
regards
Kannan V
--
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
Wow great Querry!!!
Even I am excited to know it.
Johnson
On Sat, Jul 27, 2013 at 2:25 PM, Kannan Excel kannan.ex...@gmail.comwrote:
Hi,
how to make a file expire after a period of time.
regards
Kannan V
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
Using macro, but required user to run the macro
This is the basic, user still can skip this by changing date on his computer
Private Sub Workbook_Open()
Dim Expired As Date
Expired = 20 Jul 2013
If Now() Expired Then
MsgBox File ThisWorkbook.FullName expired
Let me ask before answering you with the code
If i change the date to 30 June 2013, what will appear in quarter, half
and year ?
Pada 27/07/2013 15:00, Kenil Gala menulis:
hi,
Thank you very much De premor for your time and efforts.
but,one problem I am facing now is when I changed the
What you want to do after expiration. .?
On 27 Jul 2013 14:25, Kannan Excel kannan.ex...@gmail.com wrote:
Hi,
how to make a file expire after a period of time.
regards
Kannan V
--
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
I am using windows 7 i am not using genuine software for the last 2 years
now i have message on my scree that this copy of winos is not genuine and i
want to remove this. how can i do that pls help me out.
Thanks,
Regard
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be?
(a) This is not a Windows help forum.
(b) What you're asking supports piracy and is probably illegal.
On Sat, Jul 27, 2013 at 3:48 PM, Cute Awesome aqibmari...@gmail.com wrote:
I am using windows 7 i am not using genuine software for the last 2 years
now i have message on my scree that this
Hi Lakshman,
Another short way but without using formula.
Step 1: sort data (data --sort) UNITNO - Smallest to Largest and Amount
- Largest
to Smallest
then
Step 2:- use remove duplicates function (data -- remove duplicates) Only
select UNITNO then OK
you can record your steps using record
K do one thing go to start button-type cmd -write click over there and
select run as administration then type in command prompt slmgr -rearm,
your windows will reactivate.
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Cute Awesome
Sent:
Hi Experts,
Need a help on copying the data from one workbook (Reference) to another
workbook (master). I know asking too much, appreciate could you please help
me on this coding.
The workbook name different each time, i need dynamic name selection option
to select both the work sheets and data
Experts your assistance is much appreciated.
On Sat, Jul 27, 2013 at 4:55 PM, Puttu * puttu...@gmail.com wrote:
Hi Experts,
Need a help on copying the data from one workbook (Reference) to another
workbook (master). I know asking too much, appreciate could you please help
me on this
Hi All
I'm getting error to select the maxdate.
Sub Pivot_table()
ActiveWorkbook.Sheets(Incidents Resolved).Select
Range(A7).Select
Set objTable = Sheet1.PivotTableWizard
'*select the maxdate
*
*Set objField = objTable.PivotFields(Last Resolved Date)*
*objField.Orientation = xlPageField*
Hey
Can you share sample file with dummy data. This will help in understanding
better..
Thanks
On Saturday, July 27, 2013 9:59:18 PM UTC+5:30, Sanjay Kumar Maurya wrote:
Hi All
I'm getting error to select the maxdate.
Sub Pivot_table()
ActiveWorkbook.Sheets(Incidents Resolved).Select
Hi, everyone, can you suggest a code that would help me find all
sub-folders called abc and rename each to 1. abc?
--
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 Vabz
PFA dummy data file.
On Saturday, 27 July 2013 21:59:18 UTC+5:30, Sanjay Kumar Maurya wrote:
Hi All
I'm getting error to select the maxdate.
Sub Pivot_table()
ActiveWorkbook.Sheets(Incidents Resolved).Select
Range(A7).Select
Set objTable = Sheet1.PivotTableWizard
'*select
r u trying to choose maximum date in report filter if so then you have to
apply filter
On Sun, Jul 28, 2013 at 9:17 AM, Sanjay Kumar Maurya
mail2sanja...@gmail.com wrote:
Hi Vabz
PFA dummy data file.
On Saturday, 27 July 2013 21:59:18 UTC+5:30, Sanjay Kumar Maurya wrote:
Hi All
I'm
Any updated on the macro team..
On Sat, Jul 27, 2013 at 7:14 PM, Puttu * puttu...@gmail.com wrote:
Experts your assistance is much appreciated.
On Sat, Jul 27, 2013 at 4:55 PM, Puttu * puttu...@gmail.com wrote:
Hi Experts,
Need a help on copying the data from one
Hi shish ji,
Could you make a changes in attached file.
On Sun, Jul 28, 2013 at 10:10 AM, ashish koul koul.ash...@gmail.com wrote:
r u trying to choose maximum date in report filter if so then you have to
apply filter
On Sun, Jul 28, 2013 at 9:17 AM, Sanjay Kumar Maurya
Hi All,
How to Evaluate cell value.
let assume that, in cell A2 - '1+2+3+4'
now how to sum or calculate cell value
hint: evaluate
.
Enjoy
Team XLS
--
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
try this see if it helps
Sub Pivot_table()
Dim ptitm As PivotItem
Dim dt As Date
dt =
DateSerial(Year(Application.WorksheetFunction.Max(Sheet1.Range(c:c))),
Month(Application.WorksheetFunction.Max(Sheet1.Range(c:c))),
Day(Application.WorksheetFunction.Max(Sheet1.Range(c:c
using udf
On Cell A3, type*=Eval(A2)*
then, on VBE, add module and paste this code
*Function eval(str As String)**
**eval = Evaluate(str)**
**End Function**
*:-X
On 28/07/2013 12:09, xlstime wrote:
Hi All,
How to Evaluate cell value.
let assume that, in cell A2 - '1+2+3+4'
now how to
23 matches
Mail list logo