Home |
Search |
Today's Posts |
#1
|
|||
|
|||
I need help with recalling information
Howdy all, I am attempting to make a Timesheet work book where people could log their hours and such. One thing it has to be able to do is recall a list of current jobs so that employees can list which jobs they were working on. It would be ideal if this job data file were on our server computer so that if changes need to be made to it all users would get an updated job file each time they ran the worksheet. Can information on a seperate workbook be accessed over the network in the manner which i'm looking to accomplish? I'm fairly new to all of excel, i believe that is the only question i have for now. Thanks everyone. -Akira -- Akira5284 ------------------------------------------------------------------------ Akira5284's Profile: http://www.excelforum.com/member.php...o&userid=23985 View this thread: http://www.excelforum.com/showthread...hreadid=376758 |
#2
|
|||
|
|||
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 "Akira5284" wrote in message ... Howdy all, I am attempting to make a Timesheet work book where people could log their hours and such. One thing it has to be able to do is recall a list of current jobs so that employees can list which jobs they were working on. It would be ideal if this job data file were on our server computer so that if changes need to be made to it all users would get an updated job file each time they ran the worksheet. Can information on a seperate workbook be accessed over the network in the manner which i'm looking to accomplish? I'm fairly new to all of excel, i believe that is the only question i have for now. Thanks everyone. -Akira -- Akira5284 ------------------------------------------------------------------------ Akira5284's Profile: http://www.excelforum.com/member.php...o&userid=23985 View this thread: http://www.excelforum.com/showthread...hreadid=376758 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copying information from multiple worksheets into one | Excel Discussion (Misc queries) | |||
Aggregating categorized information from several worksheets | Excel Worksheet Functions | |||
Update a spreadsheet with new information. | Excel Discussion (Misc queries) | |||
Clearing information in certain columns | Excel Discussion (Misc queries) | |||
Sharing information between Access and Excel | Excel Discussion (Misc queries) |