generate excel vba report

[ellyna]

I have an excel vba database, how can i generate a daily report based on the 3 input and calculate the sum of total for each column of output into report ?
For example : Generate daily report on utilization, output and rejection and generate the total sum too for each in the report. As in my database each column does not calculate the total sum. Thank you.

 

[sijpie]

Hi ellyna,

your question is somewhat unclear:

Why do you call this a vba database? or a vba report?

For the table you show, what would the report need to look like? Please make the report by hand as an example.

 

[ellyna]

Hi ellyna,

your question is somewhat unclear:

Why do you call this a vba database? or a vba report?

For the table you show, what would the report need to look like? Please make the report by hand as an example.

I mean that i need to generate vba daily report based on the date of each day, and the report include the 3 items above + the sum of each column in the report.

As you can see that the input of the 3 item does not sum up the production output.

I'm not sure if you get what i mean so i will draft an example below.