I have posted this question previously.

This is my last attempt to see if someone has another formula that works...

I have a table in a worksheet with column headings in 5A through 5BC each
transaction is entered in rows, starting with row 6 through row 250. The
Filter is turned on in the column headings. When I click on the arrow I can
choose a filter sort. Does the formula prevent the Sort Choice???
When I do nothing happens.

If I copy the sheet to another sheet and paste
using Special Paste and paste only Values and Number Formats the filter and
sort works perfectly.

Below are two formulas we tryed but don't allow the Sort.

=INDEX(INDIRECT("'Transaction
Database'!R5C"&(ROW()-3)&":R59C"&(ROW()-3),FALSE),COLUMN())

=INDIRECT("'transaction database'!"&ADDRESS(COLUMN()+4,(COLUMN())+ROW()-4))