Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old December 19th 06, 01:00 PM posted to microsoft.public.excel.setup
external usenet poster
 
First recorded activity by ExcelBanter: Dec 2006
Posts: 9
Default Cut and Paste Only Non-Hidden Rows

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

  #2   Report Post  
Old December 19th 06, 01:05 PM posted to microsoft.public.excel.setup
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 1,173
Default Cut and Paste Only Non-Hidden Rows

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


  #3   Report Post  
Old December 19th 06, 01:20 PM posted to microsoft.public.excel.setup
external usenet poster
 
First recorded activity by ExcelBanter: Dec 2006
Posts: 9
Default Cut and Paste Only Non-Hidden Rows

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



  #4   Report Post  
Old December 19th 06, 01:28 PM posted to microsoft.public.excel.setup
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 1,173
Default Cut and Paste Only Non-Hidden Rows

Happens to me *every* day. (several times today), just glad you got it done

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
DTHIS
www.nickhodge.co.uk


"Fishman4" wrote in message
...
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




  #5   Report Post  
Old December 19th 06, 08:45 PM posted to microsoft.public.excel.setup
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 22
Default Cut and Paste Only Non-Hidden Rows

Or you could try the built-in feature to do exactly that... "copy visible".

Select your data, then press F5, select "Special", then select the button
for "Visible Cells Only".

You can add this to your menu bar if you use it alot...


"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





Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT +1. The time now is 10:37 PM.

Powered by vBulletin® Copyright ©2000 - 2021, Jelsoft Enterprises Ltd.
Copyright 2004-2021 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017