Paste data to a filtered column, pasting to visible cells only

S

Shinka

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?
 
D

Dave Peterson

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

COPY PASTE VALUES ONLY FROM/ON VISIBLE CELLS 6
To paste copied data in filtered/visible cells only 1
Pasting into a filtered sheet 3
Paste to Visible Cells only 1
copy and paste filtered cells 1
CONDITIONAL SUM FOR ONLY VISIBLE CELLS 1
Copying and pasting to visible cells only 4
How to copy and paste only visible cells from Excel using vbscript 0

Top