Re: $$Excel-Macros$$ Conditional formating help

2011-04-18 Thread jayendra gaurav
I want seprate conditional formating for each cell .



*Part No* *Min Qty* *Max Box* *Max Qty* *1-Mar-11* 981128 24 6 48 5
981250 32 3 48 4 986178 10 20 20 15 986179 20 40 40 2





On Fri, Apr 15, 2011 at 2:05 PM, ashish koul koul.ash...@gmail.com wrote:

 try the attachment


 http://www.homeandlearn.co.uk/excel2007/excel2007s6p2.html
   On Fri, Apr 15, 2011 at 9:54 AM, jayendra gaurav 
 jayendra.gau...@gmail.com wrote:




 Dear all ,



 please find herewith attached file .I want some help about conditional
 formating.



 Matter is urgent.
 --
 J.Gaurav

 Cell - 9327348097

 --

 --
 Some important links for excel users:
 1. Follow us on TWITTER for tips tricks and links :
 http://twitter.com/exceldailytip
 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
 3. Excel tutorials at http://www.excel-macros.blogspot.com
 4. Learn VBA Macros at http://www.quickvba.blogspot.com
 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com

 To post to this group, send email to excel-macros@googlegroups.com

 
 Like our page on facebook , Just follow below link
 http://www.facebook.com/discussexcel




 --
 *Regards*
 * *
 *Ashish Koul*
 *akoul*.*blogspot*.com http://akoul.blogspot.com/
 *akoul*.wordpress.com http://akoul.wordpress.com/
 My Linkedin Profile http://in.linkedin.com/pub/ashish-koul/10/400/830


 P Before printing, think about the environment.


 --

 --
 Some important links for excel users:
 1. Follow us on TWITTER for tips tricks and links :
 http://twitter.com/exceldailytip
 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
 3. Excel tutorials at http://www.excel-macros.blogspot.com
 4. Learn VBA Macros at http://www.quickvba.blogspot.com
 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com

 To post to this group, send email to excel-macros@googlegroups.com

 
 Like our page on facebook , Just follow below link
 http://www.facebook.com/discussexcel




--

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com


Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel


$$Excel-Macros$$ Fwd: SEARCH FUNCTION

2011-04-18 Thread C.G.Kumar
PFA sample File.

-- Forwarded message --
From: C.G.Kumar kumar.bemlmum...@gmail.com
Date: Mon, Apr 18, 2011 at 1:45 PM
Subject: SEARCH FUNCTION
To: excel-macros@googlegroups.com


Dear All,


I intend to generate list based on search of Text String.Sample file
attached.

Regards,

C.G.Kumar

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com


Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel


Medical Rate.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet


$$Excel-Macros$$ SEARCH FUNCTION

2011-04-18 Thread C.G.Kumar
Dear All,


I intend to generate list based on search of Text String.Sample file
attached.

Regards,

C.G.Kumar

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com


Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel


$$Excel-Macros$$ Search Formula

2011-04-18 Thread C.G.Kumar
Hello,
I have a very tricky problem. I have got an excel sheet having some columns
but more than 5000 rows. In those columns there are some names which may/may
not be similar to each other. I want to make a macro which can:
1. Search for the name. e.g. If I have Katie Holmes in 1st row, Sherlock
Holmes in 2nd row, Holmes Matt in 3rd row, James Holmes Dammon in 4th row
and so onthen if put only Holmes in search criteria then it should get
the result for all the 4 rows.
2. Secondly it should display only those 4 rows in the result. Like if we
are using a sort function.


Regards,

C.G.Kumar

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com


Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel


$$Excel-Macros$$ down load data from BSE/NSE

2011-04-18 Thread jayendra gaurav
Dear Group.


I want to basically fetch historical data of stock markets -
derivatives - from the website of NSEINDIA.COM http://nseindia.com/,

please help me




-- 
J.Gaurav

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com


Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel


Re: $$Excel-Macros$$ down load data from BSE/NSE

2011-04-18 Thread sumit kumar
Pls go to nseindia.com websitethen click on equitythen click on
historical data under market information heading.then u can find options
of indices data and security wise datait will give data in an excel
filehope it will help u...


Regards
Sumit

On Mon, Apr 18, 2011 at 11:27 AM, jayendra gaurav jayendra.gau...@gmail.com
 wrote:

 Dear Group.


 I want to basically fetch historical data of stock markets -
 derivatives - from the website of NSEINDIA.COM http://nseindia.com/,

 please help me




 --
 J.Gaurav

 --

 --
 Some important links for excel users:
 1. Follow us on TWITTER for tips tricks and links :
 http://twitter.com/exceldailytip
 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
 3. Excel tutorials at http://www.excel-macros.blogspot.com
 4. Learn VBA Macros at http://www.quickvba.blogspot.com
 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com

 To post to this group, send email to excel-macros@googlegroups.com

 
 Like our page on facebook , Just follow below link
 http://www.facebook.com/discussexcel


