outlawdevil
Board Regular
- Joined
- Jun 30, 2009
- Messages
- 238
Hi, I got a question that i haven't got a solution,maybe someone can help me. I am open for any suggestions. I have a list of data I want to mirror copy(A2:D5) and paste to the last available empty row. I need excel to figure out where the mid point is so I can filter and change from mid point from HR to AP(A6:D9). These range will change based on data so it's not fixed. Is there a solution or code I should look into to accomplish this task? Screenshot attached for reference. thank you in advance!