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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Populate excel sheet based on values in a separate sheet
Andi
When you say "Columns C, F, I" populated, do you mean the whole column? Or maybe just one row? What row? Provide more detail about the layout of what you have and what you want to do. Otto HTH "Andi" wrote in message ... 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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Populate excel sheet based on values in a separate sheet
I do mean only the matching row of these columns. Basically what I want to
do is have a User chose a week and based on that week display the tasks that need to be completed. If User picks week one, then Questionaire 1, 2 and 4 must be completed. If this is week two, Questionnaire 3,5 and 6 must be completed. The schedule (and monetary value) are stored in the Budget Sheet set up like this: Cost Week1 Week2 Week4 Week6 Q1 $105 x x Q2 $95 x x Q3 $75 x Q4 $150 x Q5 $75 x Q6 $75 x Q7 $75 x PI $175 x x x x So if Week1 is entered in the "Actual' sheet I need Q1, Q2 and Q4 to be marked as specified in the budget table: WeekNum Q1 Q1Complete Q2 Q2Complete Q3 Q3 complete ........... Week1 x x Week2 x "Otto Moehrbach" wrote: Andi When you say "Columns C, F, I" populated, do you mean the whole column? Or maybe just one row? What row? Provide more detail about the layout of what you have and what you want to do. Otto HTH "Andi" wrote in message ... 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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Populate excel sheet based on values in a separate sheet
I figured this one out using the HLOOKUP command.
"Andi" wrote: I do mean only the matching row of these columns. Basically what I want to do is have a User chose a week and based on that week display the tasks that need to be completed. If User picks week one, then Questionaire 1, 2 and 4 must be completed. If this is week two, Questionnaire 3,5 and 6 must be completed. The schedule (and monetary value) are stored in the Budget Sheet set up like this: Cost Week1 Week2 Week4 Week6 Q1 $105 x x Q2 $95 x x Q3 $75 x Q4 $150 x Q5 $75 x Q6 $75 x Q7 $75 x PI $175 x x x x So if Week1 is entered in the "Actual' sheet I need Q1, Q2 and Q4 to be marked as specified in the budget table: WeekNum Q1 Q1Complete Q2 Q2Complete Q3 Q3 complete ........... Week1 x x Week2 x "Otto Moehrbach" wrote: Andi When you say "Columns C, F, I" populated, do you mean the whole column? Or maybe just one row? What row? Provide more detail about the layout of what you have and what you want to do. Otto HTH "Andi" wrote in message ... 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 |
Reply |
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) |