VBA - Copy Rows with Values from sheet to sheet

[Nightwolf101]

Good Evening Excel / VBA Guru's,

I need your help one final time (I think)! Currently working on a task management tool that will help track daily, weekly, and monthly task. Since tasks change on a regular basis, I would like to automate this process.

Problem: Copy multiple rows with values from "Test 1 - Daily" to "Action Tasks.

Conditions:
- "Test 1 - Daily" will be hidden
- Expect up to 30(ish) tasks within daily/weekly/yearly

Seems easy, but I keep running into problems writing the code. See attachment, please...

~Nightwolf

[Nightwolf101]

Hey everyone... I might have figured it out, but coming up short on the paste:

Please Login or Register  to view this content.

Can someone help?

~Nightwolf