$$Excel-Macros$$ Re: How to remove error To many different cell formats in excel

2012-12-31 Thread Prince
Hi Maulik, Please share your workbook. Regards Prince On Monday, December 31, 2012 1:05:37 PM UTC+5:30, maulik wrote: Hi team, I am having 1 excel sheet which shows me error like to many diff cell format while opening the file . Can. Someone provide me the Solution for this. -- Join

$$Excel-Macros$$ Re: How to extract sheet from many excel sheets

2012-12-31 Thread Prince
Hi Maulik, Please cut and paste this code.I hpe this may be helfull for you. Sub CreatWorkbook() Dim wks As Worksheet Dim wbk As Workbook Dim intCtr As Integer intCtr = 1 For Each wks In ThisWorkbook.Worksheets If wks.Name test Then Set wbk

$$Excel-Macros$$ Re: Sheets name change as per the main list column A

2012-12-31 Thread Prince
Hi Rajesh, I guess there is no way to change the name of sheet through formula.But yes your query very much possible through VBA Macro. Regards Prince On Monday, December 31, 2012 1:17:56 PM UTC+5:30, rajeyssh wrote: Dear Sir if I put column b or column c list in column a all the sheets

Re: $$Excel-Macros$$ How to remove error To many different cell formats in excel

2012-12-31 Thread NOORAIN ANSARI
Dear Maulik, Can you share your sample sheet with group. On Mon, Dec 31, 2012 at 1:05 PM, maulik desai mauliksde...@gmail.comwrote: Hi team, I am having 1 excel sheet which shows me error like to many diff cell format while opening the file . Can. Someone provide me the Solution for this.

Re: $$Excel-Macros$$ query for getting external data from a website

2012-12-31 Thread Kenil Gala
Thanks dhaval,but how do i use in my project file.can i import all this data in my same project sheet?and i want to import it automatically by changing date and nse symbol in my excel sheet itself.is that also can be done ?? --- On Mon, 12/31/12, Dhaval Shah todhavals...@gmail.com wrote:

Re: $$Excel-Macros$$ Fwd: Hepl Required

2012-12-31 Thread neeraj chauhan
On Sat, Dec 29, 2012 at 9:49 PM, Excel Beginner excelbegin...@gmail.com wrote: Hi Neeraj, Pls check attachment. -- *Regards,* * * *Excel Beginner* On Sat, Dec 29, 2012 at 3:46 PM, neeraj chauhan neerajchauhan...@gmail.com wrote: DEAR Experts, i am waiting for

$$Excel-Macros$$ Re: Macro to create attendance Sheet for each Employee

2012-12-31 Thread Lalit Mohan Pandey
Hi Rashid, Sorry i can't upload file so please follow the given steps: *Step 1:- First create a sample sheet for output report with all the formatting and formula and please make sure it should be for 31 rows as* *max day in a month is 31.* *Step 2:- Press Alt + F11 and Alt + I + M and

Re: $$Excel-Macros$$ Re: Loop for changing colour

2012-12-31 Thread Lalit Mohan Pandey
Hi Black, Did you find the solution is helpful. Regards, Lalit Mohan On Monday, 31 December 2012 10:18:25 UTC+5:30, black panther wrote: Dear Prince, No same color, any color but light color, What i am looking for:- if cell A1 having yellow B1 having blue then for 1500 time it need

$$Excel-Macros$$ Happy New Year To All My Friends

2012-12-31 Thread Prince
*Happy New Year To All.* * * *May God bless you a very nice new year ahead. * * * * * *Regards* *Prince* -- 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, Need

$$Excel-Macros$$ Re: Happy New Year To All My Friends

2012-12-31 Thread Lalit Mohan Pandey
*Same to you prince and Happy new year to all group members. May all your dreams come true in this year.* Regards, Lalit Mohan On Monday, 31 December 2012 17:26:31 UTC+5:30, Prince wrote: *Happy New Year To All.* * * *May God bless you a very nice new year ahead. * * * * * *Regards*

Re: $$Excel-Macros$$ Fwd: Hepl Required

2012-12-31 Thread Prajakt Pande
Dear Neeraj Chauhan, Please check and reply. It solved. file attached Thanks Regards, Prajakt Pande +971551388482 ** On Mon, Dec 31, 2012 at 1:20 PM, neeraj chauhan neerajchauhan...@gmail.comwrote: On Sat, Dec 29, 2012 at 9:49 PM, Excel Beginner excelbegin...@gmail.com wrote: Hi

Re: $$Excel-Macros$$ How to extract sheet from many excel sheets

2012-12-31 Thread Anoop K Sharma
Better to make another copy of workbook bcoz somehow you are asking the same thing. On Mon, Dec 31, 2012 at 1:01 PM, maulik desai mauliksde...@gmail.comwrote: Hi team, I am having 1excel workbook which contains 250 excel sheets and now I want to extract those sheets into separate workbook

Re: $$Excel-Macros$$ Re: VBA to Destination of Value only

2012-12-31 Thread Cab Boose
Thnkyou Guys for the codes. The code that Anoop sen t works very well, and I will go with that. Thanks for your help Lalit and Anoop Regards Charlie On Mon, Dec 31, 2012 at 7:45 PM, Anoop K Sharma aks.sharm...@gmail.comwrote: Please try the below one. Sub PasteValueOnly() Dim rng As

Re: $$Excel-Macros$$ happy new year

2012-12-31 Thread johnson john
thanks!!! I wish you all a great pleasure of learning EXCEL in 2013. Its so cool. regards., Johnson FCA On Tue, Jan 1, 2013 at 10:58 AM, excel lerner exceller...@gmail.com wrote: I wish You a very happy New Year to all Grou Members -- Join official Facebook page of this forum @

$$Excel-Macros$$ Re: NSEINDIA Stock Price change Automatically

2012-12-31 Thread amar takale
Can anybody help me pls On Fri, Dec 28, 2012 at 4:26 PM, amar takale amartak...@gmail.com wrote: Dear Experts team, A humble request with experts to provide me a solution or guide me how to extract closing price for specific stock Example ABB,ACC,INFY,WIPRO from nseindia website.If Share