Generate auto weekly report

I would like to generate weekly report aotomatically once i select the start and end date as an example the highlighted in yellow column data from sheet1 should appear automatically once I select the week start date and week end date and also it should match the action and date from the sheet1.

There are possibility of having duplicate numbers from sheet1 column "B" but which might have different action.

Please note that 01.01.08 have several action. Is there any way I can generate auto weekly report with VBA form or macros.

Thanks in advance.

Abdul Mannan

Hi

Can you update your example to show what should appear for your selected criteria, and the reason(s) that this data was shown.

Not sure from your post exactly what data should appear, and what, if any, is the impact of the data on sheet2.

rylo

Hi,

I updated the file as per your request.

Thanks,

Abdul Mannan

Hi

weekly!B4:

Please Login or Register  to view this content.

Copy across to L4, then copy B4:L4 and put on row 9, 14.....

You don't really give any indication if the extra rows are going to be used. Also, this approach assumes that there will only be 1 combination of date, action.

HTH

rylo