AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |
Back to Blog
![]() While the above code would move all the records whether status is closed and also delete it from the original data set, below is the code that would not delete the data from the original data set 'VBA Code by Scott from VBA Code (Move Row to Another Sheet & Keep in Original Data) The moved row will be pasted right after the current last row in the destination sheet. If your worksheet name is something else, you can change the VBA code (change the name of the sheet in the 4th line of the code) Also, the records where the status is closed will be deleted from the original dataset. This code will copy the entire row corresponding to a cell value containing the word ‘ Closed’’ into the worksheet named ‘Sheet2’. Here’s the code that we are going to use: 'VBA Code by Scott from įor Each m圜ell In Selection.Columns(4).Cells ![]() VBA Code (Move Row to Another Sheet & Delete From Original Data)
0 Comments
Read More
Leave a Reply. |