| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
macro to move contents and delete existing row
If I have a set of data located in the first column similar as follows:
"Column A" "Column B" "Column C" Data1* * Example1 Data2* * Example2 Data3* * Example3 and so on.. Is it possible to create a macro to go through and search that column of data and and move the contents from Column A to Column C and up one row as follows: "Column A" "Column B" "Column C" Data1* * Example1 Data2* * Example2 Data3* * Example3 Then delete the row that the data was in so the final product is as follows: "Column A" "Column B" "Column C" Data1* * Example1 Data2* * Example2 Data3* * Example3 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
macro to move contents and delete existing row
See your other thread
-- Regards Ron de Bruin http://www.rondebruin.nl "Mark64" wrote in message ... If I have a set of data located in the first column similar as follows: "Column A" "Column B" "Column C" Data1* * Example1 Data2* * Example2 Data3* * Example3 and so on.. Is it possible to create a macro to go through and search that column of data and and move the contents from Column A to Column C and up one row as follows: "Column A" "Column B" "Column C" Data1* * Example1 Data2* * Example2 Data3* * Example3 Then delete the row that the data was in so the final product is as follows: "Column A" "Column B" "Column C" Data1* * Example1 Data2* * Example2 Data3* * Example3 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| macro to move and delete contents | Excel Programming | |||
| macro to move cell contents and then delete the row | Excel Programming | |||
| macro to move cell contents and then delete the row | Excel Programming | |||
| Macro to remove contents of cell and move all other contents up one row | Excel Discussion (Misc queries) | |||
| macro to move contents of directory | Excel Programming | |||
Linear Mode
