Formula for counting frequency then sorting Hi guys, Need some help with this one. My worksheet looks a little like this; Col F Col X Barcode Round Number 14 1234123412341234 12341 15 8687686876868686 86876 16 7543275432754327 75432 17 24824... 7 Apr 2010 12:23 Using Worksheet Name I am having multiple worksheets in an Excel file and now I want to use the name of each worksheet in a new worksheet in the same file. Is there a formula which can copy the name of worksheet into a Cell of another worksheet ... 7 Apr 2010 10:07 Disabling "cut" function - version 2003/2007 Hi there wlam, Paste this code in the "ThisWorkbook" VBA code module of the workbook you want to protect. Code is below. ----------------------- Const DisableCutOperations As Boolean = True Private Sub Workbook_WindowActivate(ByVal Wn As Excel.Window) If DisableCutOperations = False Then Exit Sub ... 7 Apr 2010 06:47 How to convert 115:14 into hours? ( 115 stands for hrs, 14 is Chinared, Please use this formula to get a more accurate answer to indicate the hours and minutes. However, if you want to display the :14 as seconds then you should use a "." instead of a ":" in your question. =INT(A1/60)&":" &MOD(A1,60) -- Thank you and Regards Garreth Lombard "Fred Smith" wrot... 7 Apr 2010 04:37 Need to copy and match data from one workbook to another workbook I have one workbook that has book information such as book code, title and author. I have another workbook that has the ISBN Number and the amount of revenue that it has made I need to look up the revenue by ISBN number on the one sheet copy and paste it to a different sheet that has the rest of the book infor... 6 Apr 2010 18:45 Inserting a calculated field in a Pivot Table in Excel 2003 In the past I know I have done this but I can't see the option now to insert a calculated field. Does someone know where this is located? Thanks so much. ... 6 Apr 2010 18:45 H and V lookup or match? If I have the following data A B C D E NY MO IL NJ KS 1 Jim x x x 2 Joe x x x x 3 Amy x ... 6 Apr 2010 19:53 my paste special function won't let me copy formulas I am using Excel 2007 and I can't seem to copy and paste formulas from one workbook to another. Instead I get a dialogue box asking me if I want to use paste or paste link and to chose from a list of formats. Does anyone know if there is something that I can change in Excel to fix this problem? ... 6 Apr 2010 19:53 Leading zero's trail Number We use Excel for our memebrship data, on our zip code entires for NJ and Y which have a leading zero we get a blank. On last number in CC entry we only are able to display, 0, 1, or 2 -- How do we over come these issue? C-Ya GC ... 7 Apr 2010 01:22 Sumif across a table I am looking for a function that works using a =sumif function to add things that are not in a range that are next to each other as seen below the letters in () are the columns that the values are in... so I am looking for a sum in column A "X" of the total work out time if the appl column is "Y" total wor... 6 Apr 2010 22:05