Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Workbook Formulas
I hope I explain this right! I need to create a master worksheet in a
workbook that has several columns related to different descriptors of projects. Each project description takes up a row and about ten different columns with field information containing due dates, description of project, project manager, etc. The first column would ideally be filled in with key words, letters or numbers that corresponded to a different project type (environmental, water, contaminated sites, etc) so that in the other worksheets, if the numbers/letters in the master worksheet applied to those different worksheets (each one a different type of project), the information in the entire row would automatically transfer over to the worksheets each row correlated with. So if you entered information into the master worksheet and the project dealt with three different project types, all of the information would transfer into the three worksheets according to type??? -- KLW |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Workbook Formulas
In sheet2 and subsequent sheets try VLOOKUP...
--MAster sheet contains the key number in ColA and info....in subsequent columns --Sheet2 Col A contain the key number Enter the below formula in Sheet2 B2; will return the second column information... =VLOOKUP(A2,Master!A1:J100,2,FALSE) The below will return the 3rd row info =VLOOKUP(A2,Master!A1:J100,3,FALSE) If this post helps click Yes --------------- Jacob Skaria "KLW" wrote: I hope I explain this right! I need to create a master worksheet in a workbook that has several columns related to different descriptors of projects. Each project description takes up a row and about ten different columns with field information containing due dates, description of project, project manager, etc. The first column would ideally be filled in with key words, letters or numbers that corresponded to a different project type (environmental, water, contaminated sites, etc) so that in the other worksheets, if the numbers/letters in the master worksheet applied to those different worksheets (each one a different type of project), the information in the entire row would automatically transfer over to the worksheets each row correlated with. So if you entered information into the master worksheet and the project dealt with three different project types, all of the information would transfer into the three worksheets according to type??? -- KLW |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
2 formulas needed same workbook | Excel Worksheet Functions | |||
Formulas in my Workbook | Excel Worksheet Functions | |||
COpy formulas from one workbook to another workbook | Excel Discussion (Misc queries) | |||
Copying Formulas from Workbook to Workbook | Excel Discussion (Misc queries) | |||
Workbook formulas | Excel Worksheet Functions |