hello
I have a wb that contains a shet of all my data and then when a certain sheet is selected i have a comand that:
Copys All data
Pastes all data in selected sheet
Filters specific data for that selected sheet.

I need to be able to chart the last 200 enteries on a third sheet.
I have tried multiple formulas but it appears that the program is still recognizing that there is data in the empty cells that have been filtered out.
Im not sure if i should use a formula or a comand.

Please let me know if you can help
I can provide a sample wb if needed
Thankyou!