Need help witha forumla?

  • Thread starter Thread starter FRANK T
  • Start date Start date
F

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
 
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.
 

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

Similar Threads

What function do i use? 4
Rolling Formula based on If 2
Linking Data from 1 worksheet to another by using dates? 1
How input today's date and keep that date 3
Formula that brings in daily input from a range of cells. 3
Transferring CERTAIN Data from one worksheet to another 1
Copy Data only if the cell has a value 8
Need help with formula 3

Back
Top