Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by tmcrae

  1. tmcrae

    Excel 2003: Can a cell's value be automatically edited/updated?

    No worries! I wasn't insulted at all...just thought that I had made a mistake somewhere during the registration process! Cheers!
  2. tmcrae

    Excel 2003: Can a cell's value be automatically edited/updated?

    Gal?!?! Oops...I must have checked the wrong box somewhere on the "Personal Information" form! I took a shower this morning, and everything was where it should be so as near as I can tell, I'm still a guy. And yes, the snow is all gone here! Thanks again, Skip.
  3. tmcrae

    Excel 2003: Can a cell's value be automatically edited/updated?

    I actually got everything working yesterday afternoon. The VBA Forum you pointed me to lead me to the dicovery of the Worksheet_Change function. From there, it was just a few Google searches to find some examples, then copying and changing one to meet my needs. Thanks, Skip.
  4. tmcrae

    Excel 2003: Can a cell's value be automatically edited/updated?

    Thanks, Skip. I will.
  5. tmcrae

    Excel 2003: Can a cell's value be automatically edited/updated?

    Thanks everyone for the feedback. It sounds as though a macro may be my best (or only) solution. Can a macro be automatically triggered to run once a value has been entered into a field?
  6. tmcrae

    Excel 2003: Can a cell's value be automatically edited/updated?

    In my original post, I had said that A1 could be any number from 1 to 10. But, if it were a 1, 2 or 3, then it would have to be edited against a value in B1. And, based on B1, the value in A1 would automatically be changed to a 1, 2 or 3. If, on the other hand, A1 were keyed with anything...
  7. tmcrae

    Excel 2003: Can a cell's value be automatically edited/updated?

    Hi Skip, Well, actually I have employed Data/Validation before and it works quite well. But, in this instance, I want to be able to automatically change (not just validate) the value in a cell based on some logic automatically. Right now, if I key an invalid number in A1, I get an error box...
  8. tmcrae

    Excel 2003: Can a cell's value be automatically edited/updated?

    Oops...the title should read Excel 2007. Sorry about that.
  9. tmcrae

    Excel 2003: Can a cell's value be automatically edited/updated?

    I have a spreadsheet where I would like to incorporate some automatic editing logic. For example, let's say in cell A1 I can key a number from 1 to 10. If, however, I key a 1, 2 or 3 in A1, I want to edit that value against whatever is in B1 (which can be "A", "B" or "C"). If B1 = "A", then...
  10. tmcrae

    Excel - Protect formulas in hidden columns

    Thanks, your solution works perfectly. I was really looking for a way to mark or protect the actual columns with the formulas in them from being deleted, but this will work very well in the meantime. As a follow up, is there a way to set "Visible Columns Only" as a default on a spreadsheet, or...
  11. tmcrae

    Excel - Protect formulas in hidden columns

    I have a spreadsheet with hidden columns that contain formulas. In the unhidden columns are data that I want to clear. But when I select the entire block and press "DELETE", it also clears the formulas in the hidden columns. What is the best way to prevent this from happening (other than...
  12. tmcrae

    Is it possible to set a rule to automatically turn on/off?

    We are running Microsoft Outlook 2003 in our office. Currently, if I want to set a rule for when I will be out of the office, I must manually do so (providing, of course, that I remember to set it before I leave the office). I was wondering if it would be possible to configure it so that this...
  13. tmcrae

    EXCEL - Why is there a limit on the number of cells I can SUM?

    Nevermind. I found the problem. The sum was being performed on a column of cells that had values set to either 0 or 1 based on the value of the cell in the corresponding row of another column. Somehow, instead of a value in this other column, however, one of the cells contained a circular...
  14. tmcrae

    EXCEL - Why is there a limit on the number of cells I can SUM?

    I am trying to sum up a column of numbers (each of which is either 0 or 1) that is 7,402 cells in length. When I use the SUM function, I get a result of zero. In fact, I get a result of zero as long as the number of cells I am summing is bigger than 2,799. Once the number of cells in the...
  15. tmcrae

    Can anyone recommend a good reference book?

    Thanks Eldon. I'll check it out.
See more

Part and Inventory Search

Back
Top