The example is working as it should.
What I would yet need is a check performed on each A cell (down to row 250) and based on that certain range would be copied to the destination sheet.
What I would yet like that Macro do:
Start at A1
**** Repeat (until Row 250)->
Check if the cell is different than:
1. ""
2. "Leader Name Here"
3. "Troop Name Here"
If all three conditions are met, then:
Check if the Cell is one of following: "HQ", "Elites", "Troops", "Fast Attack", "Heavy Support"
If yes, then:
Copy... (I think I can manage here)
If no, then:
If the cell on the same Row but in Column E has a numerical Vaule other than "0", then:
Copy.... (again I think I can manage)
If no then:
Copy those 4 rows and columns A to M
Move down 1 row
<- Repeat *****
Could you also help me with this?
Joe
Bookmarks