Need help witha forumla?

[FRANK T]

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]

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.