SOLVED

Copying text from several scedules to a new scwdule.

%3CLINGO-SUB%20id%3D%22lingo-sub-1494176%22%20slang%3D%22en-US%22%3ECopying%20text%20from%20several%20scedules%20to%20a%20new%20scwdule.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1494176%22%20slang%3D%22en-US%22%3E%3CP%3EIm%20working%20with%20scedules%20for%20my%20school%20(%20dont%20ask%20me%20why%20our%20new%20programme%20for%20doing%20so%20is%20not%20ready%20yet)%20How%20do%20I%20collect%20the%20name%20of%20subjects%20from%20several%20teacherscedules%20f%20ex%20monday%20first%20lesson%2C%20into%20the%20grades%60scedule%20in%20monday%20first%20lesson%3F%20If%20one%20teacher%20scedule%20has%20a%20subject%20like%20math%20or%20science%2C%20religion%20or%20history%2C%20what%20do%20i%20write%20in%20the%20cell%20for%20the%20grade%20to%20copy%20the%20name%20of%20the%20subject%20to%20their%20scedule%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1494176%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1494242%22%20slang%3D%22en-US%22%3ERe%3A%20Copying%20text%20from%20several%20scedules%20to%20a%20new%20scwdule.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1494242%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F712206%22%20target%3D%22_blank%22%3E%40Hildeg20%3C%2FA%3E%20%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20you%20are%20looking%20to%20collect%20the%20data%20then%20I%20would%20suggest%20you%20to%20use%20%3CA%20href%3D%22https%3A%2F%2Fforms.office.com%2F%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3EMicrosoft%20Forms%3C%2FA%3E%20great%20way%20to%20collect%20data%20and%20export%20in%20Excel.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWith%20regards%20to%20you%20second%20question%20what%20I%20understood%20you%20are%20trying%20to%20do%20some%20kind%20of%20lookup%20to%20get%20the%20teacher%20name%2C%20could%20you%20please%20attached%20sample%20with%20your%20desired%20results.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3ERegards%2C%20Faraz%20Shaikh%20%7C%20MCT%2C%20MIE%2C%20MOS%20Master%2C%20Excel%20Expert%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CEM%3E%3CFONT%20color%3D%22%23808080%22%3EIf%20you%20find%20the%20above%20solution%20resolved%20your%20query%20don't%20forget%20mark%20as%26nbsp%3B%3CSPAN%3EOfficial%20Answer%26nbsp%3Bto%20help%20the%20other%20members%20find%20it%20more%3C%2FSPAN%3E%3C%2FFONT%3E%3C%2FEM%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1494286%22%20slang%3D%22en-US%22%3ERe%3A%20Copying%20text%20from%20several%20scedules%20to%20a%20new%20scwdule.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1494286%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F156456%22%20target%3D%22_blank%22%3E%40Faraz%20Shaikh%3C%2FA%3E%26nbsp%3BThank%20you.%20I%C2%B4ve%20added%20a%20sample%20document.%20In%20my%20plans%20I%20have%20a%20sheet%20with%20for%20example%20nine%20different%20scedules%20for%20teachers.%20As%20you%20see%20here%2C%20(with%20only%20two%20teachers)%2C%20I%20have%20a%20scedule%20for%20the%201.%20grade%20at%20the%20bottom.%20The%20only%20thing%20I%20want%20to%2C%20is%20that%20the%20text%20I%20write%20in%20a%20teachers%20scedule%20end%20up%20in%20the%20grades%20scedule%20as%20well.%20I%C2%B4m%20able%20to%20make%20the%20scedule%20count%20the%20amount%20of%20hours%20the%20Grade%20get%2C%20so%20that%20is%20not%20part%20of%20my%20question%2C%20but%20I%20dont%20know%20how%20to%20get%20text%2C%20the%20name%20of%20the%20subjects%2C%20get%20copied%20to%20the%20Grade%20scedule.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1494360%22%20slang%3D%22en-US%22%3ERe%3A%20Copying%20text%20from%20several%20scedules%20to%20a%20new%20scwdule.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1494360%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F712206%22%20target%3D%22_blank%22%3E%40Hildeg20%3C%2FA%3E%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPlease%20see%20the%20attached%20schedule%2C%20it%20that%20what%20you%20looking.%20Now%20when%20you%20type%20anything%20in%20teacher%20boxes%20it%20will%20appear%20in%20the%20grade%201.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Snag_33a6141c.png%22%20style%3D%22width%3A%20388px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F201716iB5F5341D52157E73%2Fimage-dimensions%2F388x290%3Fv%3D1.0%22%20width%3D%22388%22%20height%3D%22290%22%20title%3D%22Snag_33a6141c.png%22%20alt%3D%22Snag_33a6141c.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20not%20then%20please%20re-attached%20the%20sample%20along%20with%20your%20desired%20output%20manually%20entered.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3ERegards%2C%20Faraz%20Shaikh%20%7C%20MCT%2C%20MIE%2C%20MOS%20Master%2C%20Excel%20Expert%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CEM%3E%3CFONT%20color%3D%22%23808080%22%3EIf%20you%20find%20the%20above%20solution%20resolved%20your%20query%20don't%20forget%20mark%20as%26nbsp%3B%3CSPAN%3EOfficial%20Answer%26nbsp%3Bto%20help%20the%20other%20members%20find%20it%20more%3C%2FSPAN%3E%3C%2FFONT%3E%3C%2FEM%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1494362%22%20slang%3D%22en-US%22%3ERe%3A%20Copying%20text%20from%20several%20scedules%20to%20a%20new%20scwdule.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1494362%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F156456%22%20target%3D%22_blank%22%3E%40Faraz%20Shaikh%3C%2FA%3E%26nbsp%3BThanks%20alot.%20This%20is%20exactly%20what%20I%20needed.%20Marvelous%20%3CLI-EMOJI%20id%3D%22lia_slightly-smiling-face%22%20title%3D%22%3Aslightly_smiling_face%3A%22%3E%3C%2FLI-EMOJI%3E%3C%2FP%3E%3CP%3EBest%20r%3CBR%20%2F%3EHildegunn%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1494370%22%20slang%3D%22en-US%22%3ERe%3A%20Copying%20text%20from%20several%20scedules%20to%20a%20new%20scwdule.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1494370%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F712206%22%20target%3D%22_blank%22%3E%40Hildeg20%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAwesome%20%3CLI-EMOJI%20id%3D%22lia_slightly-smiling-face%22%20title%3D%22%3Aslightly_smiling_face%3A%22%3E%3C%2FLI-EMOJI%3E%20%2C%20don't%20forget%20to%20mark%20as%20official%20answer%20so%20that%20it%20will%20helpful%20for%20other%20members%20as%20well.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3ERegards%2C%20Faraz%20Shaikh%20%7C%20MCT%2C%20MIE%2C%20MOS%20Master%2C%20Excel%20Expert%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CEM%3E%3CFONT%20color%3D%22%23808080%22%3EIf%20you%20find%20the%20above%20solution%20resolved%20your%20query%20don't%20forget%20mark%20as%26nbsp%3B%3CSPAN%3EOfficial%20Answer%26nbsp%3Bto%20help%20the%20other%20members%20find%20it%20more%3C%2FSPAN%3E%3C%2FFONT%3E%3C%2FEM%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

