Dynamic Data Validation

Cooki

New Member
Joined
Jul 31, 2018
Messages
18
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
 

Cooki

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

Thank you for replying
 

Forum statistics

Threads
1,077,731
Messages
5,335,893
Members
399,056
Latest member
CityGirlLuv

Some videos you may like

This Week's Hot Topics

Top