Create a data validation list from a range which has data appearing in multiple rows. I have shown two cases – one using macros and other using formulas. The question and solution have been explained in this workbook.
Read More →
Tags: COUNTA
Split data into multiple tabs
{ 325 Comments }
Assume a four column database with department as the second column. Entries in the department column may be repeated. A person may wish to create one worksheet tab for each department. Therefore, as and when a person names a worksheet tab as one of the departments, all rows of that department should appear on this new sheet. You […]
Read More →
Validation source list to resize automatically
{ 6 Comments }