Export to Excel Button

[AshleyJohn]

Is there a way of creating a button that will export data to excel, but only data that I specify off several different forms?

I have a form with a subform and I would like to put a button that will export the data from the subform but include fields from other forms.

Thanks for your help!

 

[AshleyJohn]

Sorry forgot to add that I would only want the data displayed in the subfom on that form (Customer ID linked).