gr8trthanu
Board Regular
- Joined
- Nov 14, 2008
- Messages
- 103
Hello,
I am having problems thrying to get rows copied from a detail sheet into other sheets based on criteria in column "f" the data in column 'F" has sheets named after each.
However I found some code that resembles somewhat what I want to do... here is the link
http://www.mrexcel.com/forum/showthread.php?t=259350
Basically the code should look at each row starting at row 19 in the detail sheet. If in row 20 column f has "J1" then the entire row 20 should be copied, hilited green, and pasted in a sheet in the same workbook entilted J1. Then it would continue down the sheet until the end copying and pasting rows based on the data in column f. The sheets have already been created.
thank you
I am having problems thrying to get rows copied from a detail sheet into other sheets based on criteria in column "f" the data in column 'F" has sheets named after each.
However I found some code that resembles somewhat what I want to do... here is the link
http://www.mrexcel.com/forum/showthread.php?t=259350
Basically the code should look at each row starting at row 19 in the detail sheet. If in row 20 column f has "J1" then the entire row 20 should be copied, hilited green, and pasted in a sheet in the same workbook entilted J1. Then it would continue down the sheet until the end copying and pasting rows based on the data in column f. The sheets have already been created.
thank you