automatic save invoice Backup specific Folder in excel

  Рет қаралды 56,088

Shahab Islam

Shahab Islam

Күн бұрын

Пікірлер: 102
@Noumanjavedshamsi
@Noumanjavedshamsi 14 күн бұрын
Yah jo aap karte hain bahut neki ka kam hai mere jaise logon ko sikhane ko milta hai aapka bahut bahut shukriya
@alfaenglishacademy4084
@alfaenglishacademy4084 3 жыл бұрын
Jo point Apne batay wo mujhe kisi or vedio me nhi mil paya...thank you sir
@chinarchinar2856
@chinarchinar2856 3 жыл бұрын
Masha ALLAH very help full and Nice
@waseemlimbaliya6196
@waseemlimbaliya6196 4 жыл бұрын
Feedback: Super Mega Thank You for describing every step in detailed manner. This tutorial is very useful and practical. Shahab Sb I would be very grateful to you if you add below mentioned features with this invoice application. 1- Add button for auto generate invoice number like “INV-0000” , “INV-0001” , “INV-0003. Or like this pattern “INV-072020-0001”, “INV-072020-0002” as explained below. a) First three letters is prefix = INV; b) Then add “-“; c) 07 is basically month number in which invoice is created i.e. July; d) 2020 is the year in which invoice is being created; e) Then add “-“; and f) Then add “0000” is serial number. This need to be auto generated invoice number at the click of button. 2- There need to be sheet two named as Master Data consisting of details of invoices generated during the year and show the following particulars in sheet 2 : a) Date b) Invoice number c) Customer name/ customer code d) Amount When the detail on invoice has been input there should be a button save to master data tab that is sheet 2. 3- There should be option to save as excel file (already incorporated in this video) plus save as pdf file to particular location. Hoping to continue making more advance and practical tutorial. Waiting for your Next video on this !!!!😁
@Noumanjavedshamsi
@Noumanjavedshamsi 3 жыл бұрын
Nice video sir u are best teacher
@shahabislam4912
@shahabislam4912 3 жыл бұрын
So nice of you
@bunty7858
@bunty7858 Жыл бұрын
Very useful video Thank You 😊 so much
@shahabislam4912
@shahabislam4912 Жыл бұрын
Most welcome 😊
@qualityquest6783
@qualityquest6783 2 жыл бұрын
Super explanation sir!
@shahabislam4912
@shahabislam4912 2 жыл бұрын
Keep watching
@moodkn
@moodkn Жыл бұрын
Great Exercise .... Lot Of Thanks...!
@shahabislam4912
@shahabislam4912 Жыл бұрын
Most welcome!
@zeeshikz1290
@zeeshikz1290 2 жыл бұрын
Sir bht zabrdast or bht kuch sekhny ko Mila sir aik request invoice ko pdf me kistraha save karaingy with vba coding
@muhammadtahirshaheen910
@muhammadtahirshaheen910 4 жыл бұрын
Masha Allah. Very Nice and important
@husainet7423
@husainet7423 3 жыл бұрын
Good sir
@iasinterview8704
@iasinterview8704 4 жыл бұрын
Nice vedio good job mashallah
@muhammadshakeel4482
@muhammadshakeel4482 3 жыл бұрын
Good knowledge
@zulqarnain41
@zulqarnain41 3 жыл бұрын
Asalam o Alaikum Shahab bhai, video bo7hat achi hai kindly ess main aur bhe functions agar daal dein tu bouhat acha ho jaey ga. جزاک اللہ خیر
@menisheditz_9666
@menisheditz_9666 Жыл бұрын
Thank you so much 😊
@munirqureshi5762
@munirqureshi5762 3 жыл бұрын
Great job sir
@forextrading2181
@forextrading2181 2 жыл бұрын
tremendous video
@salmansalimsunasraprincesu2260
@salmansalimsunasraprincesu2260 3 жыл бұрын
Nice sir , i am waiting for your video
@sukrarai8978
@sukrarai8978 4 жыл бұрын
Clear as crystal thank you sir
@moodkn
@moodkn 2 жыл бұрын
Excellent.... No doubt Very Helpful Thanks!
@shahabislam4912
@shahabislam4912 2 жыл бұрын
You are welcome!
@indianmonster1445
@indianmonster1445 Жыл бұрын
Dear sir Kindly make invoicing system series using many more vba tricks. Please make a invoicing with vba professional use. Topic:- * easy way to make multipages invoice print to pdf button * add customer details using userform. * product list combobox with add product jump to sheet 2 hyperlinks based and add product *Fully control and add data using button macro. * i was make sheet one and sheet 2 to pdf, i was failed page margin setting same to both page. Many more tricks for advance Invoice. Please do and make New series. 😢😢😢😢😢😢😢😢😢😢
@ISLAMIC10164
@ISLAMIC10164 4 жыл бұрын
اسلام وعلیکم سر یہ مجھے بہت اچھیلگی ہے سر اگر ہم نے پہلےوالے بل تبدیلی کر نی ہے تو کس طرح کر سکتے ہیں اس کےاوپر بھی مہربانی کردیں شکریہ سر
@breaker3533
@breaker3533 Жыл бұрын
hi sir thank u for wonderful information, i just followed ur steps and it works amazing. i have 3 sheets and when ever i click on button it saves all the sheets, can u pls help me to write code to save only sheet1 from range (a1:f41) as new excel file. thank u
@dhananjaypanchal
@dhananjaypanchal 4 жыл бұрын
Waw nice
@ramkrishnasingh1406
@ramkrishnasingh1406 3 жыл бұрын
Thank You
@shahabislam4912
@shahabislam4912 3 жыл бұрын
You're welcome
@shaguftasalam6475
@shaguftasalam6475 4 жыл бұрын
Awesome thanks.
@ankittiwari4994
@ankittiwari4994 4 жыл бұрын
Sir please ek aisi videos baneye jisme billing kare to stock inventory se less ho jaye
@shahabislam4912
@shahabislam4912 4 жыл бұрын
G thek he.
@shehrozahmad7139
@shehrozahmad7139 4 жыл бұрын
Very useful video Sir advance macros or simple VBA pr videos bnaen Sir I have confusion. Agr hum Fiverr my client ko VBA or macros file send krty hn setting KR ky apni side sy.or agt client ky computer pr wo setting nhi Hui ho pehly sy to Kiya hamari file use hogi usky pass without errors
@shahabislam4912
@shahabislam4912 4 жыл бұрын
File Format Macro Enable Hona chahe.
@faisalfiaz2949
@faisalfiaz2949 2 жыл бұрын
Sir Ya har file Alag save ho rahe ha mean new file generate ho rahe ha. jo hotel bills Hain ek he file ma next sheet ma kasy save ho ga
@sherrilsona5704
@sherrilsona5704 4 жыл бұрын
nice video but File save as karake ,hame 1 se jaada naam dene hai matlab ,invoice no - Item name- Date aise naam dene hai toh ham VBA Mai kar sakats hai kyaa???
@infomafas
@infomafas 3 жыл бұрын
I need to keep every transaction summary I mean( as per your invoice) A7: E10 should be copy automatically to create monthly report. Same table Day to day process.
@sunilshrestha5662
@sunilshrestha5662 4 жыл бұрын
aap ne banaye huye is bill ka har details ta data alag sheet me kaise backup ke liye transfer kar sakte hai vba code me?
@zeshankhan2455
@zeshankhan2455 3 жыл бұрын
bhai agar itam ka sarial nuber bi dana ho to kasa add ho ga? plz guide me
@whatsappstates7658
@whatsappstates7658 Жыл бұрын
Hi can you share command who to create name button and date button with commands
@rajeshtm508
@rajeshtm508 3 жыл бұрын
Sir can we save this macro to xlsx by selecting specified range? Any code for that. . No need formula or buttons to appear in saved file . If image is there that also to be in the saved file. Pls help
@umerm100
@umerm100 4 жыл бұрын
nice video very useful i cannot find xl sheet please send me xl sheet for practice thank
@shahabislam4912
@shahabislam4912 4 жыл бұрын
drive.google.com/file/d/1M8Ny4WHuE6iX4ioleC1UDqwkTg08XRmT/view?usp=sharing
@numanahmadsiddiki7785
@numanahmadsiddiki7785 2 жыл бұрын
@uday8053
@uday8053 3 жыл бұрын
YOUR VIDEO IS VERY NICE. I ALSO PREPARED. BUT I HAVE SOME DOUBTS ABOUT MY SAME OLD WORK. CAN WE CHANGE INVOICE NUMBER AUTOMATICALLY? LAST TIME I SAW ANOTHER VIDEO SAME TOPIC. THIS VIDEO IS VERY BETTER. BUT IF I PLACED THE SAVE ICON ON THE INVOICE IT IS SHOWING IN THE PRINT PREVIEW ALSO. IS THERE ANY CHANCE TO UNVISIBLE IN PRINT?
@khadimnadia6513
@khadimnadia6513 3 жыл бұрын
sir ye coding ka link mel sakta h taky ham bhi trai kr saky
@healthylife99311
@healthylife99311 3 жыл бұрын
a.o.a sir sari invoices ke summary kaisay banay ge
@shazeeullah4053
@shazeeullah4053 3 жыл бұрын
Sir g print out mian hmy ye button nhi chahe ye ye kesy khatam kardengy plz sir ye salutations b bataw
@mohammedfirozzaveri3181
@mohammedfirozzaveri3181 3 жыл бұрын
Hello Sir , Can you pls give some idea and code on how to save only specific range as new new file when running macro, at the movement it's saves macro buttons and entire file to other file ... I just want to save cell range that is invoice. Thanks.
@ganeshshimpi3697
@ganeshshimpi3697 4 жыл бұрын
Thnx for making video, But created modules automatically deleted from this sheets. Pls solve this problem
@EvanSuper
@EvanSuper 4 жыл бұрын
Why not try professional invoice manager: RapidBooks. It's free and you won't have this problem
@bisonhunter2613
@bisonhunter2613 4 жыл бұрын
Sir aap ka programm boht acha he. Lekin agar ye pura kam vb me ho jisme aitem list box me ho autono ho jb hm new record inter karain to sheet blank hojai
@shahabislam4912
@shahabislam4912 4 жыл бұрын
sb hoga inshallah jald upload karoga inshallah
@sridharkrishnappanavanerth3388
@sridharkrishnappanavanerth3388 4 жыл бұрын
sir , how to take backup of invoice description,qty,rate etc to separate sheet like 'Sales History' so that we can track our inventory.
@shahabislam4912
@shahabislam4912 4 жыл бұрын
kzbin.info/www/bejne/l3jPqKtshdBnl9k
@sridharkrishnappanavanerth3388
@sridharkrishnappanavanerth3388 4 жыл бұрын
@@shahabislam4912 Sir i didn't ask for the above video, want is from invoice template i want to take backup of complete description, Gst no, Qty, Amount, tax value etc to separate sheet, to track my inventory . May be we can use VBA or Formulas
@abbasshah6464
@abbasshah6464 4 жыл бұрын
shahab sir can you help to for data export
@rahulgangurde5610
@rahulgangurde5610 9 ай бұрын
Sir file save to हो रही है लेकिन next file bhi zero हो जाती हैं मतलब पहिले save किया हुआ file fir से zero हो जाती है
@ashishrupareliya
@ashishrupareliya 2 жыл бұрын
next shhet me data sab invoice ka kese kr sakte he
@samratbhanpur3443
@samratbhanpur3443 3 жыл бұрын
hiw to open saved pdf file...bcoz these file unable to open in pdf form
@MuhammadIshaq-gb4fy
@MuhammadIshaq-gb4fy 4 жыл бұрын
Developer tab start keya odr ap ny vba invoice file copy keya wo konsa file mtlb jis me ham ne data pehli se banaya wahi copy past karna mera nhi ho raha han
@shahabislam4912
@shahabislam4912 4 жыл бұрын
video Puri Dkhen
@MuhammadIshaq-gb4fy
@MuhammadIshaq-gb4fy 4 жыл бұрын
@@shahabislam4912 video puri deka han is file ke copy option samaj nhi araha han mei apni leyi practice kar raha hon
@MuhammadIshaq-gb4fy
@MuhammadIshaq-gb4fy 4 жыл бұрын
Yi problem hal Karo wrna is channel ke hami zarorat nhi han
@muhammaddaud9552
@muhammaddaud9552 3 жыл бұрын
AOA sir . MENE wese e SAVE AS Kiya he magr phir file close kd dobara open hony k bad save invoice Wala macro Kam Ni KR Raha . Please guide me sir m
@muhammaddaud9552
@muhammaddaud9552 3 жыл бұрын
In Excel 2007 version
@ranausmanghaniranausmangha3278
@ranausmanghaniranausmangha3278 4 жыл бұрын
I’m waiting
@jainoddincomputer815
@jainoddincomputer815 4 жыл бұрын
Assalamu Alaikum Bhai Mujhe Excell Invoice chahiye without gst wali jo auto matically work kare jaise ke a button pr click krne pr invoice save ho aur print out nikle aur jo invoice hai o blank ho jaye aur invoice number auto change ho
@musebshaikh7617
@musebshaikh7617 3 жыл бұрын
Assalamualaikum Invoice No=01 Now suppose I am working for January. then I need my invoice Number to increase by 1 after that if the month changes to February then again my invoice Number should start from 1 and get increase by 1 for each new invoice. It should follow the same every time the month get's changed. what is the possible vba code for this. please reply
@mankamalart6507
@mankamalart6507 Жыл бұрын
Sir pdf main butten aa raha?
@juberahmed8916
@juberahmed8916 4 жыл бұрын
Assalamualaikum wa Rahmatullahe barakatahoo Sir is file ko PDF me save karna ho to kaise hoga
@shahabislam4912
@shahabislam4912 4 жыл бұрын
kzbin.info/www/bejne/mnqqeqV-jslnZq8
@shahabislam4912
@shahabislam4912 4 жыл бұрын
Walekum salam wa rahmutullahe wabarakatahoo
@juberahmed8916
@juberahmed8916 4 жыл бұрын
@@shahabislam4912 Shukriya Sir
@santoshponnu4142
@santoshponnu4142 4 жыл бұрын
how save same invoice in pdf format and excel format with invoice no in specific file
@debojitkonwar8034
@debojitkonwar8034 4 жыл бұрын
Invoice number ko control kese kiya jai..?
@Shivamgamingomg
@Shivamgamingomg 3 жыл бұрын
Sir please tall me crt+P auto save document please sir 😐
@RizwanAli-do5qc
@RizwanAli-do5qc 4 жыл бұрын
sir main is invoice ka pura data sheet 2 main lena chahta hon example jaise invoice no . customer name. total amount . aour sath next cell main is pdf ka hyperlink ke main yahan hi se is pdf ko open kar lon kia aap yeh video banaen ge and kia aap mujhe is ka hyperlink code send kar sakte han thank you sir
@EvanSuper
@EvanSuper 4 жыл бұрын
It is recommended that you use a professional Invoice Maker, such as RapidBooks. More convenient and free
@stvasadrizvi7183
@stvasadrizvi7183 3 жыл бұрын
Dear sir Salam Sir ap mujhe ye file send kr dain . B koz is ka link mujhe discretion mein ni mil rha mujhe
@rajkumarpaul8598
@rajkumarpaul8598 2 жыл бұрын
Save ar okhana browse option nai Jar jonno save korlao pora file open korla hocha na
@sushillathi6042
@sushillathi6042 4 жыл бұрын
How to use Vlookup in excel 2007 multiple sheet
@shahabislam4912
@shahabislam4912 4 жыл бұрын
kzbin.info/www/bejne/qZWkZoiFg81-bs0
@chotaanonymous8355
@chotaanonymous8355 3 жыл бұрын
Sir is ma or item add kaisy karen ya bata den bss
@shahabislam4912
@shahabislam4912 3 жыл бұрын
row add karen or range vba me barha den cell address
@bosbos587
@bosbos587 2 жыл бұрын
i need sheet please with code
@sunilchoudhary859
@sunilchoudhary859 4 жыл бұрын
Sir mughe selected area invoice jutna hain utna hi save ho
@ajenterprises8744
@ajenterprises8744 4 жыл бұрын
Sir main jab save kartahun to path does not exist dikha raha hai or save nahni hoo raha hai please help
@ahmedwaseem9210
@ahmedwaseem9210 3 жыл бұрын
sir mera title error a rha ha
@ajenterprises8744
@ajenterprises8744 4 жыл бұрын
sir invoice area ko kese save kare, wo save invoce ka shape aajata hai
@shahabislam4912
@shahabislam4912 4 жыл бұрын
set print area ya Cell renage define karden
@nageshwarsinghbaghel5881
@nageshwarsinghbaghel5881 3 жыл бұрын
ई बिस्मिल्लाये,रहमाने रहीम लिखने से क्या होता है भिया ???
@Ganpatiwomenfashionhub
@Ganpatiwomenfashionhub 2 жыл бұрын
how to save pdf format
@shahabislam4912
@shahabislam4912 2 жыл бұрын
Save as Type has PDF option
@Ganpatiwomenfashionhub
@Ganpatiwomenfashionhub 2 жыл бұрын
I don't understand please explain
@dwivedihariomrakeshkumar5456
@dwivedihariomrakeshkumar5456 3 жыл бұрын
Jab baad me save karna hi hai to visual basic me coding ku kiye😆😆
@muzammilkhilji1319
@muzammilkhilji1319 4 жыл бұрын
Asalamulaikum shabab bhai mujay apka contact no chaiye agar dy sktey hai mujay send kr dy
@talhamehmood8883
@talhamehmood8883 4 жыл бұрын
sir is me ek or butthon add krna hai New inovice wo ksy work kry ga
how to make Sale Invoice Sheet Download For Free
16:50
Shahab Islam
Рет қаралды 1 М.
How to whistle ?? 😱😱
00:31
Tibo InShape
Рет қаралды 23 МЛН
Transfer data from invoice to worksheet automatically with vba
13:16
Dinesh Kumar Takyar
Рет қаралды 73 М.
Excel Invoice Template that Adds New Lines Automatically
10:09
TeachExcel
Рет қаралды 51 М.
Excel - Create an Invoice Register - Episode 1808
10:28
MrExcel.com
Рет қаралды 111 М.
EASILY Make an Automated Data Entry Form in Excel
14:52
Kenji Explains
Рет қаралды 770 М.
Fully Automated GST Invoice in Excel with Auto Save PDF and Data Backup
46:51