| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
macro to move cell contents and then delete the row
I have a single column of data located in Column A similar as follows:
"Column A" "Column B" "Column 3" "....." Example1* * data1 Example2* * data2 Example3* * data3 and so on. What I want to do is have a macro to move the contents as follows: "Column A" "Column B" "Column 3" "....." Example1* * 1 Example2* * 2 Example3* * 3 Then I want to delete the empty rows where the data used to be. Is this possible? Thanks |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
macro to move cell contents and then delete the row
Sorry, this issue has already been posted. I received an error when I tried
to submit it and so I tried to post it again, althought it had already posted. Thank you "Mark64" wrote: I have a single column of data located in Column A similar as follows: "Column A" "Column B" "Column 3" "....." Example1* * data1 Example2* * data2 Example3* * data3 and so on. What I want to do is have a macro to move the contents as follows: "Column A" "Column B" "Column 3" "....." Example1* * 1 Example2* * 2 Example3* * 3 Then I want to delete the empty rows where the data used to be. Is this possible? Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Move cell contents with macro | Excel Discussion (Misc queries) | |||
| macro to move cell contents and then delete the row | Excel Programming | |||
| Macro to move cell contents based on formatting | Excel Programming | |||
| Macro to move the contents of a cell | Excel Programming | |||
| Macro to remove contents of cell and move all other contents up one row | Excel Discussion (Misc queries) | |||
Linear Mode