-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com


Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel


Re: $$Excel-Macros$$ Search Formula

2011-04-18 Thread rajan verma
you should apply contain Filter.. i think

On Mon, Apr 18, 2011 at 2:21 PM, C.G.Kumar kumar.bemlmum...@gmail.comwrote:

 Hello,
 I have a very tricky problem. I have got an excel sheet having some columns
 but more than 5000 rows. In those columns there are some names which may/may
 not be similar to each other. I want to make a macro which can:
 1. Search for the name. e.g. If I have Katie Holmes in 1st row, Sherlock
 Holmes in 2nd row, Holmes Matt in 3rd row, James Holmes Dammon in 4th row
 and so onthen if put only Holmes in search criteria then it should get
 the result for all the 4 rows.
 2. Secondly it should display only those 4 rows in the result. Like if we
 are using a sort function.


 Regards,

 C.G.Kumar

 --

 --
 Some important links for excel users:
 1. Follow us on TWITTER for tips tricks and links :
 http://twitter.com/exceldailytip
 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
 3. Excel tutorials at http://www.excel-macros.blogspot.com
 4. Learn VBA Macros at http://www.quickvba.blogspot.com
 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com

 To post to this group, send email to excel-macros@googlegroups.com

 
 Like our page on facebook , Just follow below link
 http://www.facebook.com/discussexcel




-- 
Regards
Rajan verma
+91 9158998701

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com


Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel


Re: $$Excel-Macros$$ Fwd: SEARCH FUNCTION

2011-04-18 Thread STDEV(i)
plese check the attached workbook, and see if it helps.


*ARRAY FORMULA*
=small(if(left(C2:C29,len(F4))=F4,row(1:28)),row(1:28))

FORMULA
=IF(ISERR($D6),,OFFSET(A$1,$D6,0))




On Mon, Apr 18, 2011 at 3:16 PM, C.G.Kumar kumar.bemlmum...@gmail.comwrote:

 PFA sample File.

 -- Forwarded message --
 From: C.G.Kumar kumar.bemlmum...@gmail.com
 Date: Mon, Apr 18, 2011 at 1:45 PM
 Subject: SEARCH FUNCTION
 To: excel-macros@googlegroups.com


 Dear All,

 I intend to generate list based on search of Text String.Sample file
 attached.
 Regards,
 C.G.Kumar


-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com


Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel


siti_About Filtering Formula (Medical Rate).xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet


$$Excel-Macros$$ Re: Search Formula

2011-04-18 Thread ashish koul
try this see if it helps

On Mon, Apr 18, 2011 at 2:21 PM, C.G.Kumar kumar.bemlmum...@gmail.comwrote:

 Hello,
 I have a very tricky problem. I have got an excel sheet having some columns
 but more than 5000 rows. In those columns there are some names which may/may
 not be similar to each other. I want to make a macro which can:
 1. Search for the name. e.g. If I have Katie Holmes in 1st row, Sherlock
 Holmes in 2nd row, Holmes Matt in 3rd row, James Holmes Dammon in 4th row
 and so onthen if put only Holmes in search criteria then it should get
 the result for all the 4 rows.
 2. Secondly it should display only those 4 rows in the result. Like if we
 are using a sort function.


 Regards,

 C.G.Kumar




-- 
*Regards*
* *
*Ashish Koul*
*akoul*.*blogspot*.com http://akoul.blogspot.com/
*akoul*.wordpress.com http://akoul.wordpress.com/
My Linkedin Profile http://in.linkedin.com/pub/ashish-koul/10/400/830


P Before printing, think about the environment.

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com


Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel


search filter.xlsm
Description: Binary data


Re: $$Excel-Macros$$ Search Formula

2011-04-18 Thread C.G.Kumar
Thanks Ranjan but I could not use file filter because;

1.Data is required at different place.
2.Filter is not effective when i have to use it more than 50 times in a day.
3.Data captured on the basis of the criteria is further required for
calculation purpose.


Therefore, i intend to use *formula only  not macro.*


Regards,

C.G.Kumar

