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

2014-10-26 Thread Vaibhav Joshi
Cheers !! On Oct 26, 2014 2:48 PM, "Laxmanan M" wrote: > Dear VAbz, > > i dont have a special words to say thanks..It's charm.. > > lax > > > > On Sunday, October 26, 2014 12:56:50 PM UTC+5:30, Vabz wrote: > >> Hi >> >> check this.. before generating new file all data will get cleared & post >>

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

2014-10-26 Thread Laxmanan M
Dear VAbz, i dont have a special words to say thanks..It's charm.. lax On Sunday, October 26, 2014 12:56:50 PM UTC+5:30, Vabz wrote: > Hi > > check this.. before generating new file all data will get cleared & post > generate file... > > you will get msg once file is generated and folder

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

2014-10-26 Thread Vaibhav Joshi
Hi check this.. before generating new file all data will get cleared & post generate file... you will get msg once file is generated and folder containing file will get opened too + *I did not do this for you. God is here working through me for you.* On Sun, Oct 26, 2014 at 11:27 AM, Laxman

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$$ 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

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$$ 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

$$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$$ 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