Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 78
Default lookup and copy data and move it upwards and paste

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


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Find last column, move formulas over, copy/paste data Mike R. Excel Worksheet Functions 0 September 19th 07 06:40 AM
Lookup and Move Data Function Help naiku Excel Worksheet Functions 3 May 26th 06 12:29 AM
Move C5 to C10 in Excell (no cut/ copy/ paste)? kandieclaire Excel Discussion (Misc queries) 1 May 25th 05 08:44 AM
If found, then copy and paste contents, otherwise move on Dave Peterson[_3_] Excel Programming 0 September 11th 04 12:53 AM
lookup,copy, paste macro?? Hugh Askew Excel Programming 3 May 1st 04 01:21 PM


All times are GMT +1. The time now is 06:44 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"