Pull "Yes" rows from 12 worksheets into 1

Hi All -

I have come across an little issue.

I would like to create a button on a Milestone Tab - that pulls in all rows from 12 worksheets into one worksheet that have "YES" in the milestone column.

Ideas?

Try:

Please Login or Register  to view this content.

Thanks. Is there way of adjusting the code, so that it doesnt keep copying and pasting if someone clicks the button to run this...? And to hold current formatting?

"Is there way of adjusting the code, so that it doesnt keep copying and pasting if someone clicks the button to run this...? "
- This makes no sense to me. Isn't that what you want it to do?

"And to hold current formatting?"
- Which formatting? The old sheet or the "Milestones" sheet.

Just a guess:

Please Login or Register  to view this content.

Hey sorry it took forever to get back - I am almost there -

Everytime I click the button to populate the sheet with Yes - it keeps copy and pasting data to the bottom of the worksheet.

I really would love to rewrite the information over the current information. Is that make sense now?

Also to go along with this concept - is there way of tweaking this code - to extract data by the end date column? Pull out all rows that are ending within the next 2 weeks?