Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Find last column, move formulas over, copy/paste data | Excel Worksheet Functions | |||
Lookup and Move Data Function Help | Excel Worksheet Functions | |||
Move C5 to C10 in Excell (no cut/ copy/ paste)? | Excel Discussion (Misc queries) | |||
If found, then copy and paste contents, otherwise move on | Excel Programming | |||
lookup,copy, paste macro?? | Excel Programming |