Compiling Revenue Reports



I have been assigned the task of creating a daily revenue report that
automatically creates/updates a weekly, monthly, and annual report. The plan
is to have Monday-Sunday and the weekly in 1 workbook and then
January-December and the annual in another workbook. The user will enter
data on the daily reports, which will then automatically update the weekly,
monthly, and annual. Is there any way to reference each daily to create a
day by day monthly, which will then create the annual by month? This will
need to be done every year and starting next year it will need to show daily
variances to the previous year. What would be the quickest and best way to
link the worksheets/workbooks, to compile this data correctly?


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question