Search:

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

Page 1 of 6 1 2 3 4

Search: Search took 0.16 seconds.

  1. Re: All Combinations of Multiple Columns Without Duplicates

    A bit more code to ensure the salary worksheet contains valid numbers, does not have duplicate names and has a name for each entry in the grid on the main worksheet. Read notes in the code.


    Sub...
  2. Re: VBA to generate hyperlink to new sheet and assign to shape

    Glad to help. Thanks for feedback.
  3. Re: VBA to generate hyperlink to new sheet and assign to shape

    Modify the indicated one line of your code and add the lines marked as new lines .


    Option Explicit

    Sub AddShapeWithhyperlink()

    Dim mySheetName As String ...
  4. Re: Why is Columns:=aryDeDupe not the same as Columns:=(aryDeDupe)

    The only seemingly-applicable reference I could find stated that the parenthesis around the array forces an evaluation and allows Excel to "see" the contents of the array. There was no attribution...
  5. Re: Character Limitation formula help needed

    I could not find a reference for 12NC SKU code. There are likely rules that specify exactly how to create the code but without knowing them this answer is a guess. The only reference I could implied...
  6. Re: Autofilter with 2+ cell references with "or" and "contains"

    If each of your columns has a unique header then you could use SQL in Excel VBA to copy the rows that met your requirements to another sheet.
  7. Re: VBA to select last 12 items in a pivot table drop down

    If it was a regular pivot table "Month" would do. I am not sure about the CubeData aspect of it.
  8. Re: VBA to select last 12 items in a pivot table drop down

    Edit first Const line to contain the name of the pivotfield you want to filter.

    Option Explicit

    Sub SubSelectLastXPTItems()
    ...
  9. Re: How to connect visio shapes on page by passing the name of the shape to connect to from a variable?

    This probably can be cleaned up, but it works:

    Sub TestConnect()
    'Code in Visio Module
    'Excel running with info document on active worksheet

    Dim appXL As Object
    Set appXL =...
  10. Why is Columns:=aryDeDupe not the same as Columns:=(aryDeDupe)

    Working to answer this thread:
    https://www.mrexcel.com/forum/excel-questions/1106189-all-combinations-multiple-columns-without-duplicates.html

    I needed a way to remove duplicates from a variable...
  11. Re: All Combinations of Multiple Columns Without Duplicates

    What line in code was highlighted when you received the error?

    I tested it with various name/column combinations (including your original layout) and dummy salaries and did not get an error...
  12. Re: All Combinations of Multiple Columns Without Duplicates

    Test totals on a subset.


    Option Explicit

    Sub NameCombos()
    'https://www.mrexcel.com/forum/excel-questions/1106189-all-combinations-multiple-columns-without-duplicates.html

    ...
  13. Replies
    12
    Views
    26,732

    Re: Removing Duplicates dynamic columns VBA

    Code that uses the dynamic columns for RemoveDuplicates can be found here:
    https://www.mrexcel.com/forum/excel-questions/1106189-all-combinations-multiple-columns-without-duplicates.html
  14. Re: All Combinations of Multiple Columns Without Duplicates

    And finished the error checking I got distracted from:


    Option Explicit

    Sub NameCombos()
    ...
  15. Re: All Combinations of Multiple Columns Without Duplicates

    Added some code to handle duplicate rows which will occur when the same name is in a single column.


    Option Explicit

    Sub NameCombos()
    ...
  16. Replies
    12
    Views
    26,732

    Re: Removing Duplicates dynamic columns VBA

    Post 11 is correct.
    But why does the Columns argument have to be in parenthesis

    This works:

    .RemoveDuplicates Columns:=(varItems), Header:=xlGuess

    This does not:

    .RemoveDuplicates...
  17. Re: All Combinations of Multiple Columns Without Duplicates

    Your example had 233,280 combinations of which 3236 met your requirements.



    Option Explicit

    Sub NameCombos()
    ...
  18. Re: Check the date from a column of a table

    Assuming EmpID is in column A of the table.


    Option Explicit

    Sub Test_CheckDates()

    Dim sEmpID As String
    Dim dteInput As Date
    Dim retVal As Variant
  19. Re: Pivot table Weighted average not the sum of its parts - why?

    Figuring the distribution of the Quantity column over its total does result in the values in the Weighting column.
    How is your PT data laid out?
    Which of those columns are in each PT Field (column,...
  20. Re: Using Macros to Make Powerpoint Slides from Excel

    Have not tried this on a Mac, but it works on Win10/Office 2016


    Option Explicit

    'https://www.mrexcel.com/forum/excel-questions/1105935-using-macros-make-powerpoint-slides-excel.html
    ...
  21. Replies
    1
    Views
    115

    Re: Macro for calculating Store Balance

    Generally the goal for this forum is to answer questions to help the poster with a particular problem, not redesign an entire application. Please break your question down in to smaller chunks and...
  22. Re: Graph exclude blank months at end of year

    Check out Peltier Tech Blog

    https://peltiertech.com/easy-dynamic-charts-lists-tables/
  23. Re: Worksheet SelectionChange - Need value from previous cell (the one that was just changed)

    This may cause problems with other macros that change the active cell, but it meets your requirements. All code into the ThisWorkbook CodePage.
    Value of the previous ActiveCell is in column C of...
  24. Re: Checking a textfile name for changes and enable a label

    Glad to help.
  25. Re: PivotTable refresh date history / flag new data since last refresh

    Glad to help
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4