Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Help!! using sheet 1 information to change information on sheet 2 | Excel Worksheet Functions | |||
Need information .... | Excel Discussion (Misc queries) | |||
information | Excel Discussion (Misc queries) | |||
NEED INFORMATION | Excel Discussion (Misc queries) | |||
Information | Excel Discussion (Misc queries) |