Filter Sort Columns in a table.
 

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. Do the formulas prevent the filtering???
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.

What am I doing wrong???

Thanks, Mike

Filter Sort Columns in a table.
 

Hi,

The filters have no problem with formulas, but the sort command does.

You will need to show us a sample of your formulas so we can make addtional
suggestions. Sometimes there are work arounds for this problem.

--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"Mike" wrote:

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. Do the formulas prevent the filtering???
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.

What am I doing wrong???

Thanks, Mike

Filter Sort Columns in a table.
 

Hi Shane,
This is the formula in A6
=INDIRECT("'transaction database'!"&ADDRESS(COLUMN()+4,(COLUMN())+ROW()-4))
This is the formula in A7
=INDIRECT("'transaction database'!"&ADDRESS(COLUMN()+4,(COLUMN())+ROW()-5))
The only change in the formula in the row is the last #-6, -7, -8, etc

Then the entire row is copy and pasted down to row 250.

Hope this helps!

Thanks, Mike



"Shane Devenshire" wrote:

Hi,

The filters have no problem with formulas, but the sort command does.

You will need to show us a sample of your formulas so we can make addtional
suggestions. Sometimes there are work arounds for this problem.

--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"Mike" wrote:

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. Do the formulas prevent the filtering???
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.

What am I doing wrong???

Thanks, Mike

Filter Sort Columns in a table.
 

Hi Shane,

Did you receive the formula examples, Can I send you anything further???

"Shane Devenshire" wrote:

Hi,

The filters have no problem with formulas, but the sort command does.

You will need to show us a sample of your formulas so we can make addtional
suggestions. Sometimes there are work arounds for this problem.

--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"Mike" wrote:

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. Do the formulas prevent the filtering???
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.

What am I doing wrong???

Thanks, Mike