Try dis kind of formulas. Don't delete the hide rows reference you can
shift it. I will provide you a solution soon for % column too.
Regards,
Mandeep Baluja
*Excel Specialist. *
On Thursday, November 20, 2014 1:22:52 PM UTC+5:30, Nur wrote:
Dear all, I need to extract the partial
Dear All,
I need to work on Data sheet which contains all the cells in text format.
basically its a timing sheet. I want to change the format of all the time
values in correct format and wish to highlight those cells where people
come after 10:00 am .Hope you can understand this by going
I'm not sure how you expected to accomplish this, but:
In the attached sheet, I simply
- highlighted the entire sheet and did a find/replace and replaced : with :
- Used Conditional Formatting and highlighted the cells 10:00
if you're looking for some other method, or there's more back story
What type of solution are you looking for?
That is:
If I make a custom function using VBA, would you be able to modify it to suit
you?
or do you want the solution using Excel formulas?
Paul
-
“Do all the good you can,
By all the means you can,
In all the
Mandeep da,
Take my respect ,yes you did excellent job for me . the formula
results are 100% correct . please take time for solving % issue. Is
it possible to implement reference text inside the formula . if not
possible then use another column to keep the “ reference text “ , it
might be
Hi Paul ,
Thanks for intention to help me . I will appreciate both solution as I
love to learn both formula macro solution . actually my data range
is not fixed so for bigger data range macro is suitable for this . but
for small data range formula is best . so if you don’t have problem
then I
Here is a formula solution.
The macro solution was to use a custom function.
I'll work on that.
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 people you
Dear Nur,
Thanks to appreciate.
Actually I was doing my office work yes it is possible to reference text
inside the formula.But I need time because I have to do my ofc work too :),
Soon I will submit it your percentage formula too.
On Thursday, November 20, 2014 1:22:52 PM UTC+5:30, Nur
Hey Nur,
Kindly find the attached UDF just type the formula in sheet First
percentage/Second percentage it will give to appropriate result. if text
does not contain second percentage value it will give wrong result.
Function Firstpercentage(txt) As String
Dim k() As String
Dim x As
Worked like a charm :)
Thanks a lot .
On Thursday, November 20, 2014 4:59:00 PM UTC+5:30, Mandeep Baluja wrote:
Dear All,
I need to work on Data sheet which contains all the cells in text format.
basically its a timing sheet. I want to change the format of all the time
values in
Thanks Thanks Thanks Thanks Thanks Thanks Thanks Thanks Thanks Thanks Thanks
Thanks Thanks Thanks Thanks Thanks Thanks Thanks Thanks Thanks Thanks Thanks
On Thursday, November 20, 2014 7:01:02 PM UTC+5:30, Mandeep Baluja wrote:
Worked like a charm :)
Thanks a lot .
On Thursday,
Hi Paul ,
Yes it works perfectly, it will help a lots. i appreciate your nice
job.. thanks...nur
On 11/20/14, Paul Schreiner schreiner_p...@att.net wrote:
Here is a formula solution.
The macro solution was to use a custom function.
I'll work on that.
Paul
OK, I'll take a look at this as soon as I get some things I'm PAID to do taken
care of!
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 people you can,
As
Mandeep da,
Your UDF function is working fine. it is really nice concept that you
did. thanks once again for your valuable time regarding my issue.. i
also got a solution from Paul .though currently i did not get any
problem, then now i analysis whether any discrepancy is there or not
.. if i
Thanks again for well versed explanation ! :) , what i did i just copied
the whole code from the sheet module
and then i put Private Sub Workbook_Open() in the ThisWorkBook by adding
the code . It looks like the following
Private Sub Workbook_Open()
'Private Sub TestFileExistence()
If
Well, that answers that question.
you have it in the ThisWorkbook module, which is correct.
Which means that it probably actually RAN, but
Weekday(Date) = 2
will return false because today (thursday) is Weekday #5
Paul
-
“Do all the good you
actually the code is really really big :) this is just for example that i
gave , i have like 78 reports that needed to be scored card check , and
every report is everyday except Sunday , so its a really long code
On Thu, Nov 20, 2014 at 9:28 AM, Paul Schreiner schreiner_p...@att.net
wrote:
one report example is following
If FileFolderExists(\\cf3.pepsico.pvt\psra\Output\BI4\PSRA Day Tracker -
Exec.mhtml) And _
Weekday(Date) = 2 Then
Range(P4).Value = X
End If
If FileFolderExists(\\cf3.pepsico.pvt\psra\Output\BI4\PSRA Day Tracker -
Exec.mhtml) And _
may be the code could be smaller , but being a Starter in VBA , thats the
only thing that came to my mind , and the time was also limited , But
thanks to you , you make it complete in such a easy way .
On Thu, Nov 20, 2014 at 9:32 AM, USMAN TARIQ usman.tariq1...@gmail.com
wrote:
one report
Thank you everyone.
On Fri, Nov 14, 2014 at 5:42 PM, Ashish Kumar kumar.ashish...@gmail.com
wrote:
Hi Pravin,
PFA!!
Edit your data in Pending CN and Highlight the row which you want to paste
in Party Wise and hit the macro.
Regards
Ashish
--
Are you =EXP(E:RT) or
Please help to provide the solution in VBA to transfer a file from local
drive to Remote drive by Filezilla(Tool)
--
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 @
Hmm...
I wouldn't mind seeing the actual code (you could email me directly instead of
the group)
and I could see if there's anything I could see to streamline the code.
but..
these if() statements seem to be all checking for the same file:
\\cf3.pepsico.pvt\psra\Output\BI4\PSRA Day Tracker -
What email application are you using?
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 people you can,
As long as ever you can.” - John Wesley
Am using Normal MS Outlook application for sending mails..
Thanks,
Lax
On Thursday, November 20, 2014 10:39:07 PM UTC+5:30, Laxmanan M wrote:
hi All,
Please see the attached file as requested. What the outcomes I’m after are
requested below.
When column AJ (Name of successful
Are you wanting someone to write the entire macro
or are you simply needing help in automating the email?
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
Am not gud at macros and am in learning phase.But i have been assigned to
complete this task.So am roaming around the web.Please paul help me to be
done this macro code
lax
On Thursday, November 20, 2014 10:39:07 PM UTC+5:30, Laxmanan M wrote:
hi All,
Please see the attached file as
Dear Mr. Ladmanan,
Pls do send an attachment.
Warm Regards,
Gawli Anil
On Thu, Nov 20, 2014 at 11:53 PM, Laxmanan M laxflyflow...@gmail.com wrote:
Am not gud at macros and am in learning phase.But i have been assigned to
complete this task.So am roaming around the web.Please paul help me to
Dear Paul,
As I worked on this sheet it is the worst format of this sheet.as you can
see some columns are merge and some are hide I want a clear report. I know
that vba will help here.
I want that cells should be unmerge and delete blank columns after that and
proper format for this report.
Dear team,
Need a help on formula to find the month btwn the years.. pls find the
attachement.
Note: its should calculate from Apr - Mar
I tried but I not able to get the correct one.
Thanks Regards,
Ganesh N
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
29 matches
Mail list logo
