VBA Code Needed - Move Data/Ignore Blanks/Data is Moved to Specific Area

New to VBA, figures I would attempt to do something way over my head. -- I've purchased books, searched the internet, and finally will turn to complete strangers for help and guidance.

What I am trying to do:
Copy/Transfer information from a column only with values from one sheet (in the file attached the "Schedule" or "DO NOT USE" sheets), to another sheet, in a specific area (in the file, each shift is put on it's appropriate day sheet). (Lots of destination code necessary?)
I then need the name to populate in relation to first column, from the row where the data/value was found. (For example, if the Monday shift was found in cell D3, then I need the name from B3 to populate in the appropriate cell on the corresponding "Monday" worksheet.)

Not so great with VBA jargon, so forgive me if I come off as VBA illiterate.

I had planned this out with nested if functions in my head. About the time I started putting it together, I realized that wasn't going to work as well as I had envisioned.

(I sincerely hope you, the reader understand what I'm looking to do.)
Is this even possible?
I'm sure it is, but have no code to prove it.
If someone could even just carve out a skeleton for me, I'm sure that I could figure it out and beef it up.
I'm at wits end here, have been pouring over this for a week non-stopped.

Any help is greatly appreciated!

Copy for Internet Help.xls

There is absolutely no rush.
In a perfect world, Friday. But, anytime next week would be fine too!
I would just like to see my dream workbook come to life.
As a result of this "biting off more than I can chew" my new life mission is to learn everything VBA. Ha.

Tarheel born, Tarheel bred.
Looks like you've migrated a bit?

Also, THANK YOU for attempting to help me!
You're my hero!

--Kandy

You know us N'oth Carolinians ain't in to all that there fancy talk.
Luckily, I've some how evaded the accent, I move around too much.
I'm only country on the inside.

On the "Schedule" tab, any shift can be entered -- Example 11-7 or 11am-7pm or 10-CL --
I just need whatever shifts are scheduled (whatever value is entered) in the Monday column...(This is where I thought the simple table on "DO NOT USE" tab would come in handy)...To be put into the Shifts column on the "Monday" sheet.
Likewise, whatever row that shift was found in, have the name populates in the Name column on the "Monday" sheet.

Then this occurs for each day of the week.
So essentially, once you've keyed in your schedule for the week, each one of your daily worksheets magically tells you everything you need to know about that day, including who is scheduled and when.

Does that help or hinder?

Very nice!
It works! *head explodes* Haha.
I'll just make a button to clear the sheets too...
If you run it multiple times it repeats shifts.

Thank you!

It "repeats" because it looks for the first available empty row. If you already have shifts in there, yes it will just insert the the shifts under the already filled rows.

The easiest solution probably would be to clear all the shifts first. Sounds like you know how to do?

That I can do.
Impressive, no? Haha.

Hey, there's no fault at being at any skill level. I'm working to improve, too. (Like whoops, I could have combined those two For loops, and yup this may have been simpler if i had used a Dictionary instead of arrays, but I'm pretty rusty with dictionaries.)

And oh, I forgot to mention, you can get rid of the DO NOT USE sheet, it isn't utilized in my code.

Lovely!
I'm going to play around with it some more.
Try to see if I can figure out all the code you used.
Seems I've got more research to do.

I'll preface this with, I'm blonde...How do you mark this as solved?

I'm still willing to look at any other code offered up though!

Not sure about marking Solved, I'm kinda new here too.

And I should have commented my code. I'd be happy to explain anything, or if you want I can just go back and try to add comments to the code.

Totally up to you, but if you have the time, I'd be very grateful for comments.

Ok, here's some very basic comments. They do more to explain what is happening than how it specifically works, so again, any questions on the syntax of the code, just ask.

Please Login or Register  to view this content.

Thank you for the comments!!
AMAZING!!

Glad to help.