ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Revenue Report (https://www.excelbanter.com/excel-discussion-misc-queries/445980-revenue-report.html)

mlowed

Revenue Report
 
Hi every body!
I w'ld like to extend my sincere thanks to all adminstrators of this site for approving me as member.

my concern is: I ned help on how i can make our company's daily report that creates an update report for weekly monthly and annual report in excel

please i need your assistance.

thanks,

James Ravenswood

Revenue Report
 
On Saturday, May 5, 2012 3:52:06 PM UTC-4, mlowed wrote:
Hi every body!
I w'ld like to extend my sincere thanks to all adminstrators of this
site for approving me as member.

my concern is: I ned help on how i can make our company's daily report
that creates an update report for weekly monthly and annual report in
excel

please i need your assistance.

thanks,




--
mlowed


I would create a workbook in which the first tab would contain all the daily data for an entire year. Each row would represent a day. The most recent day would alwaya be at the top of the tab. On separate tabs I would have the weekly, monthly and yearly summaries. Each of these tabs would add appropriate values from the first tab to produce the correct summaries


All times are GMT +1. The time now is 06:08 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com