dynamic update

I have data in a spreadsheet, called volunteers. In the last 5 columns are a series of Yes/No responses, such as "Call Voters", "Work the polls", "Fundraise" etc. What I would like to do is create individual sheets based on data culled from the main sheet (volunteers), so sheet 2 would consist...

Hi Everyone, I was hoping someone could help with Excel task I have been struggling with the past few days. Here is the setup: 1) I have a 8 worksheets in one excel workbook that contain 15 different columns each. The worksheets are identical, but contain different data. (They are from data...

Hello; I want to do a drop-down menu that depends on another drop-down menu. Besides, the list should be dynamic, i.e., I should be able to add more elements. I use the name manager and add the =OFFSET(...;0;0;COUNTA(...)) do make the lists dynamic. I don't know why, but it doesn't work. I...