How do I copy the visible special cells one row at a time?

Pasty

Board Regular
Joined
Mar 26, 2007
Messages
96
I need to copy some information that has been filtered. I need information from 3 of the cells in a row and then paste it to another sheet BUT I need it to move it to the new sheet on at a time so whereas each action in the filtered sheet is going down in rows the pieces of information I am going to copy are all in the same row but follow one after another in the columns for example:

The filtered sheet looks like

Governance Report Actions Priority/Importance/Risk

and many more other columns and I need to copy for example the governance report and actions cells to another sheet and paste it on the end of the row and then go to the next row on the filtered sheet and copy this and then paste it on the end again.

If I am being unclear just let me know.
 

Excel Facts

Why are there 1,048,576 rows in Excel?
The Excel team increased the size of the grid in 2007. There are 2^20 rows and 2^14 columns for a total of 17 billion cells.

Forum statistics

Threads
1,181,420
Messages
5,929,801
Members
436,696
Latest member
Mr Rice

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top