How to create a macro to populate selected required data on to a table ?

[chon]

Hi guys,

I need your help as I'm not familiar on how to create macros in MS Excel.

I have a set of data relating to events which I extract from one of our databases on a regular basis. The event has a unique identifier which is the Event Id in column A as indicated in the Data Tab attachment. Each event has its own event details pertaining to each field (i.e. columns) as indicated in the Data Tab attachment.

What I would like for the macro to do is to populate the selected / required data as per the column headings highlighted in green in the Data Tab attachment corresponding to each Event Id onto the relevant fields in the table as indicated in the Table Tab attachment. One table for one event.

What I would also like for the macro to do is to be able to identify how many Event Ids there are in the Data Tab attachment and create / replicate the number of tables (including the relevant fields and cell / table formatting) required accordingly. For example, if there are 50 Event Ids in the Data Tab attachment then there will be 50 tables created / replicated prior to the selected / required data been automatically populated onto the relevant fields in each table corresponding to each Event Id.

The tables should be listed in order corresponding to the Event Ids listed in the dataset even though the event Ids are not sorted by value from smallest to largest or vice versa. In addition, the dataset and tables need to be on separate tab / spreadsheet within the workbook.

Thanks in advance for your help.

Kind regards,

Charles