Пікірлер

• 
  @Omwereru10 күн бұрын

  Thanks for this very very useful video!!!

• 
  @jasonclarkcarbon545613 күн бұрын

  Need the code

• 
  @ExceliburVideos12 күн бұрын

  @jasonclarkcarbon5456 : The code is below Sub test() Sheets("Data").Activate i = ActiveCell.Row Dim Sfirstname Dim Slastname Dim SRoll Dim Sclass Dim Smarks1 Dim Smarks2 Dim Smarks3 Dim Smarks4 Dim Smarks5 Sfirstname = Cells(i, 3).Value Slastname = Cells(i, 4).Value SRoll = Cells(i, 5).Value Sclass = Cells(i, 2).Value Smarks1 = Cells(i, 6).Value Smarks2 = Cells(i, 7).Value Smarks3 = Cells(i, 8).Value Smarks4 = Cells(i, 9).Value Smarks5 = Cells(i, 10).Value '*************************************************** Sheets("Report Card").Activate Cells(3, 3).Value = Sfirstname & " " & Slastname Cells(4, 3).Value = SRoll Cells(5, 3).Value = Sclass Cells(8, 4).Value = Smarks1 Cells(9, 4).Value = Smarks2 Cells(10, 4).Value = Smarks3 Cells(11, 4).Value = Smarks4 Cells(12, 4).Value = Smarks5 End Sub

• 
  @cid208723 күн бұрын

  Intro volume: 100% The person talking: 10%

• 
  @ExceliburVideos23 күн бұрын

  Noted 👍

• 
  @ExtensionWithoutBorders28 күн бұрын

  very helpful

• 
  @ExceliburVideos22 күн бұрын

  Glad to hear that

• 
  @gamestechandmovies620729 күн бұрын

  Very useful

• 
  @ExceliburVideos28 күн бұрын

  Thank you !

• 
  @davidloop5437Ай бұрын

  Thanks for the tutorial. It was exactly what I needed

• 
  @ExceliburVideosАй бұрын

  Glad it was helpful 😀

• 
  @meganathann3205Ай бұрын

  Hii!! I have different data for different scenario, i have different template for each scenario, i need excel which when selected the scenario it will show the data needs to be filled for the scenario and it should give the sentence with the template with entered data for that scenario, can you please help me with this?

• 
  @ExceliburVideosАй бұрын

  You can use Pivot tables for your case and try to achieve the desired result.

• 
  @ENTN8Ай бұрын

  Perfect! Just what I was looking for

• 
  @ExceliburVideosАй бұрын

  Glad to know it was helpful !

• 
  @user-xx7jr4hs4oАй бұрын

  GREAT AND MAIN THING YOU ARE NOT KILLING TIME HERE AND THERE

• 
  @ExceliburVideosАй бұрын

  Thanks for the viewing & the feedback !

• 
  @KACS.KODIKARA2 ай бұрын

  Thanks a lot ❤

• 
  @bibinjacob8462 ай бұрын

  My in responses download response.csv file is not showing up

• 
  @RavindraSingh-pr3rt2 ай бұрын

  Great vedio, Keep up the good work

• 
  @ExceliburVideos2 ай бұрын

  Thanks!

• 
  @vivekmishra82 ай бұрын

  how to automate this

• 
  @rutvikprajapati60303 ай бұрын

  Thank You Bro ❤

• 
  @HaseenaChandni3 ай бұрын

  I learnt so much from this valued lesson. Thank you so much.

• 
  @ExceliburVideos3 ай бұрын

  Glad that you learnt something new !

• 
  @vijisuresh19623 ай бұрын

  Thanks for the wonderful, simple video. This is very useful.

• 
  @ExceliburVideos3 ай бұрын

  You are welcome!

• 
  @paddyofurniture39883 ай бұрын

  @Excelibur I was told I could leverage these VBA to simulate or group multiple animation on ONE object, so I could use that object on different slides??? Does that sound remotely possible?

• 
  @ExceliburVideos3 ай бұрын

  This could be possible, although I havent tried it yet. :)

• 
  @NBH20233 ай бұрын

  do you have the video guide on how you did the Generate report card?

• 
  @ExceliburVideos3 ай бұрын

  @NBH2023 - Please see the following video to see how a report card is generated kzread.info/dash/bejne/daqlzKppgNfRXc4.html

• 
  @pAULEE_wORLi4 ай бұрын

  very interesting, thanks

• 
  @ExceliburVideos4 ай бұрын

  You're welcome

• 
  @MoniMeka4 ай бұрын

  omg, this is too funny! the dancing is killin' me! 🤣🤣🤣🤣🤣🤣

• 
  @leannesmith10594 ай бұрын

  Thank you!!

• 
  @jiteshsharma83064 ай бұрын

  Thank you so much Brother :)

• 
  @ExceliburVideos4 ай бұрын

  You are welcome !

• 
  @henryhoang45385 ай бұрын

  Useless video

• 
  @tanukadey10385 ай бұрын

  This is very useful and informative !

• 
  @ExceliburVideos5 ай бұрын

  @tanukadey : Thanks for the feedback.

• 
  @MohammadAsif-pr5el5 ай бұрын

  sir meri data entry ki job hai ek ek karke forms fill karne hote hain koi tarika bataye data ek saath copy ho jaaye forms mei

• 
  @user-rn9mv7yz7h5 ай бұрын

  Where did you get the little window that says "Generate Report"

• 
  @ExceliburVideos5 ай бұрын

  @user-rn9mv7yz7h : This is a button in Microsoft Excel. To learn how to create and use a button, please view the following videos.

