bradnailer
New Member
- Joined
- Jul 27, 2007
- Messages
- 26
ABCDE
FGHIJK
If the above is in different cells, I want to be able to move the data in "G" to the cell beside "E" (up a row and over 4 columns) IF the cell to the left of "G" equals what I specify is in "F" (for example use "product"). I would want to apply this to an entire sheet, not just once. If the macro (not sure what its called) could also then delete the row that contained "G" after it moves it, that would be even better!!! The output in the example above would be:
ABCDEG
F HIJK <----then this row gets deleted
So essentially, whenever the macro comes across the value "product" it move the data in the cell adjacent to it up a row and over 4 columns and then the row it came from is deleted.
I've looked and searched but haven't seen anything that I may be able to copy (I'm not a VBA expert so I'm not sure how to write something myself)
Thanks!!
FGHIJK
If the above is in different cells, I want to be able to move the data in "G" to the cell beside "E" (up a row and over 4 columns) IF the cell to the left of "G" equals what I specify is in "F" (for example use "product"). I would want to apply this to an entire sheet, not just once. If the macro (not sure what its called) could also then delete the row that contained "G" after it moves it, that would be even better!!! The output in the example above would be:
ABCDEG
F HIJK <----then this row gets deleted
So essentially, whenever the macro comes across the value "product" it move the data in the cell adjacent to it up a row and over 4 columns and then the row it came from is deleted.
I've looked and searched but haven't seen anything that I may be able to copy (I'm not a VBA expert so I'm not sure how to write something myself)
Thanks!!