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 su
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"
Application.
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 Faceb
Hi shish ji,
Could you make a changes in attached file.
On Sun, Jul 28, 2013 at 10:10 AM, ashish koul 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 <
> mail2sanja...@gmail.com> wrote
Any updated on the macro team..
On Sat, Jul 27, 2013 at 7:14 PM, Puttu * wrote:
> Experts your assistance is much appreciated.
>
>
> On Sat, Jul 27, 2013 at 4:55 PM, Puttu * wrote:
>
>> Hi Experts,
>>
>> Need a help on copying the data from one workbook (Reference) to anoth
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 Al
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.PivotTableWizar
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 @
https://www.facebook.com/discus
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 Resolve
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*
Experts your assistance is much appreciated.
On Sat, Jul 27, 2013 at 4:55 PM, Puttu * 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 coding.
>
> The work
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 r
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: S
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
(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 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 copy of winos is not
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? It’
What you want to do after expiration. .?
On 27 Jul 2013 14:25, "Kannan Excel" 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 official Facebo
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 date
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"
Wow great Querry!!!
Even I am excited to know it.
Johnson
On Sat, Jul 27, 2013 at 2:25 PM, Kannan Excel 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
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 t
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 wrote:
>
> Dear expert
> I have a sheet in which money receipt details maintain, I want to filter
> like sheet “Result” mean
22 matches
Mail list logo
