Re: $$Excel-Macros$$ Password protected work sheet

try below add in http://www.straxx.com/excel/password.xla . Enjoy Team XLS On Sat, May 17, 2014 at 7:04 PM, Robert Lynch wrote: > We have a form we use at work to report client income/expenses which we > would like to modify, We have been able to make some modificatio

Re: $$Excel-Macros$$ Multiple value to be picked up

what do you mean by multiple.. . Enjoy Team XLS On Sat, May 17, 2014 at 12:49 PM, Pravin Gunjal wrote: > Hello, > > I have attached an excel file. The data is already entered in this file. > > > The "Qty" column must be multiple of "Pack" column. If it is correct th

Re: $$Excel-Macros$$ Best? Ms Excel vs Ms Access?

depends on requirement... Access best as Database and Excel best as BI tool . Enjoy Team XLS On Sat, May 17, 2014 at 11:43 AM, Kannan Excel wrote: > *Dear Friends,* > > *Please tell which is the best one, Ms Excel or Ms Access?* > > -- > Are you =EXP(E:RT) or =NOT(EXP

Re: $$Excel-Macros$$ Password protected work sheet

Thank Paul :) . Enjoy Team XLS On Mon, May 19, 2014 at 4:40 PM, Paul Schreiner wrote: > Yes, there are ways to override (break) passwords. > But, per Forum Rules #3, you shouldn't seek them here. > --- > 3) Don't post questions regarding breaking or

Re: $$Excel-Macros$$ Open office

Yes, It is possible, please try below link https://wiki.openoffice.org/wiki/VBA_interoperability_in_OpenOffice . Enjoy Team XLS On Sat, May 24, 2014 at 1:58 AM, B.N.Chethan Kumar < chetankumar1...@gmail.com> wrote: > Hi, > Can we create macro in open office calc. I n

Re: $$Excel-Macros$$ EXCEL PASSWORD REMOVE

Dear Kannan, Please follow group rules 3) Don't post questions regarding breaking or bypassing any security measure. . Enjoy Team XLS On Mon, May 26, 2014 at 11:28 AM, Kannan Excel wrote: > Dear Friends, > > I want to know how to remove password in excel. > Please fi

Re: $$Excel-Macros$$ Xlsm Password removal

