Are you looking for standard Exchange Rate or a variable?
If so then u dont need macro for it. you can get it done with simple
formula..
let me know if u need it.
kamal
On Sun, Jul 19, 2009 at 6:09 PM, krishnan moorthy
wrote:
>
> Dear Moderators,
>
> I am a beginner to the excel macro world. Ne
Dear Moderators,
I am a beginner to the excel macro world. Needed your assistance to
create a macro that can convert currency i.e. Dollars and Euros to
Rupees and vice versa.
Any help with this is highly appreciated.
Thanks in advance!
Krishnan Moorthy
--~--~-~--~~
I am entering dates every week into a spreadsheet. How can I
automatically colour a date on week 1 as red and week 2 as green for
all alternate weeks?
--~--~-~--~~~---~--~~
--
Some imp
Hi Daniel,
The attachment is missing,
Regards,
Kunal
On Jul 19, 4:47 pm, "Daniel" wrote:
> Hi.
> Look at the attached file.
> I put a button for each condition for testing purposes.
> I found nothing to matches for condition3 and 4. Can you test further ?
> When it will be OK, I put the code
Religare Technova Business Intellect Limited (RTBIL) – the BPO/ KPO arm of
Religare Technova has state of the art service facilities, equipped to
handle today’s fast changing and challenging customer demands. RTBIL is one
of the most progressive domestic BPOs in India with its first Service
Excel
Hi.
Look at the attached file.
I put a button for each condition for testing purposes.
I found nothing to matches for condition3 and 4. Can you test further ?
When it will be OK, I put the code in a Worksheet_Calculate event so that it
will be updated each time the values changes.
Daniel
> -O
You are right. Maybe, we can use VBA ? Can you mail a sample workbook ?
Daniel
> -Original Message-
> From: excel-macros@googlegroups.com [mailto:excel-
> mac...@googlegroups.com] On Behalf Of Lynn
> Sent: dimanche 19 juillet 2009 03:40
> To: MS EXCEL AND VBA MACROS
> Subject: $$Excel-Ma
Try the following macro. I have limited sort to columns A:AL. To be
modified.
Sub test()
Dim i As Long
Application.ScreenUpdating = False
For i = [A65536].End(xlUp).Row To 1 Step -1
If Cells(i, 4).Value <> "" Or (IsNumeric(Cells(i, 36)) And _
Cells(i, 36) < 99) Then
Cells(i, 1).En
Hello.
"THESE ALL ARE SAME VALUES WITH "VLOOKUP" FORMULA & I WANT IT VARIED LIKE
"H" COLUMN"
H columns are empty.
Concerning G5 you indicate the formula in D5 :
"VLOOKUP(D5,Yard!A:C,3,FALSE)"
But what's in D5 ?
Can you precise, please ?
Regards.
Daniel
From: excel-macros@google
Hi Daniel,
Thanks for resolving this. About the query. If the data point
satisfies any of the condition then it will fine.and they can all be
in the same color
Thanks again for the help .
Regards,
Kunal
On Jul 18, 8:57 pm, "Daniel" wrote:
> Hi Kunal,
>
> Try replacing 0 value with "#NA!" v
10 matches
Mail list logo
