Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Good day i am struggling here and need some help fast, i am trying to
populate some cells with data based on certain conditions. If i select certain Project via drop down menu i want the work sheet to be populated with data only relative to that Project. Can anyone help me please with example???? Thanks a million |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Your description is pretty vague, but a suggestion...
Say your dropdown is in cell A1 of sheet1 and your project data table is in Sheet2, columns A:J, with the project name in column A (which you could then use as the list for your dropdown, if you wanted). Then in Sheet1, enter: B1: =VLOOKUP(A1,Sheet2!$A:$J),2,FALSE) C1: =VLOOKUP(A1,Sheet2!$A:$J),3,FALSE) .... J1: =VLOOKUP(A1,Sheet2!$A:$J,10,FALSE) Change references to suit. In article , whatzzup wrote: Good day i am struggling here and need some help fast, i am trying to populate some cells with data based on certain conditions. If i select certain Project via drop down menu i want the work sheet to be populated with data only relative to that Project. Can anyone help me please with example???? Thanks a million |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
VB Macro to Populate Row from J30 | Excel Discussion (Misc queries) | |||
Populate a form | Excel Worksheet Functions | |||
Populate y col from x col values | Excel Discussion (Misc queries) | |||
Auto populate with value | Excel Discussion (Misc queries) | |||
auto populate | Excel Discussion (Misc queries) |