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

2014-10-25 Thread Laxmanan M
Dear Vabz, Thanks for this challenging task..I ran this in my machine and it is working as expected..No words to say thanks..One small Q..After ran this the output file is getting genereated perfectly.But when close my macro i need to clear this result cells and i again make this file as fresh

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

2014-10-25 Thread Ashish Kumar
Hi Nilkanth, 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, like P

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

2014-10-25 Thread Vaibhav Joshi
check this: http://www.ozgrid.com/VBA/group-sheets.htm revert if you need help... + *I did not do this for you. God is here working through me for you.* On Sun, Oct 26, 2014 at 1:34 AM, Vaibhav Joshi wrote: > what exactly you are trying to achieve? > > + > *I did not do this for you. G

Re: $$Excel-Macros$$ automatically expanding stock/forex prices

2014-10-25 Thread Vaibhav Joshi
can you share you existing code with sample input data & output data.. + *I did not do this for you. God is here working through me for you.* On Fri, Oct 24, 2014 at 1:41 AM, paidtosignups1 wrote: > How do you do an excel spreadsheet, where each new price of a stock /forex > appears every 5

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

2014-10-25 Thread Vaibhav Joshi
what exactly you are trying to achieve? + *I did not do this for you. God is here working through me for you.* On Fri, Oct 24, 2014 at 8:46 PM, Nilkanth Raval wrote: > Dear Sir, > > I need your help in Moving Multiple worksheets by tab color. I write the > below code, but gives me an error

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

2014-10-25 Thread Vaibhav Joshi
Check this... Click blue button to run macro.. When prompted select month name in data sheet, in your case it will be cell AP3 (cell highlighted with green color for current example, you can select any other month too) & you will get output file as desired.. Note, i have kept same file / sheet n

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

2014-10-25 Thread Laxmanan M
Hi pramod and vabz, Thanks for the help. Here I have give the file "sample data"is the data file and we can apply the code in the same file.the format file is just the output file data format means the output file should have the data's in the same format of the "format".this file should save a

$$Excel-Macros$$ Macro needed to move multiple choice questions into an excel row with a fixed format

2014-10-25 Thread Noam Fischman
Hi all, I need to convert multiple choice questions into a rows in an excel file in a fixed format. . The file currently looks like this: Column A 1. Question1 goes here a. Answer 1 b. Answer 2 *c. Answer 3 - the * indicates this is the correct answer d. Answer 4 2. Question2 goes here *a. A

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

2014-10-25 Thread ivavok
Hi pramodb35, Thank you very much for your help! It is almost perfect;) Please have a look at the file attached. I have tried it for more rows for each type and it does not work correctly in that case:( The "type" is then not correctly copied in each row of column "type". I cannot figure out wh

Re: $$Excel-Macros$$ Re: How can one control data entry and truly protect a verified entry

2014-10-25 Thread Robert Baer
Color me confused. SheetSelectionChange event? where? This is a typical input i have: B_n:Cells(Frow, Fcol).Select' force location Tytle = "Enter charges:" Avar = Application.InputBox(Tytle) ' returns type text If Avar = "FALSE" Then GoTo B_n ActiveCell.For

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

2014-10-25 Thread Pramod Singh
Hi Laxman Can you save all data in one file. And then explain which is ur input tab. And how is your output Need more explain. Pramod On 25 Oct 2014 21:15, "Laxmanan M" wrote: > Pls help me.. > > -- > Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s > =TIME(2,DO:IT,

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

2014-10-25 Thread Vaibhav Joshi
hi can you explain how data is fetched for this 2.. For w12 & W13??? + *I did not do this for you. God is here working through me for you.* On Sat, Oct 25, 2014 at 9:15 PM, Laxmanan M wrote: > Pls help me.. > > -- > Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s

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

2014-10-25 Thread Laxmanan M
Pls help me.. -- 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, like Please Help, Urgent,

$$Excel-Macros$$ MIS Executive

2014-10-25 Thread 'Anil Kumar' via MS EXCEL AND VBA MACROS
Hi All i am search job for Sr. MIS Executive any jop please sent me. anilmaurya...@gmail.com Thanks & Regards Anil Kumar Maurya Mob. 8882545343 -- 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

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

2014-10-25 Thread Laxmanan M
Dear guru's, Still am waiting for your valuable comments..pls help me. Regards, 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 concis

Re: $$Excel-Macros$$ Automatic update excel file from website

2014-10-25 Thread Pramod Singh
Share the with excel file ... which text / details you want extract... On Sat, Oct 25, 2014 at 2:17 PM, B Sharma wrote: > Dear Excel Gurus, > I am trying to update my excel sheet which contains the TIN number of some > of the registered tax payers with their contact details and a

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

2014-10-25 Thread amar takale
Dear Pramod Thanks very much brother I will check it & revert back you Regards Amar On Sat, Oct 25, 2014 at 2:49 PM, Pramod Singh wrote: > Hi Amar, > > Please find the attached file as per your requirement. > > On Sat, Oct 25, 2014 at 2:29 PM, Pramod Singh wrote: >> Hi Amar, >> >> After c

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

2014-10-25 Thread Pramod Singh
Hi Amar, Please find the attached file as per your requirement. On Sat, Oct 25, 2014 at 2:29 PM, Pramod Singh wrote: > Hi Amar, > > After change value. link should remove and paste value multiply with > conversion.?? > > > Regards > Pramod > > On Sat, Oct 25, 2014 at 12:29 PM, amar takale w

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

2014-10-25 Thread amar takale
If link value paste special value then it not useful for me. On Sat, Oct 25, 2014 at 2:29 PM, Pramod Singh wrote: > Hi Amar, > > After change value. link should remove and paste value multiply with > conversion.?? > > > Regards > Pramod > > On Sat, Oct 25, 2014 at 12:29 PM, amar takale wrote: >>

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

2014-10-25 Thread Pramod Singh
Hi Amar, After change value. link should remove and paste value multiply with conversion.?? Regards Pramod On Sat, Oct 25, 2014 at 12:29 PM, amar takale wrote: > Dear Pramod > > In sample sheet there are in both main sheet which is linked data from > raw sheet thats links numbers are only conv

$$Excel-Macros$$ Automatic update excel file from website

2014-10-25 Thread B Sharma
Dear Excel Gurus, I am trying to update my excel sheet which contains the TIN number of some of the registered tax payers with their contact details and address. I can do it manually by putting the TIN number in the below mentioned website and then copy paste the details in the excel file. But

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

2014-10-25 Thread Pramod Singh
Hi ivavok , Please find the attached file as per your requirement... On Fri, Oct 24, 2014 at 5:31 PM, ivavok wrote: > 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 >

Re: $$Excel-Macros$$ Happy Diwali

2014-10-25 Thread Vaibhav Joshi
Very happy Diwali and prosperous new year to all friends.. On Oct 25, 2014 10:39 AM, "amar takale" wrote: > 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?

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

2014-10-25 Thread amar takale
Dear Pramod In sample sheet there are in both main sheet which is linked data from raw sheet thats links numbers are only converted. Regards Amar On Sat, Oct 25, 2014 at 12:19 PM, Pramod Singh wrote: > Need more explanation... in your first sheet there are many number and > link each other. so e