|
|
|
|
|||||
|
|
|
|
|
|
|||
| Welcome
to Tech Support Forum home to more then 136,000 problems solved. Issues
have included: Spyware, Malware, Virus Issues, Windows, Microsoft,
Linux, Networking, Security, Hardware, and Gaming Getting your
problem solved is as easy as: 1. Registering for a free account 2. Asking your question 3. Receiving an answer Registered members: * See fewer ads. * And much more..
|
| Want to know how to post a question? click here | Having problems with spyware and pop-ups? First Steps |
|
|||||||
| Microsoft Office support MS Office support forum |
 |
|
|
LinkBack | Thread Tools |
10-21-2008, 11:51 AM
|
#1 (permalink) |
|
Registered User
Join Date: Oct 2008
Posts: 9
OS: Windows XP SP3, Debian Stable
|
Excel spreadsheet grabs data from another sheet?
Microsoft Office / Excel 2003
I am new here. There is a timecard system set up by a previous employee using Excel. Two excel spreadsheets. JOBS.xls Timesheet.xlt Timesheet.xlt is a template. It contains dropdown lists of jobs that are grabbed from JOBS.xls, apparently. The system is broken, and Timesheet.xlt is not grabbing items from JOBS.xls properly anymore. The jobs in the list on Timesheet.xlt are old. There are no macros in the list of macros. I don't know much about Excel, and I don't know how this works. I need to find out so I can fix the problem. 
|
|
     
|
| Important Information |
|
Join the #1 Tech Support Forum Today - It's Totally Free!
TechSupportForum.com is a leading support website for your computer needs. We offer free, friendly and personalized computer support. Why pay to have your computer fixed when you can do it for free. Join TechSupportforum.com Today - Click Here |
|
10-22-2008, 01:08 AM
|
#2 (permalink) |
|
Registered User
Join Date: Oct 2008
Location: Australia
Posts: 51
OS: Vista Home Basic
 |
Re: Excel spreadsheet grabs data from another sheet?
G'day,
If you follow the link it has all the information you need in fixing the problem. http://www.contextures.com/xlDataVal05.html Or it could be as simply updating the link between the two workbooks. Let me know if you have any problems with it Cheers |
|
|
|
|
| Thread Tools | |
|
|
