Hi Faye,
You want to highlight the Cells of Sheet 1 Column D, if the same values are
lying in Sheet 2 in Column B.
PFA.!!!
Regards
Ashish
--
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:/
I have a Worksheet that is tracking my companies Asset ( each asset gets an
asset tag # ) The first sheet is all the equipment that I have tagged.
Sheet 2 has all the equipment that has been decommission ( dead, broken
not used anymore)
Sheet 1 Column D8:D9 is the asset tag numbers
Shee
Hi,
I am working on a project where I need to print 100 report card at a time
either directly to a printer or as PDF.
Attached is the example workbook. All my data will be entered in sheet
named "Raw" and my output should look like sheet named "Final".
Is it possible to print it to PDF / printer
I think you're still getting confused about what VBA is doing and what Excel is
doing.
(which are actually two different things)
VBA is a programming language.
Visual Basic for Applications.
It can be USED for Excel, Word, Access, Powerpoint.
There are variations in VBA for each application.
W
Hi Ashish,
Its working for Dates <9/25/2014 but not for =9/25/2014. Paul's code extract
worked. But I guess I am confused here about the date filters in VBA
specifically about their declaration, do I really need to declare datatype, or
it will automatically get changed to the application specifi
Dear Ganesh,
Thanx for provide formula. It's also great but there is more than 100
column where were conditions found. So it is not possible to entered
formula.
thanking you
On 26 September 2014 09:44, Ganesh N wrote:
> Hi sudhir,
>
> PFA.
>
> Just given if condition.
>
> Regards,
> Ganesh N
Hi Nitin,
PFA.!
Regards
Ashish
--
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 thread titles. Poor thread titles, li
Dear sir,
i am unable to use this code because its showing error, so please copy
rectify the error and provide the excel sheet for that..
thanks alot.
On Friday, 26 September 2014 11:58:17 UTC+5:30, Vabz wrote:
>
> chek this:
>
>
> http://www.excelguru.ca/content.php?122-Creating-an
WHAT have you tried?
WHAT are you trying?
I took your sample.
Recorded a macro in which I turned on AutoFilter, and filtered to show
yesterday's date.
Then, I looked at the macro and created a variable to calculate "yesterday's"
date
and substituted this variable into the macro.
THEN, I wen
Hi Vaibhav,
Thanks for the link. It certainly clear many concepts regarding date filters.
Regards.
Yours Sincerely,Nitin Balodi
From: v...@vabs.in
Date: Fri, 26 Sep 2014 18:38:09 +0530
Subject: Re: $$Excel-Macros$$ Applying Date Filters using VBA
To: excel-macros@googlegroups.com
Refer this: http
Hi Paul,
Thanks for your response. The format will always be in mm-dd- hh:mm format
and I want to apply filter for yesterday date for example, today I applied for
25th September 2014, I want to filter out yesterday date data only.
Regards.
Yours Sincerely,Nitin Balodi
From: v...@vabs.in
Dat
Refer this: http://www.ozgrid.com/VBA/autofilter-vba-dates.htm
Cheers!!
+
*I did not do this for you. God is here working through me for you.*
On Fri, Sep 26, 2014 at 5:41 PM, Nitin Balodi wrote:
> Hi experts,
>
> I want to apply date filter in the attached sheet for previous date using
>
I don't understand what you're asking.
Your sheet has a column of date/time values.
in VBA you can convert this to an integer to get the date,
a Double to get the date and fraction of a day
or you can use Datevalue() and timevalue()
The terms you use: "Appy date filters"
that has specific mean
13 matches
Mail list logo
