1. B

    vba code to aggregate data selection from checkboxes into listbox

    I am at a loss for how to do this. My current code is simple and displays data only for the latest checked box: Private Sub ComboBox1_Change() End Sub Private Sub CheckBox1_Change() Me.ListBox1.RowSource = "Sheet2!A22:A32" End Sub Private Sub CheckBox2_Change() Me.ListBox1.RowSource =...
  2. M

    Need to Pull Data from Named Ranges in Separate Workbooks

    I have several workbooks in a folder. Each has a transaction worksheet and a summary worksheet. The number of rows of data in each summary sheet differ from workbook to workbook but all fall within a dynamic range having the name "AData". I would like to consolidate those summary records into a...

Some videos you may like

This Week's Hot Topics