I have used excel in it's basic form for many years but have rarely ventured into VBA programmng. I have been asked to automate the processing of a weekly excel report that arrives in a given format (which I can't change):

1) the file comes in with two worksheets.
2) I'm supposed to write something to take data from the second sheet (name should be fixed), produce a third sheet and then email that sheet to a specific person.

My questions are: how are macros managed on excel? - what process should I use to associate an incoming spreadsheet with a prewritten macro?

I hope someome out there knows what I am talking about!