Help creating a report

[towners]

Hi

I need to create a daily rport for a morning meeting from an excel table that hold my productivity data for a number of production lines.

I was thinking of having the user enter a date into cell C1 of the report, then hitting a macro that collected the data for that date and pasted it into another table. (I've shown the client pivot tables but they want a specific report printed).

I'm thinking along the lines of:

collect the date
find the first occurrence of the date in my sorted table [firstdate]
find the last occurrence [lastdate]
copy the data from the relevant rows and paste

Can anyone help me with the method and code for my macro?

Many thanks

Paul

 

[Makrini]

We can write a macro to do this fairly easily.

However we know more about your data. It also may turn out easier to use formulas if you are consolidating the data into a report.

1. Whats the layout of the data you are taking from
2. Whats the layout of the report you want it in

 

[towners]

Hi, thanks for the response.

My data in the report and the database table is:

A:Line, B:Shift, C:Product, D:Batch, E:Units, F:Productivity, Stats etc.

 

[Makrini]

ok - I still have no idea what your resultant data will look like and how it relates to your original data.

Have you thought about using autofilter?

If you are looking to not do any calculation - and simply copy across data within a date range you can easily auto filter and copy.

(You can record a macro that does this - then modify the criteria)