Insert Titles on Immediate Top Rows of Each Sale Rep

[Warmhearted]

Hello,

I manually insert titles on immediate top rows of each Sale Rep in this "worksheet" as shown below. This title is saved on "heading" sheet.
Then, I highlight days that have same date sale as you can see below. Finally, I print report for each of Sale Reps for their record only.

Can you help create a VBA code that do:
1. Insert titles on immediate top rows of each Sale Rep
2. Highlight days that have same sale date
3. Print reports for each of the Sale Rep for their own record only. ( I used to highlight A1-J4, A5-J14.... and so on, then print selection.)

Thanks for your help!

 

[Michael M]

Nooo, we need a code we can work with...Go to the VBA module select the code copy,
Then paste it back here....then give us a sample of your data using XL2BB.
OR simpler would be to upload the file to a hosting site like DropBox and then post the link to that file back here.

 

[Warmhearted]

Hi Michael,
This is all I can do. Thanks Michael!

 

[Michael M]

Pictures are something that we CAN'T work with!!