Search results

Please follow the post: http://chandoo.org/forums/topic/posting-a-sample-workbook

can u upload a sample file??

use following formula =SUMPRODUCT(COUNTIF(INDIRECT("'"&Tabnames!A1&"'!A1:A100"),"Annual Leave"))

@kaushik03 Thanks for the simple solution. Its really amazing. Can you please explain how GET."workbookname" part works in your formula.

I learned that I was wrong on the part "..There is no menu command or option in Excel for that (You can insert current sheet name but not all sheet names in one sheet using few functions).." in this post. Just learnt today that same can be done by using functions as explained in this post by...

@kaushik03 The same add-in will work with Excel 2007 also but not with earlier versions of Excel.

Putting name of 52 tabs in a sheet will be cumbersome task. Follow this link to do it easily: http://chandoo.org/forums/topic/addin-to-insert-name-of-all-sheets-in-one-worksheet

it appears to me from the illustration given that you want to insert 3 rows after the text line 4. if it is as simple then you just need to select as much no. of existing rows after the text line 4 as much rows you want to insert and then press Ctrl and + together or right click and select...

The following code can help you in converting amount in words. I got it from somewhere i dont remember. to use it do the following: 1. Press Alt+ F11 2. Go to Insert > Module 3. Copy Paste the code in the window Option Explicit 'Main Function Function SpellNumber(ByVal MyNumber)...

I think it has to do with your system configuration. how Much RAM do u have installed in your system?

Just an extension of the solution provided by SirJB7. You can use following formula: Assume your date is in Cell D1 or you can replace the cell reference with any date. also the week starts from Sunday. =choose(weekday(D1,1),"Sun","Mon","Tue","Wed","Thu","Fri","Sat")

Once I was working on an Excel File which had more than 80 worksheets and I had to take print of all those sheets. Since the No. of sheets was very large there was possibility of missing one or two sheets while printing. So I looked for a way by which I can get names of all the sheets in a...

Thanks for the help Narayan. The program used to stop at "Solverreset" Then i looked into reference library and found the Problem. In reference library there was one reference to "Missing:Solver.xla". I unchecked that and then checked the "Solver" and the code worked. Thanks again for...

This is my Code Sub SolverMacro() ' ' SolverMacro Macro ' Macro recorded ****** by ********** ' ' Application.ScreenUpdating = False If Range("a18").Value = "Total Cost" Then SolverReset SolverOk SetCell:="$B$18", MaxMinVal:=2, ValueOf:="0", ByChange:="$B$2:$E$4" SolverAdd...

I am facing a difficulty in using solver from VBA. I created a code for solving some problem. While running the same it gave an error: Compile error: Can't Find project or Library. then I went to Tools>References>Solver and click on the box next to it and checked it. after...