akeyes0214
New Member
- Joined
- Jan 10, 2019
- Messages
- 1
I am trying to find a way that I can take an entire row of data in Sheet 1 and copy it over to the bottom of Sheet 2 or any other additional sheets based on the first three characters within a column.
Basically I a have worksheet named Remote Users (which has formulas within it that I need) and if the last column (M) which is New Name within sheet is changed I want to move it to proper sheet based on the first three letters of the New Name column. For example my Remote Users worksheet has a new name listed in the new name column and it begins with RBK so I would like this row of information copied over to RBK worksheet. I will be needing to do this for about 25 worksheets so if any of these sheets have a New Name listed then I want it to be moved to the proper worksheet.
I hope that makes sense...
Basically I a have worksheet named Remote Users (which has formulas within it that I need) and if the last column (M) which is New Name within sheet is changed I want to move it to proper sheet based on the first three letters of the New Name column. For example my Remote Users worksheet has a new name listed in the new name column and it begins with RBK so I would like this row of information copied over to RBK worksheet. I will be needing to do this for about 25 worksheets so if any of these sheets have a New Name listed then I want it to be moved to the proper worksheet.
I hope that makes sense...