Search:

Type: Posts; User: webmistress; Keyword(s):

Page 1 of 2 1 2

Search: Search took 0.01 seconds.

  1. Thank you VERY much Steve, that has done the...

    Thank you VERY much Steve, that has done the trick.
    Really appreciate your time and have a great day!
    :rolleyes: :cool:

    Linda
  2. SUM cells across columns where letters represents values in lookup table

    Hi all,
    I have a leave planner with all staff names down columns, then across each row is a letter representing the type of leave each staff member has taken/scheduled throughout the current 6...
  3. Vlookup of negative numbers - keep getting N/A# error

    Hi all,

    Am doing a vlookup where the lookup_value is a negative number. My table_array has some negatives in columns in sequence through to some positive values.

    I have sorted column one...
  4. Excel - Solver to obtain compounding interest and future value?

    Hi all,

    Have attached a file with starting investment of $1000. Aim is to achieve $1,100 by end of 12 months, but the interest rate is unknown.

    You will see i have used a simple formula in...
  5. Replies
    2
    Views
    4,673

    Word 2010 Restrict Formatting

    I cannot make sense of this feature. The instructions are clear as to how it should work in theory, but I cannot get the feature to behave logically.

    I have a document with headings and...
  6. Many thanks Rory, I REALLY appreciate your prompt...

    Many thanks Rory, I REALLY appreciate your prompt response, I obviously didn't follow the instructions acurately! All the best.
  7. Data Validation - CUSTOM v2007 RESTRICT EXCEEDING A TOTAL

    Hi all,

    Have attached sample file to show my problem. I have set a custom Data Validation rule on cells f2:f20 which should restrict the total of all entries in that range to <=1,000,000. For...
  8. Replies
    3
    Views
    4,538

    Endnotes Word 2007 - Need to type AFTER

    Good morning all,
    I realise endnotes mean AT THE END!! but i want to enter more date (signature, comments, anything) after the endnotes - without it being referenced in the Endnote Text.

    I know...
  9. Word 2007 - TOC 1, 2, 3, etc page numbering style

    Hello all,
    I have inserted a table of contents in my document using Word Heading styles, and all is well.

    My question is that the page numbering style on the right of the TOC is in Arabic for...
  10. Replies
    4
    Views
    9,506

    Hi there and sorry to butt in, but this topic is...

    Hi there and sorry to butt in, but this topic is of interest and I was going to follow through to your link Paul, but it only returns an error/invalid link message. I'm keen to see your page re the...
  11. Replies
    2
    Views
    590

    Thanks for taking the time to reply Steve. I had...

    Thanks for taking the time to reply Steve. I had found the same thing so now I know that what you have suggested is probably the best way to avoid the problem.
    Cheers.
  12. Replies
    2
    Views
    590

    Excel 2007 - chart data

    Hi All

    Selected data on Sheet 1 includes heading in cell A1 for whole sheet (see file attached). When I select range for chart (A1:D5), it includes the A1 cell heading as a Category in the...
  13. Replies
    1
    Views
    413

    Can someone please tell me what the "Merge...

    Can someone please tell me what the "Merge Labels" tick box does when selected in Excel, Pivot Table, Table Options dialogue box.
    From what I can see, all it is doing is centring headings in Row...
  14. I was working on a site yesterday, where one of...

    I was working on a site yesterday, where one of the pc's would not show the screen tip with the pixel measurement, when I dragged the column width.

    5 other PC's in that room - all on Windows XP...
  15. Replies
    3
    Views
    968

    Hi WendellB, Many thanks for your suggestion and...

    Hi WendellB,
    Many thanks for your suggestion and I have used your code with some success. Unfortunately, if the result is "0" or in otherwords does not equal "1", there is still a blank paragraph...
  16. Replies
    3
    Views
    968

    Hi all, Mail Merge Data Source Have an...

    Hi all,

    Mail Merge Data Source
    Have an excel file with headings in Row 1.
    All records in following rows contain simply 0's and 1's imported from .csv files (resulting from "save data only...
  17. Replies
    2
    Views
    2,473

    Have created a "form" in Word 2007 using Legacy...

    Have created a "form" in Word 2007 using Legacy Forms tools (ie. Text formfield, Checkbox formfield)

    The form works fine with protection on, and can be completed by users and emailed back to me.
    ...
  18. Replies
    3
    Views
    4,296

    Thank you for getting back to me Joe. At least I...

    Thank you for getting back to me Joe. At least I can give up searching for an answer.

    CHeers. http://windowssecrets.com/forums/images/smilies/rolleyes.gif



    Unfortunately, I can only...
  19. Replies
    3
    Views
    4,296

    Hi All, I have researched the web pretty...

    Hi All,

    I have researched the web pretty thoroughly and it seems the 18 hour default reminder setting for "all day events" cannot be changed.

    THis is for Outlook 2007 both on stand alone...
  20. Replies
    2
    Views
    687

    That worked very well, Thank you for your...

    That worked very well,

    Thank you for your prompt response. Have a great day. http://windowssecrets.com/forums/images/smilies/cheers.gif


    I think you'll have to provide a macro to insert a...
  21. Replies
    2
    Views
    687

    Hi All In my sheet I have unlocked cells for...

    Hi All

    In my sheet I have unlocked cells for data entry, and protected sheet with the exception of users being able to "insert rows".

    However, if insert row in between existing rows, i can only...
  22. Replies
    2
    Views
    388

    When you protect a worksheet, you can specify...

    When you protect a worksheet, you can specify what the user is allowed to do. Sorting is among them. You have to scroll down the list to see the Sort check box.
    The user will only be able to sort...
  23. Replies
    2
    Views
    388

    Hi all, Need to have protection applied to a...

    Hi all,

    Need to have protection applied to a sheet to prevent other users overriding formulas etc. Seems once protection is applied, users then cannot sort the rows.

    For example, say users...
  24. Attached is spreadsheet where in I2 needs to...

    Attached is spreadsheet where in I2 needs to look at EITHER D2 or E2 and if there is a date in either, add 182 to that date. (Note, a date will not be entered into both). If there both D2 & E2 are...
  25. Replies
    28
    Views
    1,571

    Re: Format new pc (Windows Vista)

    Thank you all, it worked using the Windows XP disk to boot up. All good now .... NO MORE VISTA !!!
    Cheers,
    Webmistress
Results 1 to 25 of 39
Page 1 of 2 1 2