I need help with recalling information

  • Thread starter Thread starter Akira5284
  • Start date Start date
A

Akira5284

Howdy all,

I am attempting to make a Timesheet work book where people could lo
their hours and such. One thing it has to be able to do is recall
list of current jobs so that employees can list which jobs they wer
working on. It would be ideal if this job data file were on our serve
computer so that if changes need to be made to it all users would ge
an updated job file each time they ran the worksheet. Can informatio
on a seperate workbook be accessed over the network in the manner whic
i'm looking to accomplish?

I'm fairly new to all of excel, i believe that is the only question
have for now. Thanks everyone.

-Akir
 
The short answer is yes.
Here is how I have done something similar. I have a parts sheet that
contains prices. In my quoting sheets I have cells that pull in those
prices. When the quote sheet is opened the user is told that "This workbook
contains linked information. Would you like to update those links?"

The easiest way to do it is to have both sheets open at the same time.
Select the reference cell in the time sheet and place in a =; then click on
the cell you are wanting from the job sheet. You can do the same thing with
drop down lists.

LWhite
 

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

Back
Top