Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
Windows XP Pro - Drywall Company with 40 crews
I have a minor/major problem. My goal is as such: I have created a workbook containing all 40 of my hanging and taping crews (one file HANGERS with about 25 tabs/worksheets & one file TAPERS with about 15 tabs/worksheets) These sheets have 4 columns (1-conctractor)(2-job address)(3-amount of pay for that job)(4-date paid) I have also created a workbook containing the following: worksheet 1 - contract for specific job worksheet 2 - preparation sheet for job worksheet 3 - paysheet for guys* *This is one of the worksheet in question the paysheets for guys contains several fields of information in the first column there is the Hangers name the column below that has the Tapers name in the top right hand corner on the top column is the contractor below that is the address below that is the city below that is the job number and information below this top section mentioned consists of all specifications for the specific job. QUESTION: Is there a way that I can export (not sure terminology) specific information from the paysheet to a specific file (i.e. HANGER/TAPER) then to a specific worksheet with in the file with specific data from the paysheet EXAMPLE: PAYSHEET- Hanger: David 11/30 start Great Builders Tape: Thomas 12/5 start 134 Excel Dr. 12/9 finish Eastville, MI Job # 4567 Hang: $ 1294.65 + 350 Tape: $ 1294.65 + 350 Amt sheets: 189 (other job specific information below nothing to do with question) HANGER/TAPER PAY DATABASE WORKBOOK - 25 worksheets within the file each worksheet contains crew leader's name on tab HANGER/TAPER DATABASE WORKSHEET - CONTRACTOR JOB ADDRESS AMOUNT PAID Great Builders 134 Excel Dr. 1294.65+350 12/9 {tab: david} CONTRACTOR JOB ADDRESS AMOUNT PAID Great Builders 134 Excel Dr. 1294.65+350 12/14 {tab: thomas} i only want to have to enter this information once on the paysheet and have it automatically export information to the HANGER/TAPER DATABASE WORKSHEET as is above exporting only content specific information from the paysheet but also to the specified Hanger or Taper IS THIS POSSIBLE??? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
How can I use Excel as a simple database for Quoting? | Excel Discussion (Misc queries) | |||
Query a Access database that has a module from Excel | Excel Discussion (Misc queries) | |||
Creating GIFs in Excel 2003 for use in Dreamweaver | Charts and Charting in Excel | |||
How to use a Access Query that as a parameter into Excel database query | Excel Discussion (Misc queries) |