Summary: I need to know if there is a way to do data checking on a cell as it is entered. What I need is for the cell to automatically change itself to a nega...
Summary: I was wondering if it was possible to change a cells value depending on the date set on your computer. If not is there any other software that you kno...
Summary: Hi I have a question regarding highlighting Excel cells. I am designing a quiz whereby I have set the conditional formatting to reveal the contents of...
Summary: No. But you can create lists that it can remember. Tools, Options, Custom Lists. For example: It has a couple already such as Mon, Tue, Wed, Thu... or...
Summary: Hello Everyone, I'm trying to copy formulas based on cells being filled in. For example, I will be entering information on column A (product no) then ...
Summary: By default, when you protect a worksheet, all the cells on the worksheet are locked. You can however, lock only specific cells and ranges. Enter "Unl...
Summary: I have been looking around for an Excel VB Macro or formula that will enter the date into a cell when any cells on the ROW have been modified. I am ru...
Summary: What you are asking for is a perfect example of a Circular Reference, which is not allowed in Excel. To state your question another way, what you esse...
Summary: Hi, I am giving myself a headache in working out, what I believe is a simple formula in excel. What I am trying to achieve is to look at two cells on ...
Summary: To keep the text within a given cell: On the menu bar: Format>Cells>Alignment Tab>put a check mark in "Wrap Text" box. This will wrap the text withi...
Summary: User has an excel spreadsheet created in Excel 2000. The spreadsheet is fairly simple, a listing of meetings with several filters inserted. The user t...
Summary: Yes. Select a cell, right-click and choose "Format Cells...". Select the Protection tab. Make sure "Locked" is checked. Click Ok. From the main menu, ...
Summary: i am trying to set the sheet name eg Sheet1 to correspond to a given cell on the spreadsheet in excel. instead of Sheet1 i want it to have the date w...
Summary: I am trying to create an Excel template that references two different workbooks. A new workbook must be created every week and must refer to the prev...
Summary: Bryan, I hope you will come back to this post because I realy need it! I'm sorry. It's very difficult to talk excell on message board wich don't allow...
Summary: I'm sure this can be done with some VBA code, but we're gonna need some more specifics. If I were going to write the code to do this, I would start by...
Summary: I guess that depends on your definition of "normal". This would only be "normal" behavior if your Calculation option was set to manual, which I'll wag...
Summary: I'm confused, but we'll get to that later. First, about your code: As far as I can tell, your code is supposed to prevent users from editing any cell ...
Summary: I used VLOOKUP but it is not always linking the correct value. It will give me a value but it is not matched correctly to the part number. If i put ...
Summary: Hi, I suggest that you use a proper form and not a control on the worksheet. It takes a little longer to setup but the effect is so much better. It is...
Summary: Everything was based on a 2 test files, the original files will explain this better. In one excel document called (reservations) I have a list of rese...
Summary: Hi, Handling merged cells is not easy, and AFAIK, none of Excel's functions specifically handles merged cells. I think that the first cell in a merged...
Summary: Hi, Are all the workbooks identical in structure, number of worksheets, worksheet names and the addresses of cells to be formatted? How do you specify...
Summary: Hi, Re: unnecessary decimals on the distance measures Format the cells as numbers - and on the same Tab there is a box with scroll buttons, to select ...
Summary: Place an equal symbol (=)in the cell where you want the data to appear and then click in the cell on the other sheet that has the data you are wanting...
![[higher confidence]](http://static.computing.net/img/AT-red_x.gif)
- higher confidence, ![[lower confidence]](http://static.computing.net/img/AT-black_x.gif)
- lower confidence
