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 Chriss Miller 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 ekrouse

  1. ekrouse

    Making Perfect Copies for Archiving Backup Files

    Thanks Steve. I actually plan on taking the onsite NAS home and copying it there. Any software you recommend as being better than windows explorer (drag & drop) for making more exact copies? -Eric
  2. ekrouse

    Making Perfect Copies for Archiving Backup Files

    I need ideas on reliable ways of copying monthly backups for archival purposes. Background: One of the "hats" I wear at work is to oversee IT. I utilize a local firm to do all the complex stuff that is beyond our capabilities. Based on their recommendation we use Symantec Backup Exec to backup...
  3. ekrouse

    Making Perfect Copies / Archiving Backup Files

    I need ideas on reliable ways of copying monthly backups for archival purposes. Background: One of the "hats" I wear at work is to oversee IT. I utilize a local firm to do all the complex stuff that is beyond our capabilities. Based on their recommendation we use Symantec Backup Exec to...
  4. ekrouse

    Recording a maximum value in Excel

    THANKS COMBO! Your solution works great! I used the... If L.ID = "" Then L.ID = 10000000. If the number every approaches that level I'll raise the initialization number. -ekrouse
  5. ekrouse

    Recording a maximum value in Excel

    Now I need a Minimum Value Formula, but have run into a snag. First off... the formula for Maximum Value worked great since the variable is set to zero each time the spreadsheet is opened. I call it HighWaterMark and it is written: Function HighWaterMark(CurrentValue) Dim h As Range ' Set h...
  6. ekrouse

    Recording a maximum value in Excel

    Combo, OK, I think I figured part of it out. Please correct me if I'm wrong. Maxx(v)is a function called "Maxx" with the cell reference "(v)". That is how it knows what cells to reference. I assume a more complex formula which references two cells would be written somthing like "function...
  7. ekrouse

    Recording a maximum value in Excel

    Thanks Combo, I think I like this VBA approach better although I will have to read up some on writing custom functions. What part of the code you provided allows for "relative cell reference" rather than hard coded. I assume "r.ID" is the referenced cell address like "B3". How does it remain...
  8. ekrouse

    Recording a maximum value in Excel

    Thanks kbklaus, but using Lotus 1-2-3 is not an option since the spreadsheet has realtime links to stock market data through Reuters. That is not supported with Lotus 123.
  9. ekrouse

    Recording a maximum value in Excel

    Does anyone have another solution than user "combo's" solution? I am using the circular reference approach which works more or less, but does weird things requiring me to switch the "iterations" function (Tools>options>calculations) on and off from time to time. It also doesn't keep the values...
  10. ekrouse

    Recording a maximum value in Excel

    Thanks Combo. Your Solution Works GREAT! (and simple too. My favorite kind of solution). -ekrouse
  11. ekrouse

    Recording a maximum value in Excel

    I am trying to record a maximum cell value in an MS Excel which is continually dynamically updated. Note: This is not a request about using the "Max" or Maxa" functions. My spreadsheet automatically updates with stock market data several times a second. I have a cell which calculates the...
  12. ekrouse

    Outlook Forms

    OK, this is a little complicated: Goal: I want to email an invitation to a large number of people outside my firm. I want them to click on the supplied link and have a form pop up with 3 fields: Name, phone # and other comments. In addition, I want the "To:" field completed with my email...
  13. ekrouse

    Excel 2003 "Search" Function

    Thanks Gavin. That's rather creative thinking. The "instance" part of the substitute formula is what I was hoping to find in a "search" function, but your approach solves the issue with just one extra step. Thanks, -Eric
  14. ekrouse

    Outlook 2003 Tasks - Saving "Custom Views"

    Thanks cmeagan656. Unfortunately that doesn't fix the problem. The issue is that if I define a view as you describe and later change ANYTHING, that change sticks as if it was autosaved or something. For example, my "defined view" is named "Eric's View" and has my tasks grouped by category...
  15. ekrouse

    Excel 2003 "Search" Function

    I frequently use the "Search" function when extracting text from a cell as part of the "Left", "right" or "Mid" functions. 1) Does anyone know of a way to find the 2nd, 3rd, 4th or 5th occurance of text withing a cell like Lotus 1-2-3 used to allow? 2) Does anyone know of a relatively clean...
See more

Part and Inventory Search

Back
Top