Create individual table Schedule 4 based on previous data sheets [SOLVED]

[Visor]

Dear friends of the forum, I made 4 data sheets in which there is a link to create a table of individual schedule, it could be with formulas or better yet with macro code, I've even put some buttons option to advance, The problem is that a teacher can have several subjects in the same semester or several but what matters is to bring together this unique teacher information in one table.
What would be the best way to transfer this data to create the table?

upload the file to be seen.
I appreciate your kind cooperation.

 

[Visor]

So far I have not had answers
Please if further explanation is required, I will do it gladly,
or maybe you can tell me if this type of problem has no solution !! ??

 

[vletm]

@Visor
What is 'PorDocente' A-columns purpose? If marked -> what should happen?
When do last two sheets should filled?
Can You prefill 'HrINVIDIUAL'-sheet?
How do You work if 'PROFESORES' name (including title) change? It's common thing to all sheet. You gotta make changes to all sheets ... or?
This is possible ...

 

[vletm]

@Visor
... check 'Como Deberia Salir' -tab
Select 'name' with dropdown Cell[D8]
Where do PARALELO and OBSERVACIONES comes?
Something this kind?

 

[Visor]

That's right !! This is how I want it to work, but a brief review, I don't understand, Ing. Felix Falconi data are not observed.
By the time the parallel is not being used in the tables, so now I write by hand (no problem), the "Observations", so I write manually.
The code information related to the different sheet is not according to my current knowledge.
Thank you very much for your collaboration,

 

[vletm]

@Visor
case 'Ing. Felix Falconi' :
There is 'Ing. FALCONI ONTANEDA FELIX ATAIR' in DOCENTE-sheet,
that is the 'KEY'-name!
For some reason ... someone use name 'Ing. Felix Falconi'?
Those are different names! (for me, for Excel ... )
Like my 'vletm' and Yours 'Visor' are on same page, but different persons!
Did You get an idea?
> BTW ... That was one of my questions ...

as well about 'HrINVIDIUAL'-sheet.
What are differences of 'HrINVIDIUAL' and 'Como Deberia Salir'?
> I can take that 'A' away from 'PARALELO'

>> waiting answers and ideas
>> for next version

 

[Visor]

case 'Ing. Felix Falconi' :
There is 'Ing. FALCONI ONTANEDA FELIX ATAIR' in DOCENTE-sheet,
that is the 'KEY'-name!
I'm sorry, I think I should put names unified in all the cells in the different sheets
I think it is the only case

as well about 'HrINVIDIUAL'-sheet.
What are differences of 'HrINVIDIUAL' and 'Como Deberia Salir'?

The two are the same sheet,
'indiVIDUAL'-sheet:
It is the road before using any macro, is the sheet that will run the macro 'As should go:
It is the leaf showing as an example, after executing the macro (This is an example to show the result which I hope) This sheet eliminate it, since only serves to explain.

I can take that 'A' away from 'PARALELO'
The "parallel" and "observations" best left well, because I put myself manually. The parallel is a classroom, Example A and B, the same level. Example: First level A, level First B.
But we have no parallel, but for the future if there will be, and how many will not have been.

Thank you very much for your collaboration,

 

[vletm]

@Visor
Got answers, I took 'A' away.
Gotta be careful with names.
Here's the 2nd version.
Ideas ... Questions?

 

[Visor]

Of course, I see that actually works and be careful with the names.
I see When I select name with dropdown on the combobox I need to look at all the names, the name that interests me.
Sometimes it becomes uncomfortable to find the specific name.
That's why there was sheen, use the Options button that is in the "PorDocente" sheet. When you select and click the button "View Horiario Individual" shows me the "HrINDIVIDUAL" road to individual teaching schedule.

"HrINDIVIDUAL

 

[vletm]

@Visor
Check "HrINDIVIDUAL"
Select any row that have 'PROFESORES' and press [Horario Individual].
Ideas ...

 

[Visor]

EXCELlent!!!
So it's just like I wanted to, you're a genius, is very very fantastic
Thanks for your help, maybe someday I can see the code,
I am very grateful
Topic solved

 

[Visor]

It is difficult to adapt because I had other macros in the original file
Is it possible to password lock your macro module?
and then export only the module blocked me. Then I can import the file ??

 

[vletm]

@Visor
Yesterday, You wrote 'maybe someday' ... today hurry ... is tomorrow too late?
My 'Chandoo Office Hours' are limited.
I had some ideas with code and but as You're hurry, I just cleaned extras away.
I didn't add any Module there and You have had always permit to use those codes. If Excel somewhere will ask password, just write as Excel ask, Write Password. Don't do mistake with the first capital letter!
Ideas ... Questions?

 

[Visor]

Actually, I've tried using several typical words like password, but without success, I have another macro that desifra passwords but I did not work now, besides the files that I upload are usually only part of the original so when trying to adapt no taxes to be with success. The solution to that achieved ubiese key desifrar use two serious books excel, one with key and another key.
That was a puzzle that did not think I try many words but less that it is a good idea if we keep on this forum that we put the same key or better yet, with the applicant's name forista.
But now I'm quite happy because I can move forward with other ideas included it in the application
I am very grateful
and I apologize for the inconvenience