672 reputation
1513
bio website
location Seattle, WA
age 32
visits member for 5 years, 2 months
seen Nov 12 at 21:56

Jul
17
awarded  Popular Question
Mar
3
awarded  Notable Question
Feb
10
awarded  Citizen Patrol
Oct
14
answered Stock management tool or excel spreadsheet for managing stock
Oct
8
awarded  Yearling
Sep
30
awarded  Student
Sep
22
awarded  Popular Question
May
6
answered Excel VBA (2007) Subtotal method of Range class failed
May
6
answered Excel Data Organization: Array Formulas? Tables? Named Range?
May
4
revised Automatically sending mails from office
responding to OP comment; added 495 characters in body
Apr
30
answered Automatically sending mails from office
Apr
22
comment How to protect Excel cell contents
This won't do anything different from what normal sheet protection already does. It does add unnecessary complexity and size to the file itself. Best just to make the cells protected (in the format cells > protection dialog) then password protect the sheet and workbook. It's not perfect, but it will help.
Apr
22
awarded  Critic
Apr
22
comment Excel cell references not updating when referenced cells are sorted
What is the criteria for matching the parent price in table 2 to table 1? Seems like a formula that would look for a match and use that to reference would be more stable. Can you post the details on what thought process is used to match the parent price in table 2?
Apr
22
comment Opening Excel 2007 to a specific worksheet from a file:// link
@quack quixote: good point. Didn't notice that.
Apr
21
comment Opening Excel 2007 to a specific worksheet from a file:// link
@Ben: you've omitted the path and link information, but I think that might be helpful in solving the issue. Can you provide (at least obfuscated) the path and link?
Apr
21
comment Opening Excel 2007 to a specific worksheet from a file:// link
@Mepher: SU exists so that questions can be asked. If you don't know the answer, then don't post. -1 if I could.
Apr
12
comment How to tell if Microsoft Works is 32 or 64 bit? Please Help!
Bill, if that answers your question, go ahead and accept as the answer by clicking on the outlined checkmark.
Apr
7
answered Excel: Summing values within a certain date range (> start date and < Finish date)
Mar
22
comment Return cell reference as result of if statement with vlookups
can you post some sample data. I.e. two rows (and headers) from each table, what you are searching for, and the expected result?