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
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...
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...
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
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...
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...
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...
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.
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...
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...
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...
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
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...
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...
Is there anyway to save a "View" in Outlook tasks so that it I can retrieve that view, with all it's settings?
I've created a custom View in Outlook Tasks which groups by category and sorts by date in ascending order. Unfortunately, if I change anything by accidently sorting a column by...
Depending on the application, your formula works just fine. However, if Alan's spreadsheet contains text data in column "b" (i.e. b1 = "cat", "dog", "username", etc) your formula would return an error.
Whenever I synchronize my Palm pilot with Outlook 2003 I get a popup box that requires I authorize it to synch emails. Is there a way to override / disable this so that it automatically synchs the emails?
I have never been able to figure out how to save an image from a MS Word document. I've tried copying and pasting into other programs like Photoshop, but this is a lot of work and often degrades the image. All I want to do is save a .jpg as a .jpg or a .bmp as a .bmp, etc. right from the Word...
Put the following formula in cell c1 and copy down to additional rows. Please note, per your request this only works with a numeric value in b1 or a1&b1. If a value exists in a1 only, c1 will remain blank.
=IF(AND(CELL("type",B1)="v",CELL("type",A1)="v"),B1-A1,IF(CELL("type",B1)="v",B1,""))
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.