ArryLists for Multi-Column

Good Morning,

I'm trying to Frankenstein some code together to build a report-like userform.

It works for what I need aside from only listing the information on a single column. Hows it setup is that a User can select a list of buttons , depending on what is selected the buttons are assigned a value that is sent to an assigned cell. Based on the value of that cell, the userform will filter the data. The way it is now, works for what I want so multiple people can pick up reports at the same time.

If anyone knows a way to modify this allow the first column to be to be filtered but show the entire row. I'd truly appreciate it.

The code;

Please Login or Register  to view this content.

Please let me know if I can provide any further details. i will not be able to send a copy of the workbook or sheet.

Administrative Note:

Welcome to the forum.

We would very much like to help you with your query, however you need to include code tags around your code.

Please take a moment to add the tags. Posting code between tags makes your code much easier to read and copy for testing, and it also maintains VBA formatting.

Please see Forum Rule #2 about code tags and adjust accordingly. Click on Edit to open your post, then highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here

(Note: this change is not optional. No help to be offered until this moderation request has been fulfilled.)

Where is the value from Sheet2.Range("AP6").Value coming from?