Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
paste data over hidden cells that are filtered | Excel Worksheet Functions | |||
countif only visible cells (filtered) | Excel Worksheet Functions | |||
Copy visible cells on Filtered data | Excel Discussion (Misc queries) | |||
Paste Data into Contiguous (Visible) Cells | New Users to Excel | |||
Pasting on Filtered Data Sheets without pasting onto hidden cells | Excel Discussion (Misc queries) |