Code description

Hi,

That's rather a lot of code and no doubt could be simplified somewhat. But we need to know what you want to achieve. It's by no means clear what you mean by 'needing a description'.

Let's start from basics. Upload the workbook and manually add the results you expect to see after you have processed the data so that we can decide the optimum solution which will probably look little like your existing code.

Mappe X.xlsm

Richard,
Thank your for your reply.

Please find in the attached workbook the following:
1. The Input worksheet “Vergütungsdaten_M” (=> the data to be processed)
2. The Output worksheet “22_Koepfe Detail” (=> the result expected to see)
3. The auxiliary worksheet “Aux”
4. The code is available in Module 1.

Please note that the output worksheet needs to be deleted each time before running the code.

What I would need, is a so-called guide through the code, namely a short description of the operations/command blocks in the code.
It is good to hear that the code could be simplified; sadly I do not have the knowledge to do it.

Once again, thanks a lot!

Hi,

Where do the column CK & CT values come from and is the Koepfe column Q the number that appears in the various date columns.

Hi,

I can see that those values appear in the resultant sheet columns CK & CT, my question was where does this information reside in the “22_Koepfe Detail” sheet.

Or are you saying that columns CK & CT should always be populated with HC and aktiv. If so what about those cells in CT which aren't showing just 'aktiv'? e.g. CT20

Hi,

Add another 'Results Sheet' (make sure it has the VBA sheet code name 'Sheet1' and then run this macro.

Please Login or Register  to view this content.

Hi,

Have you added a new sheet and checked that it has the VB code name 'Sheet1'. You can name the tab name anything you like. This sheet will contain your results.

Richard,

sorry for my late reply..
It works perfectly and I would gladly replace the initial code that I was using, because it requires a lot of resources for which I need a good machine.
The problem is that, with my old code I create approx. 120-130 of those result sheets, each of which containg different data.
The structure is of course the same, only the manager, the teams and the employees differ.
That means one would have to add around 120 new sheets prior running the code.
Besides, the "Tabelle85" in the code becomes variable, right?

Question: could one go around this manual creation of "Sheet1", "Sheet2", "Sheet3"...,etc. and the "Tabelle85" problem?

Thanks again!

Regards