ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Need help witha forumla? (https://www.excelbanter.com/excel-worksheet-functions/220391-need-help-witha-forumla.html)

Frank T

Need help witha forumla?
 
I want to input information on a worksheet, and save it with that date I
input the info. I aslo want to reuse that workshhet tomorrow and save it with
tomorrows date. How can i track the information input on both days and keep
that information for monthly reporting
IE; sold i car today Save worksheet
sold 5 cars tommorrow save worksheet
sold 3 cars the next day
I am always using the same worksheet and sabing it by date but want the
daily information to roll up for monthly totals

Fred Smith[_4_]

Need help witha forumla?
 
Why not do what everyone else does? Put the new information on a new line.
Now to produce monthly reports, it's a simple matter of creating a pivot
table. Look into them. They're impressive and easy to use.

Regards,
Fred.

"FRANK T" <FRANK wrote in message
...
I want to input information on a worksheet, and save it with that date I
input the info. I aslo want to reuse that workshhet tomorrow and save it
with
tomorrows date. How can i track the information input on both days and
keep
that information for monthly reporting
IE; sold i car today Save worksheet
sold 5 cars tommorrow save worksheet
sold 3 cars the next day
I am always using the same worksheet and sabing it by date but want the
daily information to roll up for monthly totals




All times are GMT +1. The time now is 02:51 AM.

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