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

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

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

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