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 |
macro to move contents and delete existing 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: 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 |
All times are GMT +1. The time now is 10:30 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com