Please follow group rule.. see rule number 3. . Enjoy Team XLS On Sat, Jun 14, 2014 at 11:58 PM, Revathi Nair wrote: > Hello friends, > Please help me to remove password of attached excel file. > > Thanks in advance ! > > Revathy > > -- > Are you =EXP(E:RT) or =NOT(EX

Re: $$Excel-Macros$$ In Data validation Show ALL Criteria option like filter

Dear Amar, As per my understanding about your requirement, you can use if condition with your indirect formula . Enjoy Team XLS On Mon, Jun 23, 2014 at 12:06 PM, amar takale wrote: > Dear All Experts > > Can anybody tell me regarding In Data validation Show ALL Crite

Re: $$Excel-Macros$$ In Data validation Show ALL Criteria option like filter

rmula in sample sheet,i > will check it > > Thanks > Amar > > > On Mon, Jun 23, 2014 at 12:25 PM, xlstime wrote: > > Dear Amar, > > > > As per my understanding about your requirement, you can use if condition > > with your indirect formula

Re: $$Excel-Macros$$ In Data validation Show ALL Criteria option like filter

ne cell data validation. > > Regards > Amar > > On Mon, Jun 23, 2014 at 1:18 PM, xlstime wrote: > > Is this fine?.. please check attachment > > > > . > > > > Enjoy > > Team XLS > > > > > > > > On Mon, J

Re: $$Excel-Macros$$ Export data from excel to tally.

Need to install ODBC... connect excel with ODBC and use... . Enjoy Team XLS On Fri, Jun 20, 2014 at 9:46 PM, Divaker Pandey wrote: > hi experts, > > Is there any way to export data from excel to Tally 9.0 > > Divaker > > -- > Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in

Re: $$Excel-Macros$$ Select cells based on custom format

what you want? u need to convert value or else . Enjoy Team XLS On Fri, Jun 27, 2014 at 3:42 PM, Vijayendra Rao wrote: > Dear Experts, > > > > Can you please help me on selecting the cells based on custom format. > > > In attached file some figures contains Dr & Cr.

Re: $$Excel-Macros$$ I Macros tutorial & software need

Hi Amit, iMacros is the *only* software that can *automate both Internet Explorer and Firefox.* You can control both web browsers directly from Excel.*iMacros works with every website *and can automate even the most complicated websites that use dialog boxes, frames, Javascript and AJAX can be aut

Re: $$Excel-Macros$$ Hi, Friend I have a ? (I did not express properly in my previous mail - so let us have it right now)....

if i am not wrong u can use CALL macro function On Mon, Feb 20, 2012 at 12:44 PM, Mohammed Muneer wrote: > How to merge the Multiple Macro’s in single program? > > My question is little jovial – but still it is trying to learn some thing > from u masters. Thanx anyway > > **

Re: $$Excel-Macros$$ Hi, Friends I have a ?

Hi Mohammed Muneer, you must be use proper subject line or Use concise, accurate thread titles. for get quick attention or answered. On Mon, Feb 20, 2012 at 12:22 PM, Mohammed Muneer wrote: > How to merge the Multiple Macro’s in single program? > > ** ** > > ** ** > > > > ** ** > > **

Re: $$Excel-Macros$$ Update Data in Excel sheets from Master file

Hi Prasad, you can use *Advance Filter* function with macro recording . for learn advance filer http://www.contextures.com/xladvfilter01.html On Sun, Feb 19, 2012 at 9:19 PM, Prasad Gadgil wrote: > *Dear Friends,* > >> > I am having data in master sheet & wish to different sheets based

Re: $$Excel-Macros$$ how to find a text in a folder

Hi Raghu, you can use "*Agent Ransack *" searching software http://mythicsoft.com/page.aspx?type=agentransack&page=home On Sun, Feb 19, 2012 at 11:41 PM, raghu gr wrote: > Sir, > > > Sir some error in line, > > Set a = wk.Cells.Find(What:="*" & ThisWorkbook.Sheets("File > Names").Range("c2").

Re: $$Excel-Macros$$ how to find a text in a folder

files. > > > Thank you > with regards > raghu > > On Mon, Feb 20, 2012 at 11:47 PM, raghu gr wrote: > >> >> hi, >> >> Thanks this is very good. thank you >> >> with regards >> raghu >> On Mon, Feb 20, 2012 at 3:11 PM, xlst

Re: $$Excel-Macros$$ Number gets change by modification

Great Job done *Asa* *Rossoff* !!! On Thu, Feb 23, 2012 at 5:38 PM, Asa Rossoff wrote: > Hello, Priyanka, > > Just tried. > > ** ** > > It works for me any of these ways: > > (1) File-> Open (Show all files) > > (2) Data-> External-> From Text > > (3) Drag File onto Excel-> T

Re: $$Excel-Macros$$ Custom Format Examples

very useful On Wed, Feb 22, 2012 at 11:08 PM, NOORAIN ANSARI wrote: > Dear Group, > > I have shared a Custom Format example sheet, i got it from below link > > http://spreadsheetpage.com/index.php/file/custom_number_formats/ > > Hope it will help to all of you. > > -- > Thanks & regards, > Noorai

Re: $$Excel-Macros$$ how can i convert nomber to test

Hi Jitendraky, Please find the below link for number to text convert macro coding http://www.ozgrid.com/VBA/ValueToWords.htm *Hi Group, it is my suggestion that, before sending any query request you to kindly try to Google it self. * On Thu, Feb 23, 2012 at 9:06 AM, wrote: > Hi Team, pl

Re: $$Excel-Macros$$ Dialing a Phone Number in Excel??

Hi Joy, please check below link.. http://www.mrexcel.com/archive/VBA/28261.html On Fri, Feb 24, 2012 at 10:38 PM, Ms. Joy wrote: > Someone asked me if I knew how to make Excel dial a phone number??? > Has anyone ever heard of this? How would I make this happen? Can > someone explain the logic

Re: $$Excel-Macros$$ count group wise

you can use pivot table. On Fri, Feb 24, 2012 at 4:58 PM, raghunandan rallapalli < raghunandan.rallapa...@gmail.com> wrote: > Sir, > I mean, its a group wise, counting from FRA+STN wise ,, like in sql > (SELECT FRA,STN,COUNT(1) FROM COUNT GROUP BY FRA,STN > THANKS > WITH REGARDS. > RRN > > > O

Re: $$Excel-Macros$$ Formula for bucket

Hi Pankaj, You can use Lookup function. please find the example sheet. On Sat, Feb 25, 2012 at 12:57 AM, Secret Shot wrote: > Dear group, > > I want to make bucket of age like 0-2,2-4,4-6 etc. > However I can do this by if formula. > But that is very lanthy formula and also excel 2003 dose not

Re: $$Excel-Macros$$ inventory sheet

please fine the below link for excel inventory http://www.excelmagic.com/inventorymagic.html On Sat, Feb 25, 2012 at 7:31 PM, raghu gr wrote: > > > Hi, > > How to maintain inventory in excel sheet, is there any excel sheet / > template / macro. > > with regards > raghu > > -- > FORUM RULES (986

Re: $$Excel-Macros$$ how to find a text in a folder

which version you are using ? On Sat, Feb 25, 2012 at 7:00 PM, raghu gr wrote: > Hi xlstime, > its working for text only, but for numbers it is not working pls help. > > with regards > raghu > > > On Wed, Feb 22, 2012 at 9:02 PM, xlstime wrote: > >> please us

Re: $$Excel-Macros$$ Formula for bucket

; > On Sat, Feb 25, 2012 at 10:15 AM, Maries wrote: > >> Hi, >> >> Try it.. >> >> *=VLOOKUP(A1,{0,"0-2";3,"2-4";5,"4-6";7,"6+"},2,TRUE)* >> ** >> *=LOOKUP(A1,{0;3;5;7},{"0-2";"2-4";"4-

Re: $$Excel-Macros$$ how to find a text in a folder

> > > On Sat, Feb 25, 2012 at 9:32 PM, raghu gr wrote: > >> hi, >> >> i am using excel 2003 and number is stored in text only sir >> >> thank you >> >> On Sat, Feb 25, 2012 at 9:04 PM, xlstime wrote: >> >>> which version you are

Re: $$Excel-Macros$$ help needed??

please find the attachment On Sun, Feb 26, 2012 at 9:19 PM, Sourabh Salgotra wrote: > Dear sir, >plz download the attachment and help me... > > -- > FORUM RULES (986+ members already BANNED for violation) > > 1) Use concise, accurate thread titles. Poor thread titles, like Please > He

Re: $$Excel-Macros$$ Pivot uncheck All

you can use ActiveSheet.PivotTables("PivotTable1").ClearAllFilters or At the top of the window, on the Ribbon, click the *Options* tab under *PivotTable Tools*. In the *Actions* group, click *Clear*, and then click *Clear Filters *. Be sure you really want to do this before you undo all your se

Re: $$Excel-Macros$$ vlook up multiple values

as per your result requirement, you can use sumif function http://www.techonthenet.com/excel/formulas/sumif.php On Tue, Feb 28, 2012 at 11:54 PM, finos wrote: > Dear groups > > ** ** > > How can take the multiple values from the database using vlookup formula > . can u guide me . > >

Re: $$Excel-Macros$$ Concatenate help

Hi Joseph, use concatenate with text formula =CONCATENATE(A2," ",TEXT(A3,"0.00%")) On Wed, Feb 29, 2012 at 1:01 AM, wrote: > Hi guys, > > I am trying to concatenate two cells. > > One cell ha absolute number whereas the other cell is a percentage. > > For e.g., > Cell A1 = 10.534809 > Cell

Re: $$Excel-Macros$$ ODBC data from Tally

first install tally odbc driver then user odbc for more information please find the below link http://www.tally9.info/2009/10/connectivity-using-tally-erp9-using-htmlodbc-xml-and-synchronization/ On Wed, Feb 29, 2012 at 8:54 PM, Ashish Bhalara wrote: > Dear expert, > > I require the data from

Re: $$Excel-Macros$$ Formula not working

=IF(AND(AND(A2>=126,A2<=375),(B2>=500)),10,0) On Wed, Feb 29, 2012 at 10:57 PM, Jorge Marques wrote: > Hi guys, i don´t know, how is this, my formula is wrong, if i change the > weight beyond the limits it keeps giving 10. how can i change this, i think > it´s simple, but i´m not finding a solu

Re: $$Excel-Macros$$ how to save file in 2 different locations

press F12 or save as or please find the below link http://dmcritchie.mvps.org/excel/backup.htm On Sun, Mar 4, 2012 at 5:48 PM, raghu gr wrote: > hi, > > I want save same excel file in two locations (different folders) if ctrl+s > is pressed, so that there will be no need to take data backup.

Re: $$Excel-Macros$$ Need advise

use Google Insert Image option in G mail or you can use link a .gif file... [image: Inline image 1] On Mon, Mar 5, 2012 at 12:41 AM, rekha siri wrote: > hi Experts, > > I Am excel trainer, just wanted to know how can we place this kind of > animation in mail for excel functions or training's >

Re: $$Excel-Macros$$ Need advise

t; > On Mon, Mar 5, 2012 at 7:58 AM, xlstime wrote: > >> >> use Google Insert Image option in G mail or you can use link a .gif >> file... >> [image: Inline image 1] >> >> >> >> >> On Mon, Mar 5, 2012 at 12:41 AM, rekha siri wrote: >> &

Re: $$Excel-Macros$$ Excel addins see if they are of any use to you

thnax noorain.. On Tue, Mar 6, 2012 at 12:09 PM, NOORAIN ANSARI wrote: > Dear Group, > > Please find Excel addins see if they are of any use to you > > http://www.rondebruin.nl/mail/add-in.htm > http://www.cpearson.com/excel/xltools.htm > http://www.contextures.com/excelfreeaddins.html > http://w

Re: $$Excel-Macros$$ : How to use IF Function more than 8 times ?

Hi Rushiraj, you can also you lookup function please find the attachment.. On Wed, Mar 7, 2012 at 11:42 AM, Rushiraj Patel < rushiraj.pa...@in.aegisglobal.com> wrote: > Dear Experts, > > ** ** > > I am using Excel 2003. > > ** ** > > I have a file in which I need to bifurcate the figur

Re: $$Excel-Macros$$ need help to make compare sheet plz

please send the sheet with example On Tue, Mar 6, 2012 at 6:14 AM, sherif azat wrote: > what i want in the sheet > > -- > FORUM RULES (986+ members already BANNED for violation) > > 1) Use concise, accurate thread titles. Poor thread titles, like Please > Help, Urgent, Need Help, Formula Problem

Re: $$Excel-Macros$$ Remove empty cells without deleting row

You can use Go To special function On Fri, Mar 9, 2012 at 1:28 PM, Brian wrote: > In column a from row 4 to row 52 I have a list of numbers. however > some cells are empty. I need to remove the empty cells so that i > have a list of numbers from row 4 downwards with no empty cells > inbetween

Re: $$Excel-Macros$$ link Excel files (Excel table) in MS-word with MS Excel files.

you can use paste special link function .. On Mon, Mar 12, 2012 at 8:13 PM, wrote: > Dear Excel gurus, > > I want to link my excel table which is in MS WORD as table with other MS > EXCEL file. > Can it be possible with any macros. > > Sandeep Chhajer. > Sent on my BlackBerry® from Vodafone > >

Re: $$Excel-Macros$$ Most Helpful Member Feb'12 - Noorain Ansari

Congrats noorain On Thu, Mar 15, 2012 at 4:19 AM, Ayush Jain wrote: > Hello Everyone, > > Noorain Ansari has been selected as 'Most Helpful Member' for the month of > Feb'12 > He has posted 156 posts in Feb'12 and helped many people through his > expertise. He has been consistent contribu

Re: $$Excel-Macros$$ ****** FIVE YEARS COMPLETION******THANK YOU******

Congratulation Dear Ayush and all group members On Thu, Mar 22, 2012 at 4:25 AM, Ayush Jain wrote: > Dear members,** > > > > I am proud to announce that the forum has completed 5 years today. This is > really great milestone of the forum. > > My sincere thanks to each one of you w

Re: $$Excel-Macros$$ कविता: अपने Excel-Macro ग्रुप का उम्र,अब 5 साल हो गया.****** FIVE YEARS COMPLETION******THANK YOU******

Thanks Brother...and really superb 2012/3/23 NOORAIN ANSARI > जहाँ Excel के दीवानों की, है बहूत घनी आबादी. > जहाँ Question,Answer करने की,है खूब आज़ादी. > जहाँ के पोस्ट को follow कर-कर के,कितनो का Career खुशहाल हो गया. > दोस्तों उस अपने Excel-Macro ग्रुप का उम्र, अब 5 साल हो गय

Re: $$Excel-Macros$$ to remove time

HI Vijay, You can use very simple formula '=int(your date) Int is basically use for Rounds a number down to the nearest integer. On Thu, Apr 5, 2012 at 9:24 PM, vijayajith VA wrote: > Hi , > > 12/2/2001 12:00 PM --- How to remove time ? i need only date .. is > thr any formula ..Th

Re: $$Excel-Macros$$

what is this ?? On Sat, Apr 7, 2012 at 6:34 AM, Atef Gobran wrote: > > http://us.i1.yimg.com/us.yimg.com/i/mesg/tsmileys2/39.gif";>@@ > style="BACKGROUND-COLOR:#ffbf80;" face="comic sans ms" color="#4040ff">Dr. > Atef Gobran @@http://us.i1.yimg.com/us.yimg.com/i/mesg/tsmileys2/39.gif";> > > --

Re: $$Excel-Macros$$ Excel - Useful Web Links

great collection ... On Sat, Apr 7, 2012 at 3:09 AM, Maries wrote: > Dear Friends, > > I have accumulate the my collection for Excel. Please update, If you > anything more. > > I hope these links are very useful everyone. > > http://www.andrewsexceltips.net/

Re: $$Excel-Macros$$ Excel - Useful Web Links

great collection ... On Sat, Apr 7, 2012 at 3:09 AM, Maries wrote: > Dear Friends, > > I have accumulate the my collection for Excel. Please update, If you > anything more. > > I hope these links are very useful everyone. > > http://www.andrewsexceltips.net/

Re: $$Excel-Macros$$ extract data after space

you can use =LEFT(A2,FIND(" ",A2,1)-1) for before space and =right(a2,len(a2)-len(LEFT(A2,FIND(" ",A2,1)) ) after space On Fri, Apr 6, 2012 at 4:36 PM, Veeru TOC wrote: > Dear Sir, its working fine > > > anothe one i need after space data in next cell > > > example > vanam veerendra

Re: $$Excel-Macros$$ Happy Birth Day Ayush.

Happy B'Day Brother !! On Thu, Apr 26, 2012 at 11:13 AM, bhupendra singh raghav < raghav.bhupen...@gmail.com> wrote: > Hi Ayush, > > > > Many many happy returns of the day. > > > > > > > > Regards > > Raghav > > -- > FORUM RULES (986+ members already BANNED for violation) > > 1) Use concise,

Re: $$Excel-Macros$$ Rajan verma : Most Helpful Member- Apr'2012

Congratulation Rajan On Wed, May 2, 2012 at 9:30 PM, Ayush Jain wrote: > Hello Everyone, > > Rajan Verma has been selected as 'Most Helpful Member' for the month of > April'2012 > He has posted 185 posts in April 2012 and helped many people through his > expertise. He has been consistent contrib

Re: $$Excel-Macros$$ Rajan Verma - Most helpful Member(May'12)

Congratulations Rajan On Sun, Jun 3, 2012 at 11:12 PM, Ayush Jain wrote: > Hello Everyone, > > Rajan Verma has been selected as 'Most Helpful Member' for the month of > May'2012 > He has posted 147 posts in May 2012 and helped many people through his > expertise. > > I truly appreciate his consi

Re: $$Excel-Macros$$ Fwd: Rank Formula

Hi Amar, Please find the attached solution Rgds, XLS On Thu, Jul 19, 2012 at 6:32 PM, amar takale wrote: > Sir > But if student fail Then who is second highest will calculate first Rank > automatically. > Thanks > > On Thu, Jul 19, 2012 at 6:28 PM, NOORAIN ANSARI > wrote: > >> Dear Am >> >>

Re: $$Excel-Macros$$ How to calculate Days and Time.

PFA THE ATTACHED MAY BE SOLUTION On Tue, Jul 31, 2012 at 11:35 PM, Ashish kumar wrote: > Dear Champs, > > I need to consider the time difference between both the countries. I want > to calculate the overall time consumed for the dispatch to be delivered, > kindly find the attached example sheet

Re: $$Excel-Macros$$ Please tell me more about Areas Function with example.

In Excel, the *Areas* function returns the number of ranges in a reference. The syntax for the *Areas* function is: Areas( reference ) *reference* is a range of cells. If you specify more than one range, you must surround your ranges with brackets. For Example: Let's take a look at an example:

Re: $$Excel-Macros$$ Workdays formula help required

WORKDAY Returns a number that represents a date that is the indicated number of working days before or after a date (the starting date). Working days exclude weekends and any dates identified as holidays. Use WORKDAY to exclude weekends or holidays when you calculate invoice due dates, expected de

Re: $$Excel-Macros$$ Noorain Ansari - Most Helpful Member July 2012

Congratulation Noorain Bhai On Sat, Aug 4, 2012 at 12:53 AM, wrote: > ** > Congrats Boss. Keep up the momentum > Sent from my BlackBerry® smartphone from Airtel Ghana > -- > *From: * Ayush Jain > *Sender: * excel-macros@googlegroups.com > *Date: *Fri, 3 Aug

Re: $$Excel-Macros$$ Re: Excel to Access Data

use odbc connection for export and import data from access to excel On Fri, Aug 3, 2012 at 6:08 PM, wirelesscellularguy < wirelesscellular...@gmail.com> wrote: > > > On Thursday, August 2, 2012 6:59:45 PM UTC+5:30, wirelesscellularguy wrote: >> >> Hi All, >> >> I am trying to relate Access data

Re: $$Excel-Macros$$ pls help me solve my query.

please explain some more.. On Fri, Aug 3, 2012 at 11:39 AM, Kenil Gala wrote: > hi folks, > i am having a query in getting external data, > pls help me for the same. > i have written my query in the excel sheet. > > > Thanks in adv, > > Regards, > > -- > FORUM RULES (986+ members already BANNED

$$Excel-Macros$$ Business analyst

Dear All, Good morning to all !!! Can you send me the Business analyst tools or helping book/material for learn about Business analyst Thanks in advance Regards, XLS S -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already

Re: $$Excel-Macros$$ Noorain Ansari - Most Helpful Member August 2012

Congratulations Noorain On Sun, Sep 2, 2012 at 10:32 AM, Ayush Jain wrote: > Dear members, > > Once again, Noorain Ansari has been selected as 'Most Helpful Member' for > the month of Aug'12. He has posted 111 posts in August 2012 and helped many > forum members through his excel expert

Re: $$Excel-Macros$$ MIS REPORT FOR HR

Please search in below link http://www.citehr.com/48781-how-make-hr-mis.html On Sat, Sep 15, 2012 at 8:22 AM, kannan excel wrote: > Hi friends, > > i need mis report format for hr purpose. kly help me urgent base. > > regards > kannan v > > -- > Join official facebook page of this forum

Re: $$Excel-Macros$$ Re: How to repair corrupted Excel file

that's great but it's not working !!! On Thu, Oct 4, 2012 at 4:13 PM, Rajan_Verma wrote: > How many Sheets this workbook have ? > do you remember all worksheet name? > > you can write formual to recover the contain only but not formating > > ='fullpathofworkbook[WorksheetName]'!A1 > > Drag this f

Re: $$Excel-Macros$$ Rajan Verma - Most Helpful Member September 2012 *

Congratulations Mr. Rajan Ji On Wed, Oct 3, 2012 at 5:13 PM, NOORAIN ANSARI wrote: > I can say only... > > यूँ ही बरकरार रखो भाई अपने Expertise के छाप को. > और अपनी तरक्की से छोटा कर दो आसमा के माप को. > हम दोस्तों की दुआए,सदा संग बन के रहे साए... > मेरे ओर से लाख-लाख बधाई, राजन ब

Re: $$Excel-Macros$$ Need your support (Re-arrange_the_products)

excel 2007 not support VBA coding so save ur in excel 2003 or xlsb On Mon, Oct 24, 2011 at 5:44 PM, Aamir Shahzad wrote: > Dear Noorain, > > when I am saving your file it shows the attached error. please suggest. > > Regards, > > Aamir Shahzad > > On Mon, Oct 24, 2011 at 5:03 PM, MURALI NAGARAJAN

Re: $$Excel-Macros$$ Need your support (Re-arrange_the_products)

Haseeb, why u use int or mod function ? pleas tell me On Wed, Oct 26, 2011 at 12:35 AM, Haseeb Avarakkan < haseeb.avarak...@gmail.com> wrote: > Hello Murali; > > You can also use INDEX with INT & MOD > > see the attached > > HTH > Haseeb > > -- > > ---

Re: $$Excel-Macros$$ Need your support (Re-arrange_the_products)

Sorry Sam you are completely , i mean excel 2007 (Excel workbook not support vba) so save ur file in excel 2003 or excel macro enable 2007 format > On Mon, Oct 24, 2011 at 5:44 PM, Aamir Shahzad > wrote: > >> Dear Noorain, >> >> when I am saving your file it shows the attac

Re: $$Excel-Macros$$ HAPPY DIWALI!!!!!!

Happy Diwali to all. On Wed, Oct 26, 2011 at 5:51 PM, Sanjib Chatterjee < chatterjee.kolk...@gmail.com> wrote: > Dear Members, > > WISH YOU A HAPPY DIWALI. > > ALL THE BEST > > Regards, > > Sanjib > > -- > >

Re: $$Excel-Macros$$ Advanced Filter

try consolidate pivot table option.. http://tipsindeed.com/excel/data-consolidation-in-excel-made-easy-using-pivot-tables.html On Thu, Oct 27, 2011 at 4:40 PM, airen wrote: > > > Hi Noorain, > Thanks for your reply. Provided solution wont work, I dont want empty > rows in between. Is there any

Re: $$Excel-Macros$$ Need your support (Re-arrange_the_products)

mind blowing Haseeb, On Sat, Oct 29, 2011 at 5:52 AM, Haseeb Avarakkan < haseeb.avarak...@gmail.com> wrote: > Hello XLS S; > > Let me try to explain my best :) > > In sheet2 B1, used a formula to get all items in sheet1, which is > > =COUNTA(Source!A3:Z65536) > > B2, used too get total columns u

Re: $$Excel-Macros$$

try this.. =(YEAR(C3)-YEAR(B3))*12+(MONTH(C3)-MONTH(B3))+((DAY(C3)-DAY(B3))/30) On Sat, Oct 29, 2011 at 9:47 PM, Sam Mathai Chacko wrote: > Here's a more accurate formula, though longer > > > =A3*((MONTH(C3)+(12*(YEAR(C3)-YEAR(B3)))-MONTH(B3))+((DATE(YEAR(B3),MONTH(B3)+1,1)-B3)/DAY(DATE(YEAR(B3)

Re: $$Excel-Macros$$ Simple Excel Calendar

Great ..very simple and easy On Sun, Oct 30, 2011 at 7:10 AM, NOORAIN ANSARI wrote: > Dear Group, > > Please find attached Simple Excel Calender. > > =TRANSPOSE({1;2;3;4;5;6;7}) > > =IF(MONTH(F10)<>MONTH(F10-WEEKDAY(F10)+{0;1;2;3;4;5}*7+{1,2,3,4,5,6,7}),"",F10-WEEKDAY(F10)+{0;1;2;3;4;5}*7+{1,

Re: $$Excel-Macros$$ Most Helpful Member Oct'11 - Sam Mathai Chacko

Congrats Sam and * * *Don Guillett, Noorain, Ashish, Dilipandey, Rajan , Aamir, Hasib , shaneallen * On Thu, Nov 3, 2011 at 5:57 AM, Asa Rossoff wrote: > Congrats Sam! > > ** ** > > Lots of generous effort on your behalf. > > ** ** > > Asa > > ** ** > > *From:* excel-macros@googleg

Re: $$Excel-Macros$$ TO CREATE SUMMARY

Please find the attachment.. On Fri, Nov 4, 2011 at 6:53 PM, rvsingh parmar wrote: > Dear,EXCELERS > > On this workbook i want in summary sheet* fill total gift given > coloum*according their given dates Valus in second sheet (gift data),, by > any > formula . So please suggest any formul

Re: $$Excel-Macros$$ Indian formats

try this #\,##\,##\,###.00 On Sat, Nov 5, 2011 at 3:05 PM, jmothilal wrote: > dear Any one > > I want Indian format like 1,23,45,678.00, how can i define format cells. > > Thanks with > > -- > J.Mohilal > Universal Computer Systems > # 16, Brindavan Complex > Otteri, Vellore-2 > > -- > FOR

Re: $$Excel-Macros$$ Re: How to use Advance filter

try this .. http://www.contextures.com/xladvfilter01.html On Sun, Nov 6, 2011 at 4:54 PM, wrote: > Hi Rohan, > > I have tried now the same but it only giving me the column labels as > output. > > Don't know what to do. > > Sandeep Kumar Chhajer. > Sent on my BlackBerryŽ from Vodafone > > -

Re: $$Excel-Macros$$ Deleting modules

hi chandra, please find the below code for remove module .. http://www.ozgrid.com/VBA/delete-module.htm Sub DeleteThisModule() Dim vbCom As Object Set vbCom = Application.VBE.ActiveVBProject.VBComponents vbCom.Remove VBComponent:= _ vbCom.Item("Module1") End Sub On Tue, Nov

Re: $$Excel-Macros$$ Unique count in Pivot table

Hi Amit, it's not possible to put unique value in pivot table. u need to create extra column. *Team Excel* On Sun, Jan 8, 2012 at 11:10 PM, Mahesh parab wrote: > Hi Amit > > find attach workbook. hope this will help > Add one column in your pivot table data & use below formula > Assuming you w

Re: $$Excel-Macros$$ HELP - Can´t sum the same columns of a comparative column

Hi Friend, as per my observation, please find the attachment Team XLS On Fri, Jan 13, 2012 at 8:37 PM, Jorge Marques wrote: > Hi guys, i´m doing a excel file for comparatives of the year 2010, 2011, > 2012, the problem is that i need to compare days, like if i choose to see > day 10 January o

Re: $$Excel-Macros$$ SLA and Daily Productivity Tracking sheet for BPO

for which type process like inbound or outbound On Thu, Jan 12, 2012 at 4:29 PM, hemanath dhanasekar wrote: > Hey Friends, > > I am Hemanath working in a Leading BPO as Team Leader, I am new to this > industry and I need your help folks > > Can anyone help me in sharing the SLA and Productivity T

Re: $$Excel-Macros$$ Plz do the needful

Dear Aamir, very simple 13 mean 1 pm and 14 mean 2 pm but as per your example sheet you should need to replace 14 to 15.. because 15 mean 3 to 3 On Fri, Jan 13, 2012 at 10:46 PM, Aamir Shahzad wrote: > Dear Maries/Anjul Porwal, > > Why tou use "13" in your formula. can you brief? > > Regards

Re: $$Excel-Macros$$ Running/Moving Statement

Hi Santosh, yes it is possible, please find the attachment On Sat, Jan 14, 2012 at 4:56 PM, santosh subudhi < santoshkumar.subu...@gmail.com> wrote: > Hi Group, > > Is it possible to show a statement moving from right to left in MS Excel > that we usually see in websites or in our system screen

Re: $$Excel-Macros$$ Re access query

owing format >> >> >>DEALER CODE >> >>DEALER NAME >> >>RDS NAME >> >>SCH-1 >> >>SCH-2 >> >>SCH-100 >> >> TOTAL EARNING >> >> >>1 >> >>A >>

$$Excel-Macros$$ Re: ACCESS QUERY

use AutoReport: Columnar wizard On Mon, Jan 16, 2012 at 12:52 PM, vivek wrote: > I tried to prepare the report in Access . But the problem is that the > schemes details do not display vertically as required. They are displayed > horizontally. The number of schemes is about 100 , so horizontal re

Re: $$Excel-Macros$$ Urgent Required

what you want? On Tue, Jan 17, 2012 at 12:46 PM, Neeraj Chauhan wrote: > Dear All > > The correct sheet attachd > > -- > FORUM RULES (986+ members already BANNED for violation) > > 1) Use concise, accurate thread titles. Poor thread titles, like Please > Help, Urgent, Need Help, Formula

Re: $$Excel-Macros$$ Hidden file

this are the temp files..not possible to UNHIDE but try to use *attrib -s -h -r* in cmd use:- press window+r button for run then type cmd and then type atrib -s -h -r then enter On Fri, Jan 20, 2012 at 12:29 PM, Neeraj Chauhan wrote: > Dear sir, > > ** ** > > Kindly see the attached scr

Re: $$Excel-Macros$$ CHANGE DATE FORMAT

Hi Ashish, use this formula (if you date format is same 20120121 ) *=DATEVALUE(CONCATENATE(LEFT(B2,4),"-",MID(B2,5,2),"-",RIGHT(B2,2)))* On Sat, Jan 21, 2012 at 9:50 AM, Ashish Bhalara wrote: > Dear experts, > > I want to change date format from 20120121 or 21012012 to 21-Jan-2012, > because ex

Re: $$Excel-Macros$$ CHANGE DATE FORMAT

or try this one.. for any format =TEXT(B2,"-00-00")+0 On Sat, Jan 21, 2012 at 10:14 AM, xlstime wrote: > Hi Ashish, > > use this formula (if you date format is same 20120121 ) > > *=DATEVALUE(CONCATENATE(LEFT(B2,4),"-",MID(B2,5,2),"-",RIGHT(B

Fwd: $$Excel-Macros$$ CHANGE DATE FORMAT

? > > Thanks from Ashish. > > > On Sat, Jan 21, 2012 at 10:29 AM, chandra sekaran > wrote: > >> >> try this >> >> =TEXT(TEXT(B3,"-00-00"),"DD-MM-") >> >> chandru >> >> >> >> On Sat, Jan 21, 2012

Re: $$Excel-Macros$$ Formula correction needed in FD calculation

for excel 2003 =IF(ISERROR((ROUND(F5*(1+((F6/100)/C9))^(C9*IF(E7="Months",(F7/12),IF(E7="Years",F7,F7/365))),2))),"",(ROUND(F5*(1+((F6/100)/C9))^(C9*IF(E7="Months",(F7/12),IF(E7="Years",F7,F7/365))),2))) On Sun, Jan 22, 2012 at 10:37 AM, Nikhil Shah wrote: > Hi sam, > > Can you post in Excel

Re: $$Excel-Macros$$ Converting pdf to excel?

Hi Kaushi, please find the below link. http://www.mrexcel.com/tip107.shtml On Sun, Jan 22, 2012 at 3:58 PM, KAUSHIK SAVLA wrote: > Hi, > > How to convert pdf file to excel without any pdf converters? > > regards, > Kaushik Savla > > -- > FORUM RULES (986+ members already BANNED for violation) >

Re: $$Excel-Macros$$ Hours calculate highlighted colum

Dear Yasir, Please find the attachment .. formula : - =(INT(D3)+E3)-(INT(B3)+C3) On Sat, Jan 28, 2012 at 12:42 PM, yasir_shahjee wrote: > Respected Masters, > > Kindly check attached sheet. i need Time calculate in Hours. hopefully its > really easier for Masters. > > > thanks > > -- > Yasir Wa

Re: $$Excel-Macros$$ By Default 2003

HI Sajid, just right click in any excel sheet and go properties then change open with - click to change button then program file folder in (c drive) then Microsoft office folder then microsoft office2003 or office11 folder then select excel.exe then ok HI On Sun, Jan 29, 2012 at 1:25 PM, yogana

Re: $$Excel-Macros$$ Most Helpful Member Jan'12 - Noorain Ansari

Congratulation Brother !! On Wed, Feb 1, 2012 at 10:11 PM, Ayush Jain wrote: > Hello Everyone, > > Noorain Ansari has been selected as 'Most Helpful Member' for the month of > Jan'12 > He has posted 175 posts in Jan'12 and helped many people through his > expertise. He has been c

Re: $$Excel-Macros$$ Solve problem,Plz help me

Hi, please find the attachment.. On Tue, Jan 31, 2012 at 8:32 PM, Veeru TOC wrote: > > > Dear All, > > > Can i use pivot table up to data came below type but i required this type > of data > >Indus ID Alarm on Site Time IN-1008993 DG on Load 12:16:29 Mains > Fail 12:14:59 IN-1009598 M

Re: $$Excel-Macros$$ no mail since long

Hi Nemi, Check your group membership setting ( go to edit my membership (* https://groups.google.com/group/excel-macros/subscribe?hl=en* ))... and your second question i think it is sheet calculation problem please send the example On Sun, Feb 5, 2012 at 11:59 AM, N

Re: $$Excel-Macros$$ To excel macro team

Hi Pascal, Check your group membership setting ( go to edit my membership (* https://groups.google.com/group/excel-macros/subscribe?hl=en* ))... On Thu, Feb 2, 2012 at 3:18 AM, Pascal Baro wrote: > Hi, > I'm not receiving mail summary from group posting anymore. Is there

Re: $$Excel-Macros$$ Thanks in advance

Hi, use short key for refresh all pivot tables in workbook press crtl+alt+f5 On 2/11/12, Maries wrote: > Hi, > > Try this code: > > Sub AllWorkbookPivots() > Dim pt As PivotTable > Dim ws As Worksheet > For Each ws In ActiveWorkbook.Worksheets >For Each pt In ws.PivotTables >

Re: $$Excel-Macros$$ Series and Justify in Excel 2010

Hi ROhan, Please find below links http://www.howtogeek.com/howto/16386/find-office-2003-commands-in-office-2010/ http://office.microsoft.com/asstvid.aspx?&type=flash&assetid=XT010149329&vwidth=1044&vheight=788 On Fri, Feb 10, 2012 at 10:36 PM, Rohan wrote: > Hi Group, > > Could anyone please

  1   2   3   >