I would like to filter 100 excel sheets with some kind of macro?

Question

I have about 100 excel sheets of music fans who have entered in their information.

The fields are: First Name, Last Name,Street Address, City,State, Zip Code,E-mail,Birth Month, Birth Day, Birth Year,Date,Artist,Venue,Venue City,Venue State.

I would like to know how many fans I have captured per excel sheet, and the total averages of birthdays, i.e. how many people are in the range of 12-17, 18-24, 25-34, 34-44, 45-54).

Thanks.

Answer 1

The fastest way to count how many things are on a sheet is to select the whole group with the mouse, and right click at the bottom of the screen where it says Sum= and change it to Count.

If you want that number to actually be on the sheet and calculate automatically, even if rows are added later, then you have to look up the count function in help (its on the function wizard--the button with fx on it). That'll take care of task 1, and show you things that could come in handy for the other part.

If you want your exact age groups, you'll have to do a vertical lookup. Put it in help and it'll explain how. Basically, you will need a formula that calculates the age group of someone based on birthday, that will then look up the age on the table and return the name of the age group. You can then sort by age group and count, or use one of the conditional count functions.

Answer 2

i be attentive to excel yet not VB. Why do you will possibly desire to repeat to a report of the comparable call? In different applications, commonly that promises a topic. attempt coping to a various call worksheet and in case you like this actual call itself, then close the 1st worksheet and rename the recent worksheet to in spite of the call you like. wish this might help