NO actually i want to show L whichever dates he have taken leave.
But it should be automated by formula so that i just need to enter the
dates in the sheet named "Database" and it will automatically highlights
those dates in red in sheet "Summary" and the previous leave dates would be
available wi
Hi,
Please suggest option to prevent copy paste in cells with data validation .
Please suggest other than macros
--
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
Hi frog,
First of all many thanks for your time to explain with valuable points.
Really what you said is really useful for me.
Reason behind my post is, all the methods is working with some formula and
giving a result even if we use any tools available in markets. I just wants
to apply this formu
Thanks a lot
works like a charm
You are a star
On Sunday, August 25, 2013 4:03:48 PM UTC+4, De Premor wrote:
> PFA
>
> Pada 25/08/2013 18:22, prkhan56 menulis:
>
> Hello De Premor,
> It shows only blanks. No data at all.
> Please check
> Thanks for your time once again.
> Rashid
> On Sunda
Thank you thankyou, it does exactly what I'm looking for.
The sad part is now I will be busier.
Thanks again.
Sub Pierre()
Dim Rng As Range, Data As Range, iLeft As Integer
Set Data = Selection
For Each Rng In Data
iLeft = InStr(1, Rng, "(") + 1
If iLeft > 1 Then
Rng.Offset(0, 1) = Mid(Rng,
try the attached workbook see if it helps
On Mon, Aug 26, 2013 at 8:00 PM, Pierre Lanoue wrote:
> I have some data that is imported into Excel. It's a long string of text,
> in one cell, that I have to split in 2 cells and get rid of unwanted data.
>
> I've attached a file, I need to manipulat
Do you want to show date rather than "L" sign?
On Mon, Aug 26, 2013 at 7:36 PM, Zibraan wrote:
> Hi Team,
>
> Please refer the Sheet in which I need a formula which can calculate and
> show the planned leaves in date format and should highlight in Red.
>
>
> Thanks & Regards,
> Lucky
>
> --
> A
Try this macro
Sub Pierre()
Dim Rng As Range, Data As Range, iLeft As Integer
Set Data = Selection
For Each Rng In Data
iLeft = InStr(1, Rng, "(") + 1
If iLeft > 1 Then
Rng.Offset(0, 1) = Mid(Rng, iLeft, InStr(1, Rng, ")") - iLeft)
Rng.Offset(0,
I have some data that is imported into Excel. It's a long string of text,
in one cell, that I have to split in 2 cells and get rid of unwanted data.
I've attached a file, I need to manipulate the data in ROW 3 to look like
the data in ROW 5. Normally i do this on the same row. I will copy wh
Hi Team,
Please refer the Sheet in which I need a formula which can calculate and
show the planned leaves in date format and should highlight in Red.
Thanks & Regards,
Lucky
--
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
you can use the hyperlink method given by Jordan which he has used in us
map . link below
http://optionexplicitvba.blogspot.in/2012/08/interactive-map-in-excel-using-rollovers.html
http://optionexplicitvba.blogspot.in/2012/10/interactive-united-states-2012.html
On Sun, Aug 25, 2013 at 11:42 PM, R
Hello Prabhu,
I dont comment on this forum much as I generally dont have the time. I saw
your topic and thought it worth a response because it it quite a tricky one
to get right (there are many failed attempts out there in the world). I
have done the different statistical forcasting methods you
Santy,
Absolutely phenomenal! Thank you for your brilliant, quick reply!
John
On Monday, August 26, 2013 8:56:14 AM UTC-4, Santy wrote:
>
> Little lengthy formula but working fine
>
>
> *Thanks & Regards,*
> *Santy*
>
>
> On Mon, Aug 26, 2013 at 5:56 PM, John A. Smith
>
> > wrote:
>
>> I
Thanks Premor sir,
Fantastic, Hats off to ur UDF.. thanks a ton.
With warm regards,
Rajan Sharma
On Mon, Aug 26, 2013 at 4:40 PM, De Premor wrote:
> Try this using UDF
>
> Function SUMPB(Amount As Range, Unit As Range, RngCriteria As Range,
> Criteria As String)
> Dim i As Long, F
=TRIM(SUBSTITUTE(C2,*CHAR(10)*," "))
SUBSTITUTE is to replace somestring, in our case we need to replace
ENTER Char(enter Char in ASCII Code is 10) to meet your requirement with
a single space to make it a single line, Then because there is soo many
space there, and you want to remove it, we
Thanks DP for your immediate response.
Could you please inform the meaning of this formula for my understanding.
Regards
Pravin Gunjal.
-- Forwarded message --
From: De Premor
Date: Mon, Aug 26, 2013 at 4:08 PM
Subject: Re: $$Excel-Macros$$ Extra Space & Enter to be removed from
Hi All,
unfortunately workbook is too big to share, but I've done some something
(below):
ActiveSheet.Shapes.Range(Array("ListBox2")).Visible = msoFalse
ActiveSheet.Shapes.Range(Array("ListBox2")).Visible = msoTrue
this is working, but still not perfect.
problem is that something (macr
try this formula
=TRIM(SUBSTITUTE(C2,CHAR(10)," "))
Pada 26/08/2013 17:33, Pravin Gunjal menulis:
Hello,
Can I get help from you to remove extra space / enter from column "C"
in the attached sheet. Pl do the needful.
Regards
Pravin Gunjal.
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel
Dear Premor sir,
Can your formula provided be done by Vba Macros. Actually i have many
sheets to update your formula, so that it makes effect to all the sheets.
With warm regards,
Rajan Sharma
On Mon, Aug 26, 2013 at 3:10 PM, Rajan sharma wrote:
> Dear Premor sir,
>
> Exactly matching
Hello,
Can I get help from you to remove extra space / enter from column "C" in
the attached sheet. Pl do the needful.
Regards
Pravin Gunjal.
--
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:/
Dear Premor sir,
Exactly matching as per my requirement. Thanks a ton. even the formulas
are long it gives my solution.
With warm regards,
Rajan Sharma
On Mon, Aug 26, 2013 at 2:55 PM, De Premor wrote:
> Hi Rajan, try this long formula on Cell S2 or Just see at attached
> workbo
Ok can opt for Function if not then we will go with Macros
On Mon, Aug 26, 2013 at 12:39 PM, Prince wrote:
> Pankaj i dont think it is possible without macro. You have to use macro to
> do this task.
>
> Regards
> Prince
>
> On Monday, 26 August 2013 09:30:57 UTC+5:30, Pankaj wrote:
>>
>> Dear
Some body can help me for creating the formula please
With warm regards,
Rajan Sharma
On Mon, Aug 26, 2013 at 1:58 PM, Rajan sharma wrote:
> Dear experts,
>
> I am struggling in one formula steps, please help me out. please find the
> attachment for more information, please.
>
> Actaully
Worked perfectly, thank you very much.
On 1 August 2013 14:10, De Premor wrote:
> Ups Sorry, my fault, i haven't change a variable to fit yours
>
>
> Sub tes()
> Dim oWSHShell As Object, OpenFile As String
>
> Set oWSHShell = CreateObject("WScript.Shell")
> OpenFile = oWSHShell.Spe
Hey guyz, can anyone tell me the maximum # of dimenstions that can be
stored in a single array in VBA. I guess around 64 demensions but want to
confirm with you guyz.
--
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
Dear experts,
I am struggling in one formula steps, please help me out. please find the
attachment for more information, please.
Actaully i want a formula which gives me like R column, please forget
about P, Q, R coloumn.
P, Q are only helping column for me, so that i can elaborate you all the
hey there is there any way i can sum up data hourly/daily/monthly in a
given data
--
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,
Pankaj i dont think it is possible without macro. You have to use macro to
do this task.
Regards
Prince
On Monday, 26 August 2013 09:30:57 UTC+5:30, Pankaj wrote:
>
> Dear Gurus,
>
> I want to create a excel file with Date limit.
>
> Like in a file there are some contents(Graphs, Dashboards Etc)
Hi Pawel,
Pls shere your workbook.
Regards
Prince
On Sunday, 25 August 2013 16:34:00 UTC+5:30, lupinskip wrote:
>
> Hi All,
>
> I have quite serious problem with the list box (ActiveX). when I use it on
> the sheet where is placed is fine, but when I run any macro that is going
> to differen
29 matches
Mail list logo
