Paul -
I changed the part of the code that you suggested, and it is working
fine.
Again, I am still quite a novice with reading and writing code, so I
did not recognize that your code was not looking at the columns that I
had originally described. Now I know where to look.
Thank you again.
On M
"without making modifications"...
Hmm... you DO realize that I don't have your file?
and therefore I had to use a data file I had for some other entire purpose?
And... the columns YOU want to compare would have no significance to me?
You should try using the VBA debugger and step through the code
hi it is possible through vlookup see the attachment as i am in office in
our right now we are using MS Excel 2003 that's why i could not able to see
your file and give prompt solution but I hope this will help u if not plz
feel free to revert me.
On Tue, May 25, 2010 at 3:36 PM, Jai wrote:
>
Just paste this formula that will work same
=IF(B50="material",10.3%,4.12%)
On May 25, 3:06 pm, Jai wrote:
> Dear All
>
> 1. When we Selcet the Type of Work ( Material ) Service tax Show 4.12
> %,
>
> 2. When we Selcet the Type of Work ( Labour ) Service tax Show 10.3
> %
>
> Can
Hi,
VBA code for yesterday's date is:
A = Date - 1
The variable 'A' will contain yesterday's date.
Regards - Dave
Date: Tue, 25 May 2010 12:08:06 +0530
Subject: $$Excel-Macros$$ Excel macro Help : Date of Previous day
From: nsund...@gmail.com
To: excel-macros@googlegroups.com
Hi Friends,
Pleas
Hi,
I want to learn macros step by step. Please guide me.
Regards
Rakhee
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our
use the following formula to get only the date.
=TODAY()-1
Regards,
Putta Madaiah
On Tue, May 25, 2010 at 1:15 PM, Swapnil Palande wrote:
> Hi Sundarvelan,
>
> There is no need to write vba code for this.
>
> Use following function:
> =NOW()-1 //This will return date and time ex.: 5/24/2010 13:11
Hi Sundarvelan,
There is no need to write vba code for this.
Use following function:
=NOW()-1 //This will return date and time ex.: 5/24/2010 13:11
=DATE(YEAR(NOW()), MONTH(NOW()), DAY(NOW())-1) // this will return only date
ex: 5/24/2010
Regards,
Swapnil.
On Tue, May 25, 2010 at 12:08 PM, Su
Hi Friends,
Please give the VBA code to find the date of previous day (yesterday).
Thanks,
N.Sundarvelan
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitte
