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
|