excel 03

Hi Everyone, I have a shared sign up sheet in excel that I want to limit the amount of entries allowed. For example, I only want to allow 20 people to sign up under a certain category (column). Can I somehow hide/delete the cells or rows that I don't want to allow? Thanks in advance, Omar

Hi, I have 85 workbooks in the same folder with a sheet in each workbook called "Budgets". Its the same template in each workbook with different data. I need to create a Summary master file of all my budgets so in the end I will have 1 Workbook with the 85 copies of the "Budgets" Worksheets...

Does anyone know how I can format a cell to always add zeros to IP addresses? ex. change 69.21.13.222 to 069.021.013.222 The cells data is being populated from other spreadsheets using a VLOOKUP. I just need the leading zeros. Thanks

Howdy, How do I use the drill down function? I've seen it work by just double clicking the cell, however when I double click a cell in column B, it returns the same worksheet as when I double click the cell in column A or C etc.

please help I have created using VB a simple form, that should put data from the form into the worksheet as a qty. The data is copying across to the worksheet correctly, but is storing the data as text, then i cant find a way of converting this to a number, is there something im missing...

The title isn't very descriptive. Let me explain: I have a tab in a workbook that is a list of comments that occur, a timeline so to speak. I then have a very large spreadsheet which breaks out individual items into some mathematical detail, and then gives a summary on the right (a comment box...

I created .NET DLL (COM interface). This assembly has a few classes and used for data retrieval. It worked fine before I created a class that has an array of other classes among other properties (class genCrvPoint has a few simple properties like date as-of, price, etc.): ComVisible(True)>...

I have a 2 tier, Excel front end / Access back end, database set up that I inherited when I accepted my current position and I’m having a problem with it that I haven’t seen before. The set up is:<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p> <o:p> </o:p>...