Filter Sort Columns in a table.


M

Mike

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
 
Ad

Advertisements

S

Shane Devenshire

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.
 
M

Mike

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
 
Ad

Advertisements

M

Mike

Hi Shane,

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top