Re: $$Excel-Macros$$ Insert raw based on condition in a range

Hi Paul Thanks for the code, I want to get the copied data in a bold format to understand it as a group head and if possible merged with the two adjacent cells. . Regards Thanks Rajesh Kainikkara On 2/12/11, Paul Schreiner schreiner_p...@att.net wrote: I think your description is a little

Re: $$Excel-Macros$$ Need Help!!!!!!!!!!!!!!!!!

That was Excel limitation: max number of criteria (unique values list)on Auto Filter = 1000 On 2/13/11, Aamir Shahzad aamirshahza...@gmail.com wrote: sheet attached, simply when you want to use auto filter you must select all your data till at the end. Regards, Aamir Shahzad On Wed, Feb

$$Excel-Macros$$ How to Get Filtered Data from SQL server into Microsoft Excel 2007

I want to import data from SQL server 2005 into Excel 2007 using Data=from other sources=From SQL server. I am able to import complete table (e.g. Item) but there are too many unnecessary fields as well as records which also get imported. I want to filter the data before importing into excel but

$$Excel-Macros$$ reduce the size of code

Hi I have a workbook which contain 15 sheets ,sheet1 is the data of January, sheet2 is February and so on, the last 3 sheet have some data for comparison.I am using a macro code to copy the data like this Sub Update_sheet_April() If Sheets(APRIL).Range(b5) = 0 Then

Re: $$Excel-Macros$$ Macro issue passing values from Cell to columns

I have names from cell B1 to cell B1000, but sometimes i need to pass the B1000 to C1 B999 to C2 and so on, i don´t know if this is a stupid question lol, because i can do it by putting a filter in it in A cell but i was wondering if there´s a tool ou way to do this! 2011/2/12 Paul Schreiner

Re: $$Excel-Macros$$ Re: query for a solution

hi Prakash Singh Gusain and others experts thanks for your supportu all provide very helpful solution. thnks again Have A Nice Time Enjoy Life Regards: CMA Ankur Pandey (Someone Different) I'm not the best but i'm not like the rest~~ On Thu, Feb 10, 2011 at 3:53 PM, Prakash Gusain

Re: $$Excel-Macros$$ Shorting Problems

*thnks friends ,i was also looking this kind of solution *Have A Nice Time Enjoy Life Regards: CMA Ankur Pandey (Someone Different) I'm not the best but i'm not like the rest~~ On Thu, Feb 10, 2011 at 11:45 AM, hanumant shinde hanumant_5...@yahoo.co.in wrote: Hi Sudhir, i have done this

$$Excel-Macros$$ Display a Comment Picture/Image in user form

Hi All, I am using a excel add-in (SMF-Add In) which can generate a text and/or an image using a *RCHCreateComment function*. I want to use this function and display this image in excel user form. Please provide some suggestion for this. Regards, San --

RE: $$Excel-Macros$$ How to consolidate the data using macro

any success. :-( --- On Fri, 2/11/11, shannu shannu shannur...@yahoo.com wrote: From: shannu shannu shannur...@yahoo.com Subject: RE: $$Excel-Macros$$ How to consolidate the data using macro To: excel-macros@googlegroups.com Date: Friday, February 11, 2011, 4:51 PM one of the beautifull