On Sheet code for Muti-Row Selection

[sorensjp]

Hello All,

I'm looking to select Multiple Rows using a specific column of cells on "WEPS QUAL REPORT" Sheet. I'm have Target Column set to Wingdings 2 Font to create a Check Mark.

I would like to Place the selected Row number in A21:B40. Ultimately I intend on creating a User form to add Dates to selected Cells for each selected Row. I'm having problems getting past this point.

The on Sheet code below (sh06) is what I was tinkering without success.

Please Login or Register  to view this content.

[davesexcel]

Try this,

A21:B40 is a merged cell, you may have to wrap the text and change the font.

Please Login or Register  to view this content.

[sorensjp]

davesexcel,

Your solution works exactly how I asked. But, I realized it's inefficient whereas I'm trying to update specific cells in columns based the Selected Rows.

I don't know if I should close this thread and repost a new one?

I've uploaded a new workbook.

The Target data Row I what to update is located on sh11. I'm using Advance filters to copy over the Data and have the Target Row located in hidden column "S" on sh06. How could I pull that Row Number from the column located adjacent to the Check Box column and add the Selected Date in the corresponding cell on sh11?

For instance Column AI on "WEPS QUAL RPT" sheet which is "AA & E Screening" I would like to enter a date then run a Macro to update the data located on CREW_WEAPS_DB (sh11).

Please Login or Register  to view this content.

Thank you for help on this.

Again Thank you,
Jim