The first available colmn is BD
But, I'm sure I understand what am to. Could you explain a little more for me

"Sheeloo" wrote:

Sorry
Use $BD6 instead of $BD3

"Sheeloo" wrote:

Mike,

You can do the following;
In the first unused column enter the formula
=Row()-3
and copy down. Then copy this column and paste special as values on itself.

Suppose this column is BD then in your formula replace
(ROW()-3)by
$BD3

Now you can sort your data... just include Col BD in your range.

Let me know how it goes...




Then in the formula


"Mike" wrote:

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))