Search:

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

Search: Search took 0.00 seconds.

  1. Re: Counting records in 1 column based on another

    alansidman - nice one - thanks!
    sandy666 - got it, thanks
  2. Re: Counting records in 1 column based on another

    sandy666 - Thanks a lot, that was really cool
    I never used that Agregateoption before (i.e., outside of group)\

    Worked perfectly

    Thanks,
    David
  3. Counting records in 1 column based on another

    In the table below, I need to get a unique list of IDs with a count of how many were sold
    In the example below, ID #1 was sold twice, #2 zero, #3 one, #4 zero, #5 one.

    In order to do this, I...
  4. Re: Getting value of named range from multiple workbooks

    I figured this out.
    Power Query was considering the named range as a table without any rows, which in turn means that the values were considered the column names.
    Therefore, I was able to use...
  5. Getting value of named range from multiple workbooks

    I used the following code in a custom column to get the workbook info:

    Excel.Workbook([Content])
    Then I used the double arrow button to expand the workbook dataI am using Power Query to import...
  6. Replies
    6
    Views
    897

    Re: Power Query - Hyperlink to file

    Thanks - this worked for me.
    I created a button that runs a function to refresh the query and replace the = sign
    Works perfectly!
    Thanks
  7. Replies
    6
    Views
    897

    Re: Power Query - Hyperlink to file

    Ok, thank you
    Is there any workaround?

    In any case, a "No" is better than more hours wasted on trying... ;)
  8. Replies
    6
    Views
    897

    Power Query - Hyperlink to file

    I have a power query setup that imports tables from all excel files in a folder.
    Is it possible to have a column that contains a link to the original excel file?

    [I have this working in a regular...
  9. Re: VBA code to create PDFs causing Excel to crash immediately without any hang

    Hjemmet, thanks but we are talking about doing it through VBA code
  10. Re: VBA code to create PDFs causing Excel to crash immediately without any hang

    I did not know that - can you show an example?
  11. Re: VBA code to create PDFs causing Excel to crash immediately without any hang

    ranman256, I began to try that but then realized that I won't be able to name the file which is very important, so I didn't continue down that path
    Hjemmet, thank you, but that seems to be the same...
  12. VBA code to create PDFs causing Excel to crash immediately without any hang

    Hi, I have a VBA procedure that loops through each file in a directory and does the following:
    1. Opens the file
    2. Selects 2 sheets
    3. Exports those sheets to a PDF

    Excel is crashing during...
Results 1 to 12 of 12