Search:

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

Page 1 of 14 1 2 3 4

Search: Search took 0.01 seconds.

  1. Thanks Zeddy! That was the fix I needed.

    Thanks Zeddy! That was the fix I needed.
  2. Copy a Wks Print Settings to Multiple Wks

    I would like to copy page and print setting from one worksheet to all other worksheets in my workbook. I can get most of the settings copied by by making the source the active sheet and then...
  3. Replies
    8
    Views
    404

    Maudibe & Paul, I tried something like that long...

    Maudibe & Paul,
    I tried something like that long ago, perhaps it was in Lotus. I used a sequence of dashes and pipes and parsed out the data that way. Looked like this:...
  4. Replies
    8
    Views
    404

    Thanks Rory. I got busy with other tasks so I...

    Thanks Rory. I got busy with other tasks so I didn't get to try your solution until just now. It appears to be shifted one character but I'm sure that my bad. Anyway, fixing it will help me better...
  5. Replies
    8
    Views
    404

    VBA for Text-to-Columns

    I run a report from a legacy system that only displays results to a txt file. I can copy-paste the results into one column of an Excel spreadsheet and then run the Text-to-Columns feature to parse...
  6. 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.
  7. 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...
  8. Replies
    11
    Views
    1,169

    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.
  9. Replies
    11
    Views
    1,169

    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...
  10. Replies
    11
    Views
    1,169

    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...
  11. Replies
    2
    Views
    626

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

    Thanks Zeddy. I was overthinking the problem. Again.
  12. Replies
    2
    Views
    626

    [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...
  13. [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...
  14. [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.
  15. [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...
  16. 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...
  17. Replies
    6
    Views
    828

    [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...
  18. Replies
    6
    Views
    828

    [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...
  19. 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...
  20. Replies
    5
    Views
    5,599

    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...
  21. Replies
    5
    Views
    5,599

    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
    ...
  22. Replies
    1
    Views
    343

    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...
  23. Replies
    2
    Views
    548

    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.
  24. Replies
    6
    Views
    1,552

    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...
  25. Replies
    7
    Views
    21,345

    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...
Results 1 to 25 of 334
Page 1 of 14 1 2 3 4