Search:

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

Search: Search took 0.00 seconds.

  1. Re: If Chip Pearson's website ever helped you, please jot a note...

    I too have spent many hours on Chip's website. I can't even fathom the amount of hours it has saved me.

    Thank you to those who have had it restored, and condolences to his family and friends.
  2. Re: Excel 2010: How to format ALL data point labels SIMULTANEOUSLY

    This was the fastest way I've found (I have a long briefing with a ton of multiple-series charts). Thank you!

    PS - although a trip to Redmond might be in order.... I mean, come on, it can't be...
  3. Re: having problems getting excel vba to save a powerpoint

    It did work (Sorry it took so long to follow up!).

    Thank you!
  4. Re: having problems getting excel vba to save a powerpoint

    Thanks! I will try simplifying and see if it works.
  5. Replies
    0
    Views
    1,276

    Excel VBA to save Powerpoint file

    Hi all,

    I have data in an Excel file that needs to be displayed as a table in PowerPoint. I'm still working on the code for that, but in the meantime, I was trying to write the code to SAVE that...
  6. Re: having problems getting excel vba to save a powerpoint

    @sumhungl0, did you ever figure this out? I am having a similar issue and was wondering.
  7. Replies
    6
    Views
    317

    Re: Select and sum

    ok so then you have columns A-E on the sheet for each month. Let's assume the sheets are named "jan" "feb" "mar"...etc.

    Your summary page will look like this:

    <tbody>
    Projects
    Jan
    Feb
    Mar...
  8. Replies
    7
    Views
    227

    Re: vlook up + If statement

    I took your reference table and put it on one sheet (called "RefSheet") in the upper left corner and put the other table on the next sheet (called "Data").


    <tbody>
    This is the data that I...
  9. Replies
    7
    Views
    227

    Re: vlook up + If statement

    I think so. Do you have any dates out of that 9/2012 - 9/2013 range? I guess what I'm asking is will you have to check both side of the range, or will it be sufficient to just compare the given...
  10. Replies
    4
    Views
    197

    Re: variable drop down lists

    Ah, yes, thank you, Smitty! I knew there was a name for it. Yokiboha, click on the link Smitty provided as well. Although I generally find that playing around results in my learning a lot more...
  11. Replies
    6
    Views
    317

    Re: Select and sum

    <tbody>
    DAY
    Project
    Hrs
    Project
    Hrs
    Project
    Hrs
  12. Replies
    4
    Views
    197

    Re: variable drop down lists

    Have you played around with the Data Validation (Data tab, Data Tools section, Data Validation)?
    I did something similar on an old worksheet, and I'm trying to find it. But I remember one part...
  13. Replies
    6
    Views
    317

    Re: Select and sum

    Will each day only have one row? That is, can the employees only work on one project per day?

    Does/will this worksheet reside on a server where all the employees have access to it? Or will they...
  14. Replies
    7
    Views
    227

    Re: vlook up + If statement

    I'm confused about what you want to accomplish. Are you trying to fill out the second table - by doing a vlookup into the first table for the PLC and then you want to fill in the rate (be it rate1...
  15. Replies
    0
    Views
    68

    Convert text to create chart?

    Hello all...

    I'm trying to figure out how to do this, if it can be done at all. I have a bunch of products down the first column, and dates across the top. In the middle, there are 1 word...
  16. Re: Pivot Chart from table - sort on non-graphed column?

    thanks!
  17. Re: Pivot Chart from table - sort on non-graphed column?

    RoryA,

    Is there a way to sort on the row totals before plotting?
  18. Pivot Chart from table - sort on non-graphed column?

    Hello there, this seems like it shouldn't be too tough, but I'm not coming up with anything in my search.

    I asked this in another forum a couple of days ago and have not received any responses:...
  19. Replies
    2
    Views
    304

    Re: problem with save as?

    Figured out that I had to move

    Set wbNew = Workbooks.Add 'adds blank workbook
    wb.Activate
    into the For loop,
    add
    Dim ws As Excel.Worksheet
    and replace ...
  20. Replies
    2
    Views
    304

    problem with save as?

    The following code (full code at the bottom) is a subroutine in which I want to save a worksheet row by row into textfiles. Row 1 has the headers.

    It works fine until I get to the execution of...
  21. Re: Creating multiple series chart without hand selecting each dataset

    I've written some rough pseudo code, maybe someone can help me turn this into a macro?

    I'm trying to capture x data and y data for each series in an array, so that I can use the SERIES function...
  22. Creating multiple series chart without hand selecting each dataset

    First time poster here, but I've checked out the cross posting info and hope am doing it correctly. Please let me know if I'm not doing it the correct way, and I will try my best to correct it. I...
Results 1 to 22 of 22