Opening a spreadsheet - can it ask the user for a date?

S

Susan

We have a spreadsheet that is opened in read only for our clerks - is there a
way that th spreadsheet can ask the users for the shipment date of their
orders, as they will all be the same, example 11/12/09, and the spreadsheet
enter that date automatically on cell A1 of spreadsheet called TOC.

Our clerks are entering the total # cases shipped an accrual form is printed
out with prices and codes and we want the date to be entered automatically on
all of the accruals so that they do not have to keep reentering the date, as
we may have 100 different accruals each day and we use about 100 different
sheets. If the date is on a particular cell i want to be able to tell the
spreadsheets to pull that date in if there was one entered when the read only
excel is opened?

Thanks
Susan
 

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

Add Date 2
Spreadsheet formatting changes on different computers 1
can I create a mouseover in excel 0
Assigning a value to one cell based on the date in another... And then doing it again 0
Incorporating the User Profile location into a document template path 1
Word macro that can call cells out of Excel for a find and replace 0
Make "File in use" message appear when 2 people open the a shared document in the same time 3
vacation formula 0

Top