Re: $$Excel-Macros$$ VBA code for convert numbers (RS to USD & AED to USD)

2014-10-24 Thread Pramod Singh
Need more explanation... in your first sheet there are many number and link each other. so explain more. On Sat, Oct 25, 2014 at 11:48 AM, amar takale wrote: > Dear champs > > Above as per my explanation one thing remember that conversion rate is > "MY RATE" which is mention in sheet.As per

Re: $$Excel-Macros$$ VBA code for convert numbers (RS to USD & AED to USD)

2014-10-24 Thread amar takale
Dear champs Above as per my explanation one thing remember that conversion rate is "MY RATE" which is mention in sheet.As per my requirement it will be change.so Pls fix that cell in vba code then i will change whenever possible. I would appreciate very much if someone can help me on this. Than

$$Excel-Macros$$ Happy Diwali

2014-10-24 Thread amar takale
Dear All excel champs Wishing you a very happy and prosperous Diwali to all my friends. Regards Amar -- 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 RULE

$$Excel-Macros$$ Produce CSV file as a output file by using the values/Data's from the Excel worksheet

2014-10-24 Thread Laxmanan M
Dear master's, Kindly help me to resolve my issue mentioned in the post Lax -- 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, accur

$$Excel-Macros$$ Need Help - How to Move multiple worksheets by Tab COlor

2014-10-24 Thread Nilkanth Raval
Dear Sir, I need your help in Moving Multiple worksheets by tab color. I write the below code, but gives me an error. Please help me. Sub MoveSheetsbyTabcolor() Dim wsNames() As String Dim wsColor() As Integer Dim ws As Worksheet Dim ind As Integer Dim Oldwkb As Workbook Set Oldwk

$$Excel-Macros$$ Produce CSV file as a output file by using the values/Data's from the Excel worksheet

2014-10-24 Thread Laxmanan M
Hi People, Please find attached the sample data, output file format and the format of the output file. I have created names for all columns like P.APR, I.APR etc for all months. In the output file, the first 2 column values are coming from the Config sheet and other from Data Sheet. In t

$$Excel-Macros$$ Please help on VBA- adjustments of a table with data

2014-10-24 Thread ivavok
Hello, I would be grateful for help. I have had some break using VBA and I now need to get the table attached adjusted in a certain way to be able to work with it later on: 1/ keep the first row with headings 2/ insert a new column after the first column and name it: Type 3/ always take the cont