$$Excel-Macros$$ Disable of print option in excel menu

2011-03-24 Thread rajafs...@gmail.com
Hi group, How to disable print option in excel menu, because i want to disable the menu function of print and i wants to provide a button for printing in excel -- -- Some important links for excel users: 1. Follow

$$Excel-Macros$$ Help with replacing Application.FileSearch in macro

2011-03-24 Thread Dave
Hi Gurus,, I have the following macro that has been working fine for ages in Excel 2003 and now is giving me "run time error 445 Object doesn't support this action" in Excel 2010. I need help in fixing this macro please. I have read about the "dir" method & "Application.FileSearch" methods

$$Excel-Macros$$ userform is not opening

2011-03-24 Thread santosh subudhi
Hi Friends, Need another help. I am trying to upload a userform using combobox but it is not working. Sample sheet is attached. Regards Santosh santoshkumar.subu...@gmail.com -- -- Some important links for excel u

Re: $$Excel-Macros$$ Is there any carrer in excel.

2011-03-24 Thread hanumant shinde
Bhushan If you are expert in anythign company is wating for you. Rob Bunce one of the gods in Excel whom i know. he works in our company UK Branch and if he resigns hahaha company will shut that process. you can guess how much he must be earning. i myself in Capgem and earning good money.(thank

$$Excel-Macros$$ Re: Median/IF Forumla producing a #NUM Error ~ Help!

2011-03-24 Thread Susan 1
No need to answer I have the formula, thanks! {=IF(ISERR(MEDIAN(IF($F$5:$F$17=4,$H$5:$H$17))),"No Minutes Done for This Unit",MEDIAN(IF($F$5:$F$17=4,$H$5:$H$17)))} On Thu, Mar 24, 2011 at 9:01 AM, Anderson, Susan wrote: > Hi , > > Can you help me with the formula below? See Tab Mar 05, column AB

Re: $$Excel-Macros$$ Macro to sum across columns and replace columns with calculated result

2011-03-24 Thread ashish koul
can you attach the sample data and headers you are using On Fri, Mar 25, 2011 at 1:53 AM, 0 1 wrote: > I have a spreadsheet with States as rows. For each State, there are 4 > columns of data for Year 1, then 4 more columns of data for Year 2, > and so on. Each column represents a quarter for tha

$$Excel-Macros$$ Macro to sum across columns and replace columns with calculated result

2011-03-24 Thread 0 1
I have a spreadsheet with States as rows. For each State, there are 4 columns of data for Year 1, then 4 more columns of data for Year 2, and so on. Each column represents a quarter for that year. For example: Column A lists the State --- Column B data for 1st quarter, 2000 Column C data for 2nd

$$Excel-Macros$$ discussexcel : TIP : Find the currently active cell

2011-03-24 Thread Ayush
A Quick Tip : How to find the currently active cell http://www.discussexcel.com/excel-tips/excel-tips/findthecurrentlyactivecell Regards Ayush Jain -- -- Some important links for excel users: 1. Follow us on TWITTER

Re: $$Excel-Macros$$ Is there any carrer in excel.

2011-03-24 Thread anandydr
Hi, Beside openings in MIS there are a lot of opportunities in back end operations in Banking, Mutual Funds and Insurance organizations. More importantly the knowledge of data analytics is what makes the use of Excel as an important tool. A lot of companies look for professionals with this skill s

Re: $$Excel-Macros$$ Re: How to prevent from duplication in one work book

2011-03-24 Thread Muhammad Talal Akbar
i m very thankful to u my dear for your this act of kindness. but still i have problem. your solution is applicable only on one sheet not on complete workbook. plz help me out from this problem regards On Thu, Mar 24, 2011 at 2:46 PM, Bhushan Sabbani wrote: > Dear Arya, > > Please find the b

$$Excel-Macros$$ Re: How to prevent from duplication in one work book

2011-03-24 Thread Bhushan Sabbani
Dear Arya, Please find the below attached file. Pls let me know any problem in the file. Warm Regards Bhushan Sabbani +91 98208 26012 -- -- Some important links for excel users: 1. Follow us on TWITTER for tips t

$$Excel-Macros$$ Re: Count of color fills

2011-03-24 Thread Bhushan Sabbani
your are welcome, Warm Regards Bhushan Sabbani +91 98208 26012 -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN g

$$Excel-Macros$$ Excel Password Breaker Code...

2011-03-24 Thread NOORAIN ANSARI
Dear Experts., Please find & use below VBA code to break password in EXCEL Procedure : Press alt+F11 Insert-Module then Paste below code Press-F5 to run *Sub PasswordBreaker() Dim i As Integer, j As Integer, k As Integer Dim l As Integer, m As Integer,

$$Excel-Macros$$ Median If Formula

2011-03-24 Thread Dave Bonallack
Hi Susan, =MEDIAN(IF(F5:F17=1,H5:H17)) This is right, but it's an array formula, so you have to enter it with Ctrl+Shift+Enter When you do this, it gives the right answer. Regards - Dave. Date: Wed, 23 Mar 2011 14:39:36 -0700 Subject: $$Excel-Macros$$ Median If Formula From: sunni...@gmail.co

$$Excel-Macros$$ Re: Count of color fills

2011-03-24 Thread Nizamuddin sayyad
Thanks Bhushan On Thu, Mar 24, 2011 at 11:20 AM, Bhushan Sabbani wrote: > Dear sayyad, > > Please find the below attached file. > > Pls let me know any problem in the file. > > > Warm Regards > Bhushan Sabbani > +91 98208 26012 > > > -- --

$$Excel-Macros$$ Re: Count of color fills

2011-03-24 Thread Bhushan Sabbani
Dear sayyad, Please find the below attached file. Pls let me know any problem in the file. Warm Regards Bhushan Sabbani +91 98208 26012 -- -- Some important links for excel users: 1. Follow us on TWITTER for tips

$$Excel-Macros$$ How to prevent from duplication in one work book

2011-03-24 Thread Muhammad Talal Akbar
my question is i enterd the word "Akbar" in the sheet 1 and then i moved towards sheet 3 and there i m again going to enter "Akbar" at this time excel notify me that i have already entered the same word in sheet numer 1 at column - and row -. and also vise versa plz help me regards --

Re: $$Excel-Macros$$ Re: hello all, its very urgent;;;

2011-03-24 Thread Sanjoy Nath
great On Wed, Mar 23, 2011 at 3:22 PM, Bhushan Sabbani wrote: > Dear Vijay, > > Please visit the site http://chandoo.org there is great dashboard along > with the tip and trick for preparing the same. > > > Warm Regards > Bhushan Sabbani > +91 98208 26012 > > > -- > > --

Re: $$Excel-Macros$$ Help on condition and return value

2011-03-24 Thread Ms-Exl-Learner .
Try this… =IF(ISNUMBER(FIND(" ",TRIM(B2))),LEFT(TRIM(B2),FIND(" ",TRIM(B2))),IF(LEN(TRIM(B2))<>0,B2,"")) --- Ms.Exl.Learner --- On Thu, Mar 24, 2011 at 4:20 AM, Jorge Marques wrote: > Hi guys, is there any way i can do to for example if a cell B2 has th