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

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 wrote: > I have a spreadsheet with multiple macros and userforms running perfectly > in

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

Hi Ashish, Thanks for your help. Regards, Alisha On Sat, Apr 16, 2011 at 9:49 AM, ashish koul 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 ma

RE: $$Excel-Macros$$ SEARCH FUNCTION

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 bas

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

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) wrote: > plese check the attached workbook,

Re: $$Excel-Macros$$ Search Formula

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

$$Excel-Macros$$ Re: Search Formula

try this see if it helps On Mon, Apr 18, 2011 at 2:21 PM, C.G.Kumar wrote: > 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 w

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

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 wrote: > PFA sample File. > > -- Forwarded message -- > Fro

Re: $$Excel-Macros$$ Search Formula

you should apply contain Filter.. i think On Mon, Apr 18, 2011 at 2:21 PM, C.G.Kumar wrote: > 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

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

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

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

Dear Group. I want to basically fetch historical data of stock markets - derivatives - from the website of NSEINDIA.COM , please help me -- J.Gaurav -- -- Some important links for excel u

$$Excel-Macros$$ Search Formula

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 Ho

$$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://t

$$Excel-Macros$$ Fwd: SEARCH FUNCTION

PFA sample File. -- Forwarded message -- From: C.G.Kumar 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 -- ---

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

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 wrote: > try the attachment > > > http://www.homeandlearn.co.uk/e

Re: $$Excel-Macros$$ how to copy all sheets data in one sheet by VBA

Thanx Ansul, This code really works. Regards Yogesh Gohil On Sun, Apr 17, 2011 at 11:13 AM, ashish koul wrote: > try this > > Sub method2() > Dim i, j, k, s As Long > s = Sheets.Count > Sheets.Add After:=Sheets(Sheets.Count) > For i = 1 To s > Sheets(i).Select > 'change upper row here in this