lookup and copy data and move it upwards and paste

S

sverre

Hi

Here is what I would like to do:

Following procedure should repeat as long as F is nonempty:

1) Find " ----------------------" in col F
2)move down one row and select cells in col F-H
3) Copy data
4) move two columns left
6 find next empty cell ABOVE in this column. move there
7)move two columns to the right
8 )paste data
9 Delete rows where col D is empty
br
Sverre
 

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

Top