Hi,
I've just joined the forum, looking for help on a spreadsheet that i'm working on.
I'm somewhat of a VBA novice but have slowly worked my way through a number of macros to get my spreadsheet working as i'd like. However i'm stuck on this step:
I'm trying to use a Listbox Multiselect as the criteria to find, copy and paste the relevant rows to a new worksheet.
The Listbox is defined using a static range of one column 'Sectors', and is located on worksheet 'Reports'.
The data i am trying to search for is located on worksheet 'All Data', which contains numerous columns including 'Sectors'.
E.g. i'd like to tick 'Chemicals' and 'Health Care' in my Listbox and use a macro to loop through and find all the rows of data that have 'Chemicals' or 'Health Care' as the 'Sectors', and then copy, paste these rows into a new worksheet.
Any help much appreciated.
Bookmarks