No video

Change values automatically while printing multiple copies

How to change values automatically while printing multiple copies using a macro.

Пікірлер: 26

  • @abbeyferguson6125
    @abbeyferguson6125 Жыл бұрын

    I'm pretty excited! I actually did it following your instructions - thank you so much! I'm very visual so it helps to see you do it so I can follow along, because I don't know Excel well at all, and am just fumbling my way around to try to make my work life easier. Thanks again.

  • @gootergoon
    @gootergoon2 жыл бұрын

    Good one. Very helpful in many practical situations.👍👍

  • @Exceltrainingvideos

    @Exceltrainingvideos

    2 жыл бұрын

    Glad it was helpful!

  • @Rajan-kk8nl
    @Rajan-kk8nl2 жыл бұрын

    Very very intersting classes sir, thank you so much.

  • @Exceltrainingvideos

    @Exceltrainingvideos

    2 жыл бұрын

    You are most welcome

  • @nadermounir8228
    @nadermounir82282 жыл бұрын

    Very interesting especially the use of arrays in VBA

  • @Exceltrainingvideos

    @Exceltrainingvideos

    2 жыл бұрын

    Indeed!

  • @sodoo672
    @sodoo6722 ай бұрын

    How can we add multiple variants

  • @shridharkulkarni117
    @shridharkulkarni1172 жыл бұрын

    Dear Sir, Great video. Thank you. One Question - Can we have dynamic value in Array (PList) instead of static values. ?

  • @Exceltrainingvideos

    @Exceltrainingvideos

    2 жыл бұрын

    Yes, you can

  • @HildaAmut
    @HildaAmutАй бұрын

    Hi sir, I am currently doing a student assessment program working with vba. I tried printing multiple sheets using cell value but the printing copies had gone over the maximum number in the class. Please how can I print using the cell ranges as minimum number and maximum number of a cell range? Thank you Ajay

  • @josemathewt3834
    @josemathewt3834 Жыл бұрын

    Thank you for your video, I also have a request to you to create a macro for combining multiple print job into one, for reducing time of printing of excel merged prints

  • @gauravyogi2025
    @gauravyogi2025 Жыл бұрын

    Very nice presentation. How about if you make it more easy by not changing the values of Plist in the Macro but changing the value in the cells? Is it possible?

  • @sanaokarian6169
    @sanaokarian6169 Жыл бұрын

    important thing is that.. in a school feee voucher we need print voucher class wise... each has a many student record... i think not possible in excel.... like access report.

  • @abuusman560
    @abuusman5602 жыл бұрын

    i have a workbook and need to print sheet 2 always two copies, how can I automate for always

  • @kryptoGh
    @kryptoGh Жыл бұрын

    Please sir, is it possible to print all of them on a single sheet. I am trying to print some receipts and want them on the same sheet but different details automatically

  • @ExcelMadeEasy444
    @ExcelMadeEasy4442 жыл бұрын

    Nice Explained.

  • @Exceltrainingvideos

    @Exceltrainingvideos

    2 жыл бұрын

    Glad it was helpful!

  • @whitestonemusic777
    @whitestonemusic7772 жыл бұрын

    Sir Plz Make a Video On Below Subject Actually This Is Reguler Process In My Factory So Please Do The Needful. I want substact Value every time based on cell value. Suppose Sr No - Item - Order Quantity - Available Stock - Balance Stock To Manufacturing 1- Socks1101 - 100 - (50- I put that value manually) -50 2.Socks2202 - 30 - 30 - 0 3.(Socks1101-Again) - 30 -( I want 0) - (I want 30 )

  • @whitestonemusic777

    @whitestonemusic777

    2 жыл бұрын

    Or Please Share Insta ID

  • @hasirnisar6060
    @hasirnisar6060 Жыл бұрын

    Dear Sir, how can I change the value in multiple cell, which code of line have to use. For example, 1. Name, 2. Roll Number, 3. subject and 4. semester. Thanks

  • @funnyclip8796
    @funnyclip8796 Жыл бұрын

    Sir agr mujhe pdf file me different words search kr same page print dene in one time it is possible or not

  • @RajaGiri_tvpm
    @RajaGiri_tvpm2 жыл бұрын

    Your voice is very attractive one 👌

  • @Exceltrainingvideos

    @Exceltrainingvideos

    2 жыл бұрын

    Thanks 😅

  • @binuvlogs8538
    @binuvlogs8538 Жыл бұрын

    🙏

  • @HildaAmut
    @HildaAmutАй бұрын

    Hi sir, I am currently doing a student assessment program working with vba. I tried printing multiple sheets using cell value but the printing copies had gone over the maximum number in the class. Please how can I print using the cell ranges as minimum number and maximum number of a cell range? Thank you Ajay