On Mon, Apr 18, 2011 at 2:43 PM, rajan verma rajanverma1...@gmail.comwrote:

 you should apply contain Filter.. i think


 On Mon, Apr 18, 2011 at 2:21 PM, C.G.Kumar kumar.bemlmum...@gmail.comwrote:

 Hello,
 I have a very tricky problem. I have got an excel sheet having some
 columns but more than 5000 rows. In those columns there are some names which
 may/may not be similar to each other. I want to make a macro which can:
 1. Search for the name. e.g. If I have Katie Holmes in 1st row, Sherlock
 Holmes in 2nd row, Holmes Matt in 3rd row, James Holmes Dammon in 4th row
 and so onthen if put only Holmes in search criteria then it should get
 the result for all the 4 rows.
 2. Secondly it should display only those 4 rows in the result. Like if we
 are using a sort function.


 Regards,

 C.G.Kumar

 --

 --
 Some important links for excel users:
 1. Follow us on TWITTER for tips tricks and links :
 http://twitter.com/exceldailytip
 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
 3. Excel tutorials at http://www.excel-macros.blogspot.com
 4. Learn VBA Macros at http://www.quickvba.blogspot.com
 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com

 To post to this group, send email to excel-macros@googlegroups.com

 
 Like our page on facebook , Just follow below link
 http://www.facebook.com/discussexcel




 --
 Regards
 Rajan verma
 +91 9158998701

 --

 --
 Some important links for excel users:
 1. Follow us on TWITTER for tips tricks and links :
 http://twitter.com/exceldailytip
 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
 3. Excel tutorials at http://www.excel-macros.blogspot.com
 4. Learn VBA Macros at http://www.quickvba.blogspot.com
 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com

 To post to this group, send email to excel-macros@googlegroups.com

 
 Like our page on facebook , Just follow below link
 http://www.facebook.com/discussexcel


-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com


Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel


Re: $$Excel-Macros$$ Fwd: SEARCH FUNCTION

2011-04-18 Thread C.G.Kumar
Thanks .


I have modified the formula to suit my requirement as follows;

SMALL(IF(ISNUMBER(SEARCH((Report!B1),C2:C28,1)),ROW(1:28),ROW(1:28))


Thanks buddy for giving me the direction.


Regards,

C.G.Kumar

On Mon, Apr 18, 2011 at 3:33 PM, STDEV(i) setiyowati.d...@gmail.com wrote:

 plese check the attached workbook, and see if it helps.


 *ARRAY FORMULA*
 =small(if(left(C2:C29,len(F4))=F4,row(1:28)),row(1:28))

 FORMULA
 =IF(ISERR($D6),,OFFSET(A$1,$D6,0))




 On Mon, Apr 18, 2011 at 3:16 PM, C.G.Kumar kumar.bemlmum...@gmail.comwrote:

 PFA sample File.

 -- Forwarded message --
 From: C.G.Kumar kumar.bemlmum...@gmail.com
 Date: Mon, Apr 18, 2011 at 1:45 PM
 Subject: SEARCH FUNCTION
 To: excel-macros@googlegroups.com


 Dear All,

 I intend to generate list based on search of Text String.Sample file
 attached.
 Regards,
 C.G.Kumar


  --

 --
 Some important links for excel users:
 1. Follow us on TWITTER for tips tricks and links :
 http://twitter.com/exceldailytip
 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
 3. Excel tutorials at http://www.excel-macros.blogspot.com
 4. Learn VBA Macros at http://www.quickvba.blogspot.com
 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com

 To post to this group, send email to excel-macros@googlegroups.com

 
 Like our page on facebook , Just follow below link
 http://www.facebook.com/discussexcel


-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com


Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel


RE: $$Excel-Macros$$ SEARCH FUNCTION

2011-04-18 Thread Daniel
Hi,

Please, attach file ;-)

Daniel

 

De : excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] De
la part de C.G.Kumar
Envoyé : lundi 18 avril 2011 10:15
À : excel-macros@googlegroups.com
Objet : $$Excel-Macros$$ SEARCH FUNCTION

 

Dear All,

 

 

I intend to generate list based on search of Text String.Sample file
attached.

 

Regards,

 

C.G.Kumar

-- 

--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com

To post to this group, send email to excel-macros@googlegroups.com
 

Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com


Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel


Re: $$Excel-Macros$$ Problem in pivot table

2011-04-18 Thread alisha malhotra
Hi Ashish,

Thanks for your help.

Regards,
Alisha

