If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Help with looking up information
I have been given the following problem to resolve in Excel and require some
help: I have a Master Job sheet where I am to input information on Job Numbers, which uses VLOOKUPs to find out the job description and start and end date. This informaiton is then filtered through to a sheet where an individual job number is typed in and VLOOKUPs are used to pull through the start and end date again, however I have been asked to pull out the following information from the Master Sheet: Type of Work1 Date, Type of work, Staff, Hours Type of Work2 Date, Type of work, Staff, Hours Type of Work3 Date, Type of work, Staff, Hours I have no idea of where to start pulling this information through. My problem is that there are multiple entries (by date) per job number and VLOOKUPs will not work. Any ideas? The Master Job sheet is purely an input sheet and items are added as they occur. Hopefully someone can help. Thanks |
#2
|
|||
|
|||
Help with looking up information
It sounds like yo will need a macro to perform the task rather than a lot of
formulas. look at the Excel programming postings for some ideas. "Needing Help" wrote: I have been given the following problem to resolve in Excel and require some help: I have a Master Job sheet where I am to input information on Job Numbers, which uses VLOOKUPs to find out the job description and start and end date. This informaiton is then filtered through to a sheet where an individual job number is typed in and VLOOKUPs are used to pull through the start and end date again, however I have been asked to pull out the following information from the Master Sheet: Type of Work1 Date, Type of work, Staff, Hours Type of Work2 Date, Type of work, Staff, Hours Type of Work3 Date, Type of work, Staff, Hours I have no idea of where to start pulling this information through. My problem is that there are multiple entries (by date) per job number and VLOOKUPs will not work. Any ideas? The Master Job sheet is purely an input sheet and items are added as they occur. Hopefully someone can help. Thanks |
#3
|
|||
|
|||
Help with looking up information
Perhaps:
http://office.microsoft.com/en-us/ex...260381033.aspx -- Gary''s Student - gsnu200850 "Needing Help" wrote: I have been given the following problem to resolve in Excel and require some help: I have a Master Job sheet where I am to input information on Job Numbers, which uses VLOOKUPs to find out the job description and start and end date. This informaiton is then filtered through to a sheet where an individual job number is typed in and VLOOKUPs are used to pull through the start and end date again, however I have been asked to pull out the following information from the Master Sheet: Type of Work1 Date, Type of work, Staff, Hours Type of Work2 Date, Type of work, Staff, Hours Type of Work3 Date, Type of work, Staff, Hours I have no idea of where to start pulling this information through. My problem is that there are multiple entries (by date) per job number and VLOOKUPs will not work. Any ideas? The Master Job sheet is purely an input sheet and items are added as they occur. Hopefully someone can help. Thanks |
#4
|
|||
|
|||
Help with looking up information
Thanks for that, it looks like it could work. I just need to have a go at
writing up a formula which works. "Gary''s Student" wrote: Perhaps: http://office.microsoft.com/en-us/ex...260381033.aspx -- Gary''s Student - gsnu200850 "Needing Help" wrote: I have been given the following problem to resolve in Excel and require some help: I have a Master Job sheet where I am to input information on Job Numbers, which uses VLOOKUPs to find out the job description and start and end date. This informaiton is then filtered through to a sheet where an individual job number is typed in and VLOOKUPs are used to pull through the start and end date again, however I have been asked to pull out the following information from the Master Sheet: Type of Work1 Date, Type of work, Staff, Hours Type of Work2 Date, Type of work, Staff, Hours Type of Work3 Date, Type of work, Staff, Hours I have no idea of where to start pulling this information through. My problem is that there are multiple entries (by date) per job number and VLOOKUPs will not work. Any ideas? The Master Job sheet is purely an input sheet and items are added as they occur. Hopefully someone can help. Thanks |
Thread Tools | |
Display Modes | |
|
|