I must have fooled around with this for an hour. I feel like an idiot. I
guess I couldn't see the forest for the trees.
Thanks Nick
Don F.
--
Fishman4
"Nick Hodge" wrote:
Don
Copy instead of cut, then return to your filter and press the delete key and
sort. This will leave just the filtered data.
Hope I understand
--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
DTHIS
www.nickhodge.co.uk
"Fishman4" wrote in message
...
I run a report every week that is exported to EXCEL. Once there, I check
the
listed data against hard copy records that we keep and if the hard copy is
present, I enter the date that record was generated in a corresponding
column
in my spreadsheet. Every time I run the report, I add it to the same
sheet
and it is getting very long. To manage this, I use the autofilter
function
to display only the rows with the date column containing information (all
non
blanks). Then, I cut the displayed data and paste it into another sheet.
The problem is, when I do the cut, it cuts the displayed information as
well
as the hidden information. Is there a way to leave the hidden info and
cut
only the displayed info? Or even create a macro that will automatically
move
the row that has this column populated? That would make me an even bigger
hero. Thanks in advance for your condideration.
Don F.
--
Fishman4