Dear all, I need to extract the partial contents of a cell. My excel
sheet contains the data in the cell A:A which is very complex format
data . form this data , I want to get the data as I color marks form
B2:G2. Please check the attachments. If I get any partial help I will
be glad also ..
--
=IF(D3="N/A",INDEX($D$1:$D$13,LARGE(IF($D$1:D3<>"N/A",ROW($D$1:D3)),ROW(D3:D3)-ROW(D2:D2)),1),D3)
Ctrl + shift + enter
Mandeep Baluja
Excel Specialist.
On Thursday, November 20, 2014 10:55:44 AM UTC+5:30, Rohan Young wrote:
>
> Dear Group,
>
> Please see the attachment for my requirement
>
>
Dear Group,
Please see the attachment for my requirement
Regards
ROHAN
--
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
Hello Paul,
Thanks for reply
Are you saying that when you hit "Add"
you want to add another row of (5) textboxes?
Yes, I want to add another row of (5) TextBoxes.
And when you hit "Remove", it should
remove the row of (5) boxes?
Yes, I want to remove row of (5) tesxtboxex.
If you remove the s
What module did you put it in?
(it should be in a sheet module)
also, the part that says: Weekday(Date)
today (Wednesday) is weekday #4, so Weekday(Date) = 2 will be false
also, for debugging purposes:
in the VBE window, right-click on the menu area and turn on the Edit and Debug
icon sets.
Private Sub Worksheet_Activate()
'Private Sub TestFileExistence()
If FileFolderExists("\\cf3.pepsico.pvt\psra\Output\BI4\PSRA Day Tracker -
Exec.mhtml") And _
Weekday(Date) = 2 Then
Range("P4").Value = "X"
End If
End Sub
*i put like this , its not doing any thing :(*
On Wed, Nov 19,
Private Sub Worksheet_Activate()
End Sub
so do i need to put my code between the above two ?
i put the
On Wed, Nov 19, 2014 at 1:35 PM, Paul Schreiner
wrote:
> Ah yes...
> More tricks of the trade.
> Soon, you'll be making this look easy!
>
> first:
> As I mentioned at the beginning of the la
Ah yes...
More tricks of the trade.
Soon, you'll be making this look easy!
first:
As I mentioned at the beginning of the last email, the biggest struggle for
someone new is "terminology and communication".
The PROBLEM you were having wasn't "difficult".
what was difficult was wading through wh
Oh God!!! ...You have no idea what you have done You are best ,
like i have literally posted my this big questions everywhere , nearly 6
forums and it was driving me nutsand you have so much patience
like you have no idea and nobody has yet replied and on the top in this
much
As someone new to VBA, the biggest struggle when asking for help is terminology
and communication.
YOU know what you see on the screen, but when you post a question, the people
reading cannot see what you see.
First, some terminology and "structure":
Keep in mind that this description is more
GREAT!!
Now I think I know where to look.
Let me write a somewhat longer explanation and get back to you.
Paul
-
“Do all the good you can,
By all the means you can,
In all the ways you can,
In all the places you can,
At all the times you can,
To all the
i apologize for confusion, actually i am new to VBA . So here is the final
thing i want
i have 2 VBA code in two separate sheets , and then i have placed the
declaration of the function *(Private Sub TestFileExistence())* in the
Module . this function is being used in the two VBA.
what this code i
What is not working?
Does it give an error?
You've got several things in this email.
which are you referring to?
You said:
i want i have 2 sheets in my work book, want to use the Private Sub
Workbook_Open() , its not working for me :(
the number of sheets has absolutely nothing to do with c
please advise
On Tue, Nov 18, 2014 at 12:50 PM, USMAN TARIQ
wrote:
> Following is not woreking
>
>
>
> Private Sub Workbook_Open()
> Dim ws As Worksheet
>
> For Each ws In ThisWorkbook.Worksheets
> With ws
> .EnableOutlining = True
> .Protect UserInterface
Paul,
Thank you very much, for the detailed explanation.
Regards
Eugene
On Wed, Nov 19, 2014 at 6:27 PM, Paul Schreiner
wrote:
> In the "Orders" file, you have:
>
> ActiveSheet.ListObjects("Table1").Range.AutoFilter Field:=2,
> Criteria1:=MYNUM
>
> Breaking this down:
> "ListObjects" is a prop
In the "Orders" file, you have:
ActiveSheet.ListObjects("Table1").Range.AutoFilter Field:=2, Criteria1:=MYNUM
Breaking this down:
"ListObjects" is a property of the "Worksheet" Object.
That means that it needs a Worksheet in order to operate.
In your case, you've specified that you want the L
Your userform currently has (3) rows of(5) textboxes.
Are you saying that when you hit "Add"
you want to add another row of (5) textboxes?
And when you hit "Remove", it should
remove the row of (5) boxes?
If you remove the second row, what do you want to have happen to the rest?
(third row
Hi all! Here I got a question on the another community. He wants to achieve
maximum in other column for example first 7 in between 3,2,6,7 and then
next range max 8 in between 8,2,3 . I have prepared the formula for this
but want to know some more suggestions. :)
Que : - I have some numbers ze
Please Experts help me out.
On Tue, Nov 18, 2014 at 5:07 PM, Rupesh Patil
wrote:
> Hello Experts,
>
> any help?
>
>
> On Mon, Nov 17, 2014 at 4:10 PM, Rupesh Patil
> wrote:
>
>> Hello experts,
>>
>> I need your help,I have one userform which attached with mail for your
>> reference, what I need
19 matches
Mail list logo
