Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Cut & Paste Loop
I am just learning about Excel VBA on a project.
I have a very long spreadsheet of data to format from one column. How would I automate the following? "Search for a phone number, cut whole cell, paste it up two rows and over 3 columns. Find next phone number... repeat..." I will also be using this to move addresses... "Search for address containing this string, cut whole Cell, paste up 1 row, and over 6. Find next Address." Thanks in advance ============================ Allan |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Cut & Paste Loop
this should give you the idea
Sub moveover()' moves over 3 columns & up 2 rows For Each c In Selection c.Cut c.Offset(-2, 3) Next End Sub -- Don Guillett SalesAid Software "Allan" wrote in message news:qpSTb.386293$JQ1.37622@pd7tw1no... I am just learning about Excel VBA on a project. I have a very long spreadsheet of data to format from one column. How would I automate the following? "Search for a phone number, cut whole cell, paste it up two rows and over 3 columns. Find next phone number... repeat..." I will also be using this to move addresses... "Search for address containing this string, cut whole Cell, paste up 1 row, and over 6. Find next Address." Thanks in advance ============================ Allan |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VBA Loop to Find then Copy & Paste | Excel Discussion (Misc queries) | |||
Loop Statement through If Not IsEmpty Then Paste into Destination | Excel Discussion (Misc queries) | |||
copy,paste and loop through workbook | Excel Discussion (Misc queries) | |||
copy and paste loop | Excel Programming | |||
constructing a copy-paste loop that skips rows | Excel Programming |