Duplication How do I duplicate a worksheet and contents 20 times in a workbook? ... 5 May 2010 13:48 Pivot Table Help - Gross Margin % & % of Sales Hello, I have a challenging pivot table issue that I hope I can get some help on. Here is the spreadsheet I'm working with: https://www.yousendit.com/download/OHo0N3RSSU90d0UwTVE9PQ I'm having problems with showing percentages in my pivot table such as gross margin and operational profit. Here is the P&L p... 6 May 2010 18:45 I want a footnote number (small number) at end of sentence? I want to put a footnote (small number raised higher than rest of sentence) at the end of my notation on a report. How do I find this "symbol"? ... 5 May 2010 12:40 Referencing a cell in other worksheet that is using autofit row he HELP! Greetings from Bermuda! I have referenced a cell in another worksheet that is using autofit row height. I want the cell that I am pulling the data into to automatically autofit row height also. Even though I have both cells in the two different worksheets designated to autofit, the cell that I am pull... 5 May 2010 16:03 How do I write a formula in excel where 1 = .05 and 2 = .75 etc. How do I write a formula in excel where 1 = .05 and 2 = .75 and 3 = 1.23? So, if the number entered in the cell is 1 then .05 is muliplied by another cell. ... 5 May 2010 12:40 insert blank row and formulas when I insert a new row in my worksheet, I noticed it does not update the formulas for any row below that line that reference another sheet in my spreadsheet. For example, if my formula references 'sheet2'!I14 and I insert a row above that formula it does not change the formula to 'sheet2'!I15. Is there a way... 5 May 2010 13:48 sum 2 values in diffnt cells with dup values, and sum if not dup ... 5 May 2010 13:48 Copying info from worksheet to worksheet if info matches Hi there, would be grateful for any help. I have a very large workbook with many linked sheets. I would like to copy info from worksheet to worksheet if the information matches: sheet1 (new clients), column A (company name), column J (sector) Sheet2 (baseline info), column A (company name), column L (sector) ... 6 May 2010 05:17 Counting for frequency How can I count the frequency a piece of data occurs in an array? I am trying to determine if a a set of data repeats itself and how many times it repeats itself. I am aware of the "FREQUENCY" funtion, think that perhaps I can combine it with SUMIF or COUNT IF but I am not getting any viable results yet. I h... 5 May 2010 11:33 right syntax hello all ! can anybody show me the right syntax for this.. ='[ABC.xlsm]Sheet1'! & D14 & 100 ...so it could be for example... the cell L100 or BR100.. it depends to the value in D14 tx for help! ... 6 May 2010 00:56