• 
  @ExceliburVideos5 ай бұрын

  kzread.info/dash/bejne/oKOF0pV8YazZgco.html kzread.info/dash/bejne/dp6d2cyOh7G0hso.html

• 
  @user-rn9mv7yz7h5 ай бұрын

  Thank you. Apparently, my Excel program is too old; it does not have the DEVELOPER etc tabs.@@ExceliburVideos

• 
  @RUTHVIKTEJASR5 ай бұрын

  It's free are not

• 
  @ExceliburVideos5 ай бұрын

  @RUTHVIKTEJASR - Yes, its completely free !

• 
  @Rojin.Marzooki6 ай бұрын

  I followed the instructions, but the data was entered in the cells of the same sheet not in the second sheet although iam sure that i wrote activate the second sheet. What is the problem I wrote: sheet(“card”).activate But nothing was written in it It was written in the data sheet cells…. But also you didn’t show how you connected the code to the button. I did insert command button and added the code to when click on it

• 
  @ExceliburVideos6 ай бұрын

  @Princess_Rojin : Thanks for watching the video. Please try Sheets("card").activate

• 
  @ExceliburVideos6 ай бұрын

  Also, please check the following link for clarity on how buttons work in Excel kzread.info/dash/bejne/dp6d2cyOh7G0hso.html

• 
  @SamSam_24923 күн бұрын

  Same issue!! I've written Sheets ("Card"). Activate But still it's showing in the same Data sheet..

• 
  @Ppanos4236 ай бұрын

  Thank you!

• 
  @ExceliburVideos6 ай бұрын

  You're welcome!

• 
  @johnson8636 ай бұрын

  How to save the output file on the same path wherever we maintain the excel macro.. pls help Even if i move the excel to any path, the output must generate on same path

• 
  @ExceliburVideos6 ай бұрын

  @johnson863 : The path of the PDF file is defined in the macro code. You are free to modify\define this path on your own. This will allow you to generate the report on the same path irrespective of the excel file.

• 
  @rramesh9697 ай бұрын

  Need Text Blinking permanently when open the excel sheet

• 
  @ExceliburVideos6 ай бұрын

  @rramesh969 Use the code on the worksheet open event

• 
  @divans37 ай бұрын

  Intro too long…

• 
  @ExceliburVideos6 ай бұрын

  Feedback noted

• 
  @fildzahfifi30687 ай бұрын

  Hi, why my macro is not working? need to debug, but im not sure which one is wrong, mind to help me?

• 
  @dnahealthcarestudies7 ай бұрын

  how to sent image ?

• 
  @AnjaliKumari-vd3rl7 ай бұрын

  Thank you so much sir

• 
  @asifosman8 ай бұрын

  How to automate this?

• 
  @bernardweber1429 ай бұрын

  Is it also possible to select a radio button via vba?

• 
  @SameerGoyal-su9cx9 ай бұрын

  Nice video sir... I want to insert images in ppt so what is the VBA code for that? please tell me

• 
  @FadhiliHazenphosemalima9 ай бұрын

  This is nice

• 
  @ExceliburVideos9 ай бұрын

  Thanks

• 
  @Darasundaro9 ай бұрын

  Hi, could you show the code select row generat copy text

• 
  @siddarth259910 ай бұрын

  THANK YOU

• 
  @MaximumBan10 ай бұрын

  Amazing!!!

• 
  @ExceliburVideos10 ай бұрын

  Thanks!!

• 
  @invert6actual58510 ай бұрын

  Excellent videos, you teach me very much.

• 
  @ExceliburVideos10 ай бұрын

  Glad to hear that!

• 
  @119kshhs11 ай бұрын

  Thanks a lot Sir for this video. It helped a lot.

• 
  @ExceliburVideos11 ай бұрын

  Glad it helped

• 
  @britneybutler419111 ай бұрын

  How can I highlight multiple rows and generate multiple reports on multiple sheets at once?

• 
  @ExceliburVideos11 ай бұрын

  @britneybutler4191 : You can select muliple rows using a FOR loop in the code ( moving the desired row number in the variable "i" ). To generate multiple reports - you would need to copy-paste the "report card" sheet multiple times and then move the values of the variables otherwise all values get overwritten and you would only see the last row result

• 
  @devivengateshdevi360711 ай бұрын

  Not work

• 
  @ExceliburVideos11 ай бұрын

  It definately works. Please try again and be careful with the syntax or code

• 
  @MANZANOADRIAN11 ай бұрын

  can you add photos to the survey have the photos appear in the excell

• 
  @ExceliburVideos11 ай бұрын

  You can definitely add photos in the survey. I havent tested whether these can be transfered diretly to google sheets \ excel ... will have a look

• 
  @mohamadabdouni Жыл бұрын

  IT did not work

• 
  @ExceliburVideos Жыл бұрын

  Sorry to hear that. Request you to please check the video & syntax again and try. It definately works :)

• 
  @jorgetaco2957 Жыл бұрын

  ???

• 
  @mudarsaid9733 Жыл бұрын

  Hey thanks ... great video... i have question is it applicable for pivot tables as well. You noy pivot tabels are dynamic. Though the row keep changing when we filter. Do you know if it still works ?

• 
  @ExceliburVideos Жыл бұрын

  Thanks for the feedback. It will work with the Pivot table but it picks the data from the cell referenced in the code. While the Pivot table is dynamic, if you are able to get the right data in the right cells ... should work for you !

• 
  @mudarsaid9733 Жыл бұрын

  @@ExceliburVideos thanks 😊