Thread: Sort Data from Master to Customized Tabs

I like to think I'm pretty good at Excel since I use it in the Army all the time. However, I also live on my family farm and we're trying to digitize all our information for tax purposes.

I have a worksheet with five columns: date, customer name, commodity, add't details, and cost. Then I have a separate cell that calculates the total.

I have drop down lists for each column so if I want to just see "corn", I can sort it out and only see the "corn" entries. Unfortunately, when I do that the total cost cell disappears or continues to show the total cost of the entire workbook, including the hidden rows.

I've created separate worksheets that would like to clone drop down functions. For example, I would like rows with "corn" entries only to be visible in the "corn" worksheet along with a total cost. Or, at the very least, when I click on "corn" in the drop down list for that column, the number in "total" cell only shows the total cost of all "corn" entries.

I hope that makes sense. Can anyone help? If it's easier to do over the phone or email, let me know.

CJ

Attached should be a copy since I suck at explaining.

Hi chcknhawk

Welcome to the forum

You could use

=SUBTOTAL(9,E2:E489)

at the bottom of the column