Im working with scedules for my school ( dont ask me why our new programme for doing so is not ready yet) How do I collect the name of subjects from several teacherscedules f ex monday first lesson, into the grades`scedule in monday first lesson? If one teacher scedule has a subject like math or science, religion or history, what do i write in the cell for the grade to copy the name of the subject to their scedule?

5 Replies

Hi @Hildeg20 ,

 

If you are looking to collect the data then I would suggest you to use Microsoft Forms great way to collect data and export in Excel. 

 

With regards to you second question what I understood you are trying to do some kind of lookup to get the teacher name, could you please attached sample with your desired results.

 

Regards, Faraz Shaikh | MCT, MIE, MOS Master, Excel Expert

If you find the above solution resolved your query don't forget mark as Official Answer to help the other members find it more

@Faraz Shaikh Thank you. I´ve added a sample document. In my plans I have a sheet with for example nine different scedules for teachers. As you see here, (with only two teachers), I have a scedule for the 1. grade at the bottom. The only thing I want to, is that the text I write in a teachers scedule end up in the grades scedule as well. I´m able to make the scedule count the amount of hours the Grade get, so that is not part of my question, but I dont know how to get text, the name of the subjects, get copied to the Grade scedule.

Best Response confirmed by Hildeg20 (New Contributor)
Solution

Hi @Hildeg20,

 

Please see the attached schedule, it that what you looking. Now when you type anything in teacher boxes it will appear in the grade 1.

 

Snag_33a6141c.png

 

If not then please re-attached the sample along with your desired output manually entered.

 

Regards, Faraz Shaikh | MCT, MIE, MOS Master, Excel Expert

If you find the above solution resolved your query don't forget mark as Official Answer to help the other members find it more

@Faraz Shaikh Thanks alot. This is exactly what I needed. Marvelous

Best r
Hildegunn

Hi @Hildeg20 

 

Awesome , don't forget to mark as official answer so that it will helpful for other members as well. 

 

Regards, Faraz Shaikh | MCT, MIE, MOS Master, Excel Expert

If you find the above solution resolved your query don't forget mark as Official Answer to help the other members find it more