Make a report with data taken from cells

[Rayman]

Again here...

I need a macro to make a report from data from column O of a sheet.

To make it clear i attached an example workbook.

Thanks in advance for your reply.

[HiTechCoach]

I assume you want to use Access to create a report from data in an Excel workbook.

One possible method is to create a linked table to the Excel workbook. Now you can use a query to select the desired data for a Access report. Create a Acess report based on the query.