I will like to export to an excel document to create a report for a year period. There are 12 sheets January to December with headings that will relate to the fields i will like to pull from the database for specific customer (ASHLAND TRINIDAD & TOBAGO LIMITED).
The field in the database i will be using to reference the date for jobs is [created] with the label 'RECEIVED DATE-TIME'. This means jobs created for january when i export to the excel document will fall on the sheet january and so on. So if for example i am in the month of March and updated information in the database for the month of February it must be shown when i export to the excel sheet no matter what month i am currently in.
I will just like to press a button if possible that will export updated information from the database to the fields in the excel document respective to the month when it was created ([created] field). IF a table can be created with lines in the excel sheet as a new job is added will be nice too. Also i don't want the header to scroll down.