Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Populate excel sheet based on values in a separate sheet
I am trying to populate an excel sheet ('Actuals') based on values in another
excel sheet ('Budget') in the same file. When the Week Number is chosen, from drop down list (based on 'Budget') I need certain columns to populate. For example if user chooses Week 1, I need Column C, F and J on the 'Actuals' sheet to read Y but if week 4 is choosen, Coumns D,I, M and N will be Y. How can I make this happen? Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Split text file into Excel sheet and separate the final results intoa new sheet | Excel Worksheet Functions | |||
Retriving Values from a separate sheet of a different file | Excel Worksheet Functions | |||
How to populate prices in sheet two based on cost in sheet one | Excel Worksheet Functions | |||
Populate worksheets based on a master sheet | Excel Worksheet Functions | |||
Can Excel calculate populate table using row/column values & calc's on other sheet? | Excel Discussion (Misc queries) |