Search:

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

Page 1 of 14 1 2 3 4

Search: Search took 0.02 seconds.

  1. Wow! Lots of choices. I'll use these ideas as a...

    Wow! Lots of choices. I'll use these ideas as a starting point. Thanks to all for you replies.
  2. Macrium or Acronis . . Pre-Win 10 Backup Plan

    I would like to backup my Win 8.1 pc before MS auto-loads Win 10. I like the idea of one complete backup, a copy so complete (at least for OS and Apps) that in the event of a hard disk failure I...
  3. Replies
    11
    Views
    512

    Thank JWoods. I'm going over there Monday. I'll...

    Thank JWoods. I'm going over there Monday. I'll run the steps of your post then.
  4. Replies
    11
    Views
    512

    JWoods & Browni - What do your references to "the...

    JWoods & Browni - What do your references to "the pc is running Vista" mean to me? I don't know if there is an original Vista disk (but probably not). Does this invalidate JWoods suggested three...
  5. Replies
    11
    Views
    512

    Create a USB rescue drive

    A friend's pc has a troublesome app that does not allow it to be uninstalled. In fact, the app doesn't seem to allow itself to be stopped or closed. The pc is running Win Vista and apparently a...
  6. Replies
    2
    Views
    259

    [SOLVED] Thanks Zeddy. I was overthinking the problem. ...

    Thanks Zeddy. I was overthinking the problem. Again.
  7. Replies
    2
    Views
    259

    [SOLVED] Same Day of Week Last Year

    I need to compare daily results of operation on a day-of-week basis so that I'm comparing Sunday to Sunday instead of Mar 22, 2015 vs. Mar 23, 2014. The obvious solution is to enter this year's date...
  8. [SOLVED] Here's my follow-up: I went back to my source...

    Here's my follow-up:
    I went back to my source data, a Crystal query that addresses one of our businesses's primary databases. In the query I added two fields (both calculations) so that I wouldn't...
  9. [SOLVED] Got it. I've done that before. I was just...

    Got it. I've done that before. I was just hoping that I had been missing a function/formula shortcut. Thanks Rory.
  10. [SOLVED] Insert Time Calculation into Pivot Table and Cell Format for Time Incl Days (XL07)

    I would like to insert a calculation in a pivot table that divides the results of one field by the count of another field. In the attached workbook I have added this formula Avg Dur/ Trans2...
  11. Creating standalone slideshow in PowerPoint

    I'd like to Create a Standalone Slideshow in MS Powerpoint. Searches on the web either don't explain the types or the file-types from the various versions have me confused.

    The slideshow I...
  12. Replies
    6
    Views
    436

    [SOLVED] Excel alerted me to the extra space in the...

    Excel alerted me to the extra space in the formula so I knew right away how to fix it. Thanks to you Maudibe for the all-in-one solution.

    RG Thanks for explaing about the testing around the...
  13. Replies
    6
    Views
    436

    [SOLVED] Sum of N Largest Numbers in a List

    I would like to sum the largest 15 numbers in a list selected by using LARGE and criteria for a date range.

    I have attached a wks with sample data and some very simple formulas which work. I...
  14. Auto-execute VBA code on workbook open

    I found this sample code but it doesn't want to run when I open the file I added it to. I tried to exit Excel and then reopen the file, but still no luck.

    Private Sub Workbook_Open()
    MsgBox...
  15. Replies
    5
    Views
    1,458

    Thanks for the solutions. I tried all of them. ...

    Thanks for the solutions. I tried all of them. In the end I'll use Maudibe's solution for expediency, but I want to try to use RetiredGeek's and Rory's in in the future. Maybe something to loop...
  16. Replies
    5
    Views
    1,458

    Stop VBA when user selects Cancel

    What code can I use to stop VBA from processing when the user selects the Cancel button option in the InputBox?

    Sub RefreshPT()
    '
    ' RefreshPT Macro
    '
    Sheets("Control").Activate
    ...
  17. Replies
    1
    Views
    280

    Macro to create a pivot table

    I have recorded a macro to create a pivot table from data exported from one of our applications. The macro would select the Report Filter, Row Labels and Values. I carefully stepped through my...
  18. Replies
    2
    Views
    403

    How much processing power do I need?

    How much processing power do I need to complete the attached spreadsheet quickly?

    I posted this question in the Excel Forum about a pc's requirements for completing a large Excel spreadsheet.
  19. Replies
    6
    Views
    881

    How much processing power do I need?

    How much processing power do I need to complete the attached spreadsheet quickly?

    There's a workbook attached with 826k+ rows of customer account numbers in column B. In column A I'd like a...
  20. Replies
    7
    Views
    10,644

    That's It! Perfect. Thanks Mr. Geek. I...

    That's It! Perfect. Thanks Mr. Geek.

    I modified the Filename so that this code can be inserted into any workbook. All a user needs to do (I think) is to change the Sheets Array at the...
  21. Replies
    7
    Views
    10,644

    A selection of sheets. Originally, I posted ...

    A selection of sheets. Originally, I posted

    Sheets(Array("Sum Regular Hours", "Sum Regular Dollars", "Sum OT Hours", "Sum OT Dollars")).Select

    but have modified the sheet names to exclude the...
  22. Replies
    7
    Views
    10,644

    No. That didn't help. The PDF ignores the...

    No. That didn't help. The PDF ignores the preselected print ranges and appears to use only A1:A5.
  23. Replies
    7
    Views
    10,644

    Excel VBA to Save As a PDF

    This macro works for saving & printing the current sheet as a PDF. How can I modify it to save & print a selection?

    Sub Save_to_PDF2()

    ChDir "G:\Payroll_Report\OT&TimeApprovalReport"


    Dim...
  24. That'd be one more reason for me to upgrade...

    That'd be one more reason for me to upgrade Jeremy. I'm on XL 2007 SP3.

    I'll find out soon enough. I just bought a new pc for home use last week and will add MS Office 2013.

    What I'm trying...
  25. Pivot Table - Reveal the Summarized Field Titles

    38856Is there a way to get Pivot Table to display the row labels for the fields it is summarizing?

    Each record in my data begins with four fields: Div #, Div Name, Dept #, and Dept Name.
    ...
Results 1 to 25 of 329
Page 1 of 14 1 2 3 4