I am looking to filter a list that may have varying numbers of rows (but the same number of columns)on say Heading1, select the values in a different column, say Heading4, and copy these values to either another place in the worksheet or another worksheet. The column (Heading1) to be filtered will have several different values and I want to sequentially filter on these values and copy the results in the Heading4 column to specific locations. As this will need to be done on a regular basis, I am looking to do it within a macro. Thanks in advance for your assistance.
Filtering, selecting and copying from a changeable list with a macro
- Thread starter bert
- Start date
Bert
Firstly, Welcome to the Chandoo.org forums.
You can used named formula or a data table to allow for the varying numbers of rows
You may want to read the following post which does something similar:
http://chandoo.org/wp/2012/05/14/vba-move-data-from-one-sheet-to-multiple-sheets/
Firstly, Welcome to the Chandoo.org forums.
You can used named formula or a data table to allow for the varying numbers of rows
You may want to read the following post which does something similar:
http://chandoo.org/wp/2012/05/14/vba-move-data-from-one-sheet-to-multiple-sheets/