vloopup and data vadilation

V

vcff

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
 
V

vcff

sorry I miss out another point

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

vlookup with dropdown list 2
VBA Coding Help for Beginner 0
Filter and copy info from one sheet to another 0
vlookup with dropdown list 3
transformed vloopup 2
reverse pasting rows with alternate blank cells 0
Advanced(!) Ranking 1
Converting text to cell reference and column letters to numbers -please help 6

Top