HI,

I do a lot of auto filtering and need my clients name that is first in the filter to be copied into cell A400.

but as each filter gives me a different First row I dont know how to do this?

for example if i filter june its row 200 thats the first on the sheet but January would be row 2, but i need it to input into A400 the data In A thats first once the filter has been done?

any ideas?