Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 6
Default Paste data to a filtered column, pasting to visible cells only

I have a spreadsheet of several regions, with the same measurements in each
Region. A number of people send me the specific measurements they are
responsible for in the same Region order. I'd like to filter on the
measurement, and then copy and paste. When I do so, it copies to the hidden
cells. Any way I can get it to copy to just the visible cells?
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 964
Default Paste data to a filtered column, pasting to visible cells only

Not possible

--


Regards,


Peo Sjoblom

"Shinka" wrote in message
...
I have a spreadsheet of several regions, with the same measurements in each
Region. A number of people send me the specific measurements they are
responsible for in the same Region order. I'd like to filter on the
measurement, and then copy and paste. When I do so, it copies to the
hidden
cells. Any way I can get it to copy to just the visible cells?



  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 6
Default Paste data to a filtered column, pasting to visible cells only

Are you sure? This seems like such a useful thing to be able to do..

"Peo Sjoblom" wrote:

Not possible

--


Regards,


Peo Sjoblom

"Shinka" wrote in message
...
I have a spreadsheet of several regions, with the same measurements in each
Region. A number of people send me the specific measurements they are
responsible for in the same Region order. I'd like to filter on the
measurement, and then copy and paste. When I do so, it copies to the
hidden
cells. Any way I can get it to copy to just the visible cells?




  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 35,218
Default Paste data to a filtered column, pasting to visible cells only

I like to sort my data to group all the rows that would be visible. Then I can
just paste to those visible rows.

And then I resort it to its "natural" order.

Shinka wrote:

Are you sure? This seems like such a useful thing to be able to do..

"Peo Sjoblom" wrote:

Not possible

--


Regards,


Peo Sjoblom

"Shinka" wrote in message
...
I have a spreadsheet of several regions, with the same measurements in each
Region. A number of people send me the specific measurements they are
responsible for in the same Region order. I'd like to filter on the
measurement, and then copy and paste. When I do so, it copies to the
hidden
cells. Any way I can get it to copy to just the visible cells?





--

Dave Peterson
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


Similar Threads
Thread Thread Starter Forum Replies Last Post
paste data over hidden cells that are filtered derwood[_2_] Excel Worksheet Functions 1 March 9th 08 03:11 AM
countif only visible cells (filtered) [email protected] Excel Worksheet Functions 8 August 16th 07 04:39 PM
Copy visible cells on Filtered data [email protected] Excel Discussion (Misc queries) 4 July 18th 07 08:18 AM
Paste Data into Contiguous (Visible) Cells trev_sk8r New Users to Excel 1 June 16th 06 10:04 PM
Pasting on Filtered Data Sheets without pasting onto hidden cells CCSMCA Excel Discussion (Misc queries) 1 August 28th 05 01:22 PM


All times are GMT +1. The time now is 11:16 PM.

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

About Us

"It's about Microsoft Excel"