Dynamic Data Validation

Cooki

New Member
Joined
Jul 31, 2018
Messages
30
Hi All is it possible to do a dynamic validation list using data from multiple sheets.

I have a front page and 4 identical sheets, just with different sheets names.

I need to be able to have the list of all names in B3:B75 from each sheet in 1 list, also needs to ignore any blanks.

Working on the below but cant get it to work, excel tells me it can only be from 1 sheet.

=OFFSET(Commish_Q1!$B$3,0,0,COUNTA(Commish_Q1!B3:B75),COUNTA(Commish_Q2!B3:B75),COUNTA(Commish_Q3!B3:B75),COUNTA(Commish_Q4!B3:B75)))))

Any help would be greatly appriciated
 

Some videos you may like

Excel Facts

Why does 9 mean SUM in SUBTOTAL?
It is because Sum is the 9th alphabetically in Average, Count, CountA, Max, Min, Product, StDev.S, StDev.P, Sum, VAR.S, VAR.P.

Cooki

New Member
Joined
Jul 31, 2018
Messages
30
I will check this out, but my laptop has packed it, so fixing atm.

Thank you for replying
 

Watch MrExcel Video

Forum statistics

Threads
1,099,090
Messages
5,466,576
Members
406,490
Latest member
Ankusharma

This Week's Hot Topics

Top