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.
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.