Copy & Paste Sorted Rows

I have a workbook with multiple spreadsheets. The first sheet is where I have the data and the other sheets are reports.

With the first three rows as headers I use Autofilter on line three and sort the data as desired using macros. Then I copy the remaining rows and paste them to another spreadsheet and hide the columns not wanted.

The macro finds the next available row in the report and inserts a heading i.e. Sales – then return to the data and resort as desired – copy and return to the report – find the next line and insert another heading i.e. Open Proposals, find the net open row and paste the data.

My questions are:

1 I need to sort the data looking for a specific date range - what is the code to prompt the operator for the a date range for a specific column?
2 Once the sort has been completed what is the code to select and copy the remaining rows after row 3 so they can be pasted into the report spreadsheet?
3 What is the code to find the next available row to paste the data into the report sheet?

Post us what you have so far and we can continue. For the MsgBox use something like:

Please Login or Register  to view this content.