Search:

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

Page 1 of 13 1 2 3 4

Search: Search took 0.02 seconds.

  1. Replies
    2
    Views
    111

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

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

    [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...
  3. [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...
  4. [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.
  5. [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...
  6. 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...
  7. Replies
    6
    Views
    296

    [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...
  8. Replies
    6
    Views
    296

    [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...
  9. 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...
  10. Replies
    5
    Views
    656

    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...
  11. Replies
    5
    Views
    656

    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
    ...
  12. Replies
    1
    Views
    223

    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...
  13. Replies
    2
    Views
    303

    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.
  14. Replies
    6
    Views
    622

    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...
  15. Replies
    7
    Views
    5,553

    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...
  16. Replies
    7
    Views
    5,553

    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...
  17. Replies
    7
    Views
    5,553

    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.
  18. Replies
    7
    Views
    5,553

    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...
  19. 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...
  20. 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.
    ...
  21. Replies
    4
    Views
    541

    Timescale. That's it! When I change the five...

    Timescale. That's it! When I change the five date values to 1-5 I can adjust the Overlap and Gap to display what Steve displays. I'll have to find a workaround to display the dates if I need a...
  22. Replies
    4
    Views
    541

    Width of Columns in Column Chart

    I have made a chart (vertical columns) with only five data points and I would like to widen the columns.

    In Format Data Series - Series Options I have adjusted Overlap to 100% Overlap and Gap...
  23. Replies
    12
    Views
    3,380

    Upgrading from Outlook Express

    I'm running Outlook Express on Windows XP. I plan to purchase a new pc with Windows 8 soon.

    Did MS make a version of Outlook Express for the new Windows?
    If not, what's a good alternative? ...
  24. Format for Pivot Table to Hide the "(blank)" result

    How can I hide the "(blank)" results in a pivot table when the field data are empty?

    I have created a table of results by placing the data fields in only Row Labels. Its a list of customers -...
  25. Replies
    3
    Views
    584

    Trailing 26 Periods for Charting

    I have a table to which I add bi-weekly data in a new row and a chart based on the table which displays the most recent 27 bi-weekly period results. What functions can you suggest I try to get the...
Results 1 to 25 of 324
Page 1 of 13 1 2 3 4