forms and reports

G

Guest

I would like to create a file to store product numbers and when they go on sale. There would be a column for the sale price the start date and the end date of the sale. I would like to create a form for staff to enter sale info every day and I would like for them to be able to run three reports, what sales started today, what sales end today and what might be the sales history on a particular item number. Can anybody help?
 
T

Tom Ogilvy

Create a database/table on your spreadsheet.

Use the autofilter under the Data=>Filter menu to view subsets of records.

--
Regards,
Tom Ogilvy

Brad said:
I would like to create a file to store product numbers and when they go on
Click to expand...
sale. There would be a column for the sale price the start date and the end
date of the sale. I would like to create a form for staff to enter sale
info every day and I would like for them to be able to run three reports,
what sales started today, what sales end today and what might be the sales
history on a particular item number. Can anybody help?
 

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

Impossible - Dynamic Legends? 2
Dynamic Graphs - code needed? 1
I need ONLY subtotals copied to a second sheet 4
copy and past based on criteria 4
UDF weeks of inventory calculation - lost on how to create this lo 3
String of sales codes to be broken into separate columns 2
Scan for combo then insert row 3
Hide rows depending on the date 1

Top