Copy rows to current sheet if condition meet

[ohexcell_ineedu]

Hey guys,

I am wanting to copy certain rows (which meet a condition) to the current selected sheet in an excel document, to create a daily report of current jobs.

My work flow is:

I have a register which each work request goes in. Each request is assigned a status, whether it is an "Open" job, an "On Hold" job or a "Closed" job.

I have a report template and a macro that I found that lets me copy the template and rename it. My naming convention is to call it todays date in reverse, ie 120804.

Once I copy the template and rename it, I want a button on the new template (say 120804) which will then copy all "Open" jobs to row 26 and below.

I would also like to the run another macro that will then insert the "On Hold" jobs beneath the "Open" jobs.

My current macro replaces the contents of the previous paste, and I'm unable to work out how to modify it so it paste to the currently opened sheet, not sheet2.

Click on the following link to be able to download the example. https://dl.dropbox.com/u/9154762/Copy rows to current sheet.xlsm

If i need to further explain things please feel free to ask me thanks.

Any and all help from this forum would be greatly appreciated!

 

[Tinbendr]

Click this for attached solution.

 

[ohexcell_ineedu]

That is amazing Tinbendr, thanks for helping me work smarter, not harder!!