General

Need help for getting output
have information from different people and want to consolidate it in one single sheet using pivot tabel (without using macro) sample- Data - 1 Name Date Org Status Tiff # Anita 14-Apr-10 it processed 123 Anita 14-Apr-10 it pending 126 Anita 15-Apr-10 datex pending 128 Data 2 Name Date Org Status... 15 Apr 2010 05:54

Keeping Workbook Name Out of Sheet When Copying to Different Book
I run a hockey draft that requires me to copy worksheets into a master sheet but I need to know how to copy them without the formulas referencing the workbook that they came from as the formula will only work if it stays general. i.e. =IF('MasterI12'=1,"Correct", "") rather than =IF('CopyofSheet4MasterI12'=1,"C... 14 Apr 2010 08:47

Hyperlink mapping
Is there a way to show the mapping of hyperlinks on a worksheet? -- mamalhe ... 14 Apr 2010 01:09

Excel Sudoku
Hello! I know this sounds crazy. But does anyone know how to create a sudoku game using excel 2003 that has a timing function to it. Meaning, I am able to keep track on how fast i finished the sudoku by clciking on the submit button. -- help me ... 14 Apr 2010 00:03

Cell Styles on Ribbon
The context window that should "pop-up/out" when I click on Cell Styles on the Home tab is "locked" on to my ribbon. Normal, Bad, Good, etc. is on one line and Check Cell, Explanatory, Input, etc is on the second row. I looks like something that you would do if you wanted to modify a ribbon. ... 14 Apr 2010 03:20

How do I Fill down on Excel
... 14 Apr 2010 00:03

How do I merge 2 worksheets into one consolidated worksheet?
I have 2 branch office budgets that I would like to merge into one consolidated master budget. I would like the branch budgets linked to the master budget so as we adjust the branch budget, the master budget adjusts as well. ANy help would be appreciated (BTW...I am not really excel savy, so technical direction... 14 Apr 2010 08:47

Insert a picture into an excel cell & have it stay there
I have tried the "move and size with cells" option; however, the picture stays the same. It moves with the cell but it won't resize with the cell. "Gord Dibben" wrote: You cannot place objects in a cell, only on top of them. Have you tried formatting the object to "move and size with cells" or any ot... 13 Apr 2010 19:37

Formula to return a formula
At least I think that's what I'm looking for. here's my situation: I've got a sheet where there is a variable (X) that changes depending on what row it is on. So I have a column (column c) that lists these variables (X is dependant on things from a different sheet). X is a muliplier that is utilized differentl... 13 Apr 2010 21:50

How to stop Excel from automatically truncating leading zeros
Is there a setting in Excel 2007 to keep it from automatically trunkating leading zeros like when pasting in zip codes or department codes. When Excel sees what it thinks is a number, it treats it like a number and drops leading zeros. Is there a setting in Options or somewhere to tell excel to leave the leadin... 13 Apr 2010 18:30