I have a data base in a worksheet from cell AM2:AY605 (use for data
vadilation, which require the data to be under the same worksheet).

I have some formulas in the follwoing cells which help me to extract the
info .

AI : data vadilation for a dropown list of names under AM2:AM605 (for A1 :
A20)
B1 : =IF(A1="","",VLOOKUP(A1,AM2:AY605,2,0))
C1 : =IF(A1="","",VLOOKUP(A1,AM2:AY605,3,0))
D1 : =IF(A1="","",VLOOKUP(A1,AM2:AY605,6,0))
E1 : problem for me here

in E1, base on A1 selection, I will like to have a dropdown list to select
the info under AT1:AW1

As there are a total of 31 worksheets, representing 31 days, I need to have
the data info on every worksheet in order for the Data Vadilation to function
in column A.
Is there a way where I can put the data on a single worksheet and to extract
the info from there.

Help will be greatly appreciated.

Regards
vcff

sorry some correction

"vcff" wrote:

I have a data base in a worksheet from cell AM2:AY605 (use for data
vadilation, which require the data to be under the same worksheet).

I have some formulas in the follwoing cells which help me to extract the
info .

AI : data vadilation for a dropown list of names under AM2:AM605 (for A1 :
A20)
B1 : =IF(A1="","",VLOOKUP(A1,AM2:AY605,2,0))
C1 : =IF(A1="","",VLOOKUP(A1,AM2:AY605,3,0))
D1 : =IF(A1="","",VLOOKUP(A1,AM2:AY605,6,0))
E1 : problem for me here

in E1, base on A1 selection, I will like to have a dropdown list to select
the info under AT1:AW1

F1 : base on E1 selection, have another dropdown list (info from AX1:AY1)

As there are a total of 31 worksheets, representing 31 days, I need to have
the data info on every worksheet in order for the Data Vadilation to function
in column A.
Is there a way where I can put the data on a single worksheet and to extract
the info from there.

Help will be greatly appreciated.

Regards
vcff

sorry I miss out another point

F1 : will depend on E1 selection and refer to a dropdown list fROm AX1 :AY1

"vcff" wrote:

I have a data base in a worksheet from cell AM2:AY605 (use for data
vadilation, which require the data to be under the same worksheet).

I have some formulas in the follwoing cells which help me to extract the
info .

AI : data vadilation for a dropown list of names under AM2:AM605 (for A1 :
A20)
B1 : =IF(A1="","",VLOOKUP(A1,AM2:AY605,2,0))
C1 : =IF(A1="","",VLOOKUP(A1,AM2:AY605,3,0))
D1 : =IF(A1="","",VLOOKUP(A1,AM2:AY605,6,0))
E1 : problem for me here

in E1, base on A1 selection, I will like to have a dropdown list to select
the info under AT1:AW1

As there are a total of 31 worksheets, representing 31 days, I need to have
the data info on every worksheet in order for the Data Vadilation to function
in column A.
Is there a way where I can put the data on a single worksheet and to extract
the info from there.

Help will be greatly appreciated.

Regards
vcff