Automate and make my Excel file dynamic

[Mievo]

Hello,

I try to automate my Excel sheet. My skills are not good enough to do it on my own, even though I'm learning a lot of VBA the last two weeks. The problem is that many different things are on one Worksheet and therefore it is very dynamic. I cannot deal with it on my own.

I set comments on the Excel what I need/want (on the sheets "Aktionen", "Einstellungen" and "Key Account Manager"), I tried to be as specific as possible. It is a lot. But I would appreciate every help I get! If you have any questions or something is unclear, please feel free to message me!

Thank you in advance!

[davesexcel]

One step at a time.

It would also help if you showed the preferred results in your sample workbook

[Mievo]

I created to candidates and entered them in every sheet they would be in.

So for instance Petra: She is in "Bewerbungseingang". If I put "x" in "Absagen?" she should be moved to "Absagen" and when selecting "Abgesagt?" with "x" she should be moved to the sheet "Abgesagt".

Same for Jens, but Jens got accepted: From "Bewerbungseingang" when adding "x" into "Interview?", he should be moved to "Interviews". If he's in interviews and I tick "x" for "Einstellen?", he should be moved to sheet "Einstellungen". From there to sheet "Onboarding".

Of course when he gets moved from "Bewerbungseingang" to "Interviews", he should not be in "Bewerbungseingang" anymore. I just put him into every related sheet to show the process for the moving-function.

I hope you understand my example. If not, let me know. Thanks in advance!

[Mievo]

Is it okay the way I showed it or unclear? Thanks in advance :-)

[davesexcel]

Here is the first part, you should be able to get the other parts figured out with this.

Make sure to clear Interview and cancel cells before running initial code.
Click button on attached.

Please Login or Register  to view this content.

[Mievo]

Hello! It is working, thank you very much. The only thing I'm missing is that when moving someone from "Bewerbungseingang" to "Interview", what should happen is that "Absagen" gets pushed down by one row. This means there is always some space between the categories.

If I have this, I can figure out how to add a new candidate to the "Bewerbungseingang"-list. Now there is free space of 15 cells, but this is not enough. Therefore I would implement this function later there too to push everything down - so the list is endless and not limited to for instance 15 cells. Because when adding a new candidate, it will automatically add a new row and therefore still have space of 15 rows between the categories.

[Mievo]

Anyone who can assist? Would be very thankful!

[Mievo]

#push. Still searching for help, would be highly appreciated!

[davesexcel]

Use the macro recorder to see what the code looks like, then clean the code up.