Change values automatically while printing multiple copies
How to change values automatically while printing multiple copies using a macro.
Жүктеу.....
Пікірлер: 26
@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.
@gootergoon2 жыл бұрын
Good one. Very helpful in many practical situations.👍👍
@Exceltrainingvideos
2 жыл бұрын
Glad it was helpful!
@Rajan-kk8nl2 жыл бұрын
Very very intersting classes sir, thank you so much.
@Exceltrainingvideos
2 жыл бұрын
You are most welcome
@nadermounir82282 жыл бұрын
Very interesting especially the use of arrays in VBA
@Exceltrainingvideos
2 жыл бұрын
Indeed!
@sodoo6722 ай бұрын
How can we add multiple variants
@shridharkulkarni1172 жыл бұрын
Dear Sir, Great video. Thank you. One Question - Can we have dynamic value in Array (PList) instead of static values. ?
@Exceltrainingvideos
2 жыл бұрын
Yes, you can
@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 Жыл бұрын
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 Жыл бұрын
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 Жыл бұрын
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.
@abuusman5602 жыл бұрын
i have a workbook and need to print sheet 2 always two copies, how can I automate for always
@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
@ExcelMadeEasy4442 жыл бұрын
Nice Explained.
@Exceltrainingvideos
2 жыл бұрын
Glad it was helpful!
@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
2 жыл бұрын
Or Please Share Insta ID
@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 Жыл бұрын
Sir agr mujhe pdf file me different words search kr same page print dene in one time it is possible or not
@RajaGiri_tvpm2 жыл бұрын
Your voice is very attractive one 👌
@Exceltrainingvideos
2 жыл бұрын
Thanks 😅
@binuvlogs8538 Жыл бұрын
🙏
@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
Пікірлер: 26
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.
Good one. Very helpful in many practical situations.👍👍
@Exceltrainingvideos
2 жыл бұрын
Glad it was helpful!
Very very intersting classes sir, thank you so much.
@Exceltrainingvideos
2 жыл бұрын
You are most welcome
Very interesting especially the use of arrays in VBA
@Exceltrainingvideos
2 жыл бұрын
Indeed!
How can we add multiple variants
Dear Sir, Great video. Thank you. One Question - Can we have dynamic value in Array (PList) instead of static values. ?
@Exceltrainingvideos
2 жыл бұрын
Yes, you can
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
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
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?
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.
i have a workbook and need to print sheet 2 always two copies, how can I automate for always
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
Nice Explained.
@Exceltrainingvideos
2 жыл бұрын
Glad it was helpful!
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
2 жыл бұрын
Or Please Share Insta ID
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
Sir agr mujhe pdf file me different words search kr same page print dene in one time it is possible or not
Your voice is very attractive one 👌
@Exceltrainingvideos
2 жыл бұрын
Thanks 😅
🙏
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