Search:

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

Page 1 of 13 1 2 3 4

Search: Search took 0.03 seconds.

  1. Replies
    1
    Views
    57

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

    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.
  3. Replies
    6
    Views
    224

    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...
  4. Replies
    7
    Views
    196

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

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

    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.
  7. Replies
    7
    Views
    196

    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...
  8. 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...
  9. 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.
    ...
  10. Replies
    4
    Views
    370

    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...
  11. Replies
    4
    Views
    370

    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...
  12. Replies
    12
    Views
    2,073

    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? ...
  13. 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 -...
  14. Replies
    3
    Views
    453

    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...
  15. Replies
    4
    Views
    4,902

    Thanks Rory. I've created PT formulas before. ...

    Thanks Rory. I've created PT formulas before. But I've also seen the rows automatically summed.
  16. Replies
    4
    Views
    4,902

    Pivot Table - Grand Total for Rows

    I've got a simple set of data which I want to summarize in a Pivot Table. There are only two fields that I want added together for each record. The Pivot Table sums down the two columns but I can't...
  17. Replies
    2
    Views
    481

    Wow! Thanks RG. That is perfect.

    Wow! Thanks RG. That is perfect.
  18. Replies
    2
    Views
    481

    Custom Number Format for Date

    I am building a pivot table which brings a field called Last Date of Change which in the source data is either blank (for new hires who haven't yet gotten a raise) or displays the last rate change...
  19. Thanks RG for the explanation. Since most of my...

    Thanks RG for the explanation. Since most of my code is simple I think I can declare the variables within the routine (between the Subs). I'll check out that article, too.
  20. Thanks Steve. This works with just Dim...

    Thanks Steve.

    This works with just Dim UserValue as String. What's the Option Explicit for? Seems to work fine without it.
    When I try to it add above the line Sub AddDate2Header(), VBA...
  21. XL Macro to place date in sheet header

    I'm trying to create a macro to get a date, place it in a cell, and then use that date to update certain sheets within the workbook. But I'm getting an error message when the macro gets to user...
  22. That's great! Thanks Maud. I modified it for...

    That's great! Thanks Maud. I modified it for three charts and it works perfectly.
  23. Well, it turns out that the fix was easier than I...

    Well, it turns out that the fix was easier than I thought (or feared) it would be. On merely a hunch, I went to the new worksheets that I had added back in April. Recall that this workbook is used...
  24. Replies
    9
    Views
    2,599

    jj: I just now got back to this post and retried...

    jj: I just now got back to this post and retried Locate. I ran the database update for my folder on the network which took just a few minutes (probably less than three). I was able to save the...
  25. Replies
    9
    Views
    2,599

    jj: Your idea sounded great, especially being...

    jj: Your idea sounded great, especially being able to get the results to the clipboard. But it looks as though Locate only works on a pc's hard drive. I need something more robust and capable of...
Results 1 to 25 of 313
Page 1 of 13 1 2 3 4