On Sat, Apr 16, 2011 at 9:49 AM, ashish koul koul.ash...@gmail.com wrote:

 its because its showing subtotals . hide them thats it . keep the cursor on
 vgood right click and unselect subtotal ,same for good etc.




 On Fri, Apr 15, 2011 at 11:32 PM, alisha malhotra 
 alisha.malhotr...@gmail.com wrote:

 Hi Ashish,

 I have made the pivot table using the layout as yours layout. But my pivot
 is little bit complicated.Why is that so happening?. Why did you use
 employee code in data instead of count of poor or count of avg etc.? I am
 sending you the attachment.

 Regards,
 Alisha


 On Fri, Apr 15, 2011 at 10:27 AM, ashish koul koul.ash...@gmail.comwrote:

 see if it helps

  On Thu, Apr 14, 2011 at 9:29 PM, alisha malhotra 
 alisha.malhotr...@gmail.com wrote:

 Hi,

 I want to create one pivot table. In this, *I want to calculate the
 number of employees in Poor, Avg,  good, and very good.*
 But it is showing the same no. of employees in each category that is
 wrong.

 I am sending you the file as attachment. Please help me in creating the
 pivot table.

 *Please tell me how to use formula in pivot table also*.

 Waiting for your reply.

 Thanks  Regards,
 Alisha


 --

 --
 Some important links for excel users:
 1. Follow us on TWITTER for tips tricks and links :
 http://twitter.com/exceldailytip
 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
 3. Excel tutorials at http://www.excel-macros.blogspot.com
 4. Learn VBA Macros at http://www.quickvba.blogspot.com
 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com

 To post to this group, send email to excel-macros@googlegroups.com

 
 Like our page on facebook , Just follow below link
 http://www.facebook.com/discussexcel




 --
 *Regards*
 * *
 *Ashish Koul*
 *akoul*.*blogspot*.com http://akoul.blogspot.com/
 *akoul*.wordpress.com http://akoul.wordpress.com/
 My Linkedin Profile http://in.linkedin.com/pub/ashish-koul/10/400/830


 P Before printing, think about the environment.


 --

 --
 Some important links for excel users:
 1. Follow us on TWITTER for tips tricks and links :
 http://twitter.com/exceldailytip
 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
 3. Excel tutorials at http://www.excel-macros.blogspot.com
 4. Learn VBA Macros at http://www.quickvba.blogspot.com
 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com

 To post to this group, send email to excel-macros@googlegroups.com

 
 Like our page on facebook , Just follow below link
 http://www.facebook.com/discussexcel


   --

 --
 Some important links for excel users:
 1. Follow us on TWITTER for tips tricks and links :
 http://twitter.com/exceldailytip
 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
 3. Excel tutorials at http://www.excel-macros.blogspot.com
 4. Learn VBA Macros at http://www.quickvba.blogspot.com
 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com

 To post to this group, send email to excel-macros@googlegroups.com

 
 Like our page on facebook , Just follow below link
 http://www.facebook.com/discussexcel




 --
 *Regards*
 * *
 *Ashish Koul*
 *akoul*.*blogspot*.com http://akoul.blogspot.com/
 *akoul*.wordpress.com http://akoul.wordpress.com/
 My Linkedin Profile http://in.linkedin.com/pub/ashish-koul/10/400/830


 P Before printing, think about the environment.


  --

 --
 Some important links for excel users:
 1. Follow us on TWITTER for tips tricks and links :
 http://twitter.com/exceldailytip
 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
 3. Excel tutorials at http://www.excel-macros.blogspot.com
 4. Learn VBA Macros at http://www.quickvba.blogspot.com
 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com

 To post to this group, send email to excel-macros@googlegroups.com

 
 Like our page on facebook , Just follow below link
 http://www.facebook.com/discussexcel


-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com


Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel


Re: $$Excel-Macros$$ Deploying Excel 2003 updates

2011-04-18 Thread ashish koul
try these links

http://www.ozgrid.com/Excel/ExcelSpreadsheetDesign.htm

http://www.ozgrid.com/VBA/SpeedingUpVBACode.htm

http://www.cpearson.com/excel/optimize.htm

On Sun, Apr 17, 2011 at 2:48 PM, BJthebear brian.jerm...@gmail.com wrote:

 I have a spreadsheet with multiple macros and userforms running perfectly
 in Excel 2003 across 10 different sites with 10 different sets of
 information in the tables - but there are various improvements that have
 been requested and I was looking for some advice on redeploying a revised
 spreadsheet to each of the sites:-

 1.  Are there any links which would point me in the right direction

 2.  Is there a developers pack that makes this sort of thing easy - I am
 concerned about reformatting certain things in certain Worksheets -
 rewriting macros etc and ensuring that all the information is deployed
 correctly to all sites

 Any help and advice would be truly appreciated

 thanks

 Brian

 --

 --
 Some important links for excel users:
 1. Follow us on TWITTER for tips tricks and links :
 http://twitter.com/exceldailytip
 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
 3. Excel tutorials at http://www.excel-macros.blogspot.com
 4. Learn VBA Macros at http://www.quickvba.blogspot.com
 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com

 To post to this group, send email to excel-macros@googlegroups.com

 
 Like our page on facebook , Just follow below link
 http://www.facebook.com/discussexcel




-- 
*Regards*
* *
*Ashish Koul*
*akoul*.*blogspot*.com http://akoul.blogspot.com/
*akoul*.wordpress.com http://akoul.wordpress.com/
My Linkedin Profile http://in.linkedin.com/pub/ashish-koul/10/400/830


P Before printing, think about the environment.

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com


Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel