Copy Data to Other Sheets' Columns Based on Criteria

Hello Rob Nunley,

Your problem can be easily solved by utilizing excel's Pivot Tables. I hope you are somehow well versed with excel's ribbon menu. here are the general steps:

1. Create an Excel table with your order data.
2. Create a month column using this formula: "=TEXT([@[Order Date]],"MMM")"
3. Use the table as a source data for your pivot table.
4. Drag order date and make fields to the rows area.
5. Drag model to the coluns area.
6. Drag month to the filters area.
7. Drag Cost to the Values area.
8. Format the pivot table to your liking.
   1. Click the Sum of Cost and choose value field settings.
   2. Click Number Format and choose Currency then click OK, and then OK again.
   3. Under the design tab Click Subtotals and choose do not show subtotals.
   4. Click Report Layout and choose show in tabular forms.
   5. Click report layout and choose repeat all items labels.
9. Generate the Sheets that you need.
   1. Under the analyze tab, click the little arrow beside the Options.
   2. Click show report filter pages.
   3. Click Month and then click OK.
10. You're Done! if ever that you entered more data on your orders table, just click Refresh All under the Data tab and everything will be updated.

I have attached the file which includes the sheets for Sep and Oct. In the case of another month (Let's Say Nov) you can do step 9 again, just delete the duplicate sheets (Sep (2) and Oct (2)).

I hope you can try out the steps and get familiar with Excel's capabilities. If you ever need more details on the step, I can update this post and add more screenshots.

Good luck on you task,

Argelo Royce Bautista