automatic save invoice Backup specific Folder in excel

[@Noumanjavedshamsi]

Yah jo aap karte hain bahut neki ka kam hai mere jaise logon ko sikhane ko milta hai aapka bahut bahut shukriya

[@alfaenglishacademy4084]

Jo point Apne batay wo mujhe kisi or vedio me nhi mil paya...thank you sir

[@chinarchinar2856]

Masha ALLAH very help full and Nice

[@waseemlimbaliya6196]

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]

Nice video sir u are best teacher

[@shahabislam4912]

So nice of you

[@bunty7858]

Very useful video Thank You 😊 so much

[@shahabislam4912]

Most welcome 😊

[@qualityquest6783]

Super explanation sir!

[@shahabislam4912]

Keep watching

[@moodkn]

Great Exercise .... Lot Of Thanks...!

[@shahabislam4912]

Most welcome!

[@zeeshikz1290]

Sir bht zabrdast or bht kuch sekhny ko Mila sir aik request invoice ko pdf me kistraha save karaingy with vba coding

[@muhammadtahirshaheen910]

Masha Allah. Very Nice and important

[@husainet7423]

Good sir

[@iasinterview8704]

Nice vedio good job mashallah

[@muhammadshakeel4482]

Good knowledge

[@zulqarnain41]

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]

Thank you so much 😊

[@munirqureshi5762]

Great job sir

[@forextrading2181]

tremendous video

[@salmansalimsunasraprincesu2260]

Nice sir , i am waiting for your video

[@sukrarai8978]

Clear as crystal thank you sir

[@moodkn]

Excellent.... No doubt Very Helpful Thanks!

[@shahabislam4912]

You are welcome!

[@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]

اسلام وعلیکم سر یہ مجھے بہت اچھیلگی ہے سر اگر ہم نے پہلےوالے بل تبدیلی کر نی ہے تو کس طرح کر سکتے ہیں اس کےاوپر بھی مہربانی کردیں شکریہ سر

[@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]

Waw nice

[@ramkrishnasingh1406]

Thank You

[@shahabislam4912]

You're welcome

[@shaguftasalam6475]

Awesome thanks.

[@ankittiwari4994]

Sir please ek aisi videos baneye jisme billing kare to stock inventory se less ho jaye

[@shahabislam4912]

G thek he.

[@shehrozahmad7139]

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]

File Format Macro Enable Hona chahe.

[@faisalfiaz2949]

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]

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]

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]

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]

bhai agar itam ka sarial nuber bi dana ho to kasa add ho ga? plz guide me

[@whatsappstates7658]

Hi can you share command who to create name button and date button with commands

[@rajeshtm508]

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]

nice video very useful i cannot find xl sheet please send me xl sheet for practice thank

[@shahabislam4912]

drive.google.com/file/d/1M8Ny4WHuE6iX4ioleC1UDqwkTg08XRmT/view?usp=sharing

[@numanahmadsiddiki7785]

❤

[@uday8053]

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]

sir ye coding ka link mel sakta h taky ham bhi trai kr saky

[@healthylife99311]

a.o.a sir sari invoices ke summary kaisay banay ge

[@shazeeullah4053]

Sir g print out mian hmy ye button nhi chahe ye ye kesy khatam kardengy plz sir ye salutations b bataw

[@mohammedfirozzaveri3181]

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]

Thnx for making video, But created modules automatically deleted from this sheets. Pls solve this problem

[@EvanSuper]

Why not try professional invoice manager: RapidBooks. It's free and you won't have this problem

[@bisonhunter2613]

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]

sb hoga inshallah jald upload karoga inshallah

[@sridharkrishnappanavanerth3388]

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]

kzbin.info/www/bejne/l3jPqKtshdBnl9k

[@sridharkrishnappanavanerth3388]

@@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]

shahab sir can you help to for data export

[@rahulgangurde5610]

Sir file save to हो रही है लेकिन next file bhi zero हो जाती हैं मतलब पहिले save किया हुआ file fir से zero हो जाती है

[@ashishrupareliya]

next shhet me data sab invoice ka kese kr sakte he

[@samratbhanpur3443]

hiw to open saved pdf file...bcoz these file unable to open in pdf form

[@MuhammadIshaq-gb4fy]

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]

video Puri Dkhen

[@MuhammadIshaq-gb4fy]

@@shahabislam4912 video puri deka han is file ke copy option samaj nhi araha han mei apni leyi practice kar raha hon

[@MuhammadIshaq-gb4fy]

Yi problem hal Karo wrna is channel ke hami zarorat nhi han

[@muhammaddaud9552]

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]

In Excel 2007 version

[@ranausmanghaniranausmangha3278]

I’m waiting

[@jainoddincomputer815]

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]

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]

Sir pdf main butten aa raha?

[@juberahmed8916]

Assalamualaikum wa Rahmatullahe barakatahoo Sir is file ko PDF me save karna ho to kaise hoga

[@shahabislam4912]

kzbin.info/www/bejne/mnqqeqV-jslnZq8

[@shahabislam4912]

Walekum salam wa rahmutullahe wabarakatahoo

[@juberahmed8916]

@@shahabislam4912 Shukriya Sir

[@santoshponnu4142]

how save same invoice in pdf format and excel format with invoice no in specific file

[@debojitkonwar8034]

Invoice number ko control kese kiya jai..?

[@Shivamgamingomg]

Sir please tall me crt+P auto save document please sir 😐

[@RizwanAli-do5qc]

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]

It is recommended that you use a professional Invoice Maker, such as RapidBooks. More convenient and free

[@stvasadrizvi7183]

Dear sir Salam Sir ap mujhe ye file send kr dain . B koz is ka link mujhe discretion mein ni mil rha mujhe

[@rajkumarpaul8598]

Save ar okhana browse option nai Jar jonno save korlao pora file open korla hocha na

[@sushillathi6042]

How to use Vlookup in excel 2007 multiple sheet

[@shahabislam4912]

kzbin.info/www/bejne/qZWkZoiFg81-bs0

[@chotaanonymous8355]

Sir is ma or item add kaisy karen ya bata den bss

[@shahabislam4912]

row add karen or range vba me barha den cell address

[@bosbos587]

i need sheet please with code

[@sunilchoudhary859]

Sir mughe selected area invoice jutna hain utna hi save ho

[@ajenterprises8744]

Sir main jab save kartahun to path does not exist dikha raha hai or save nahni hoo raha hai please help

[@ahmedwaseem9210]

sir mera title error a rha ha

[@ajenterprises8744]

sir invoice area ko kese save kare, wo save invoce ka shape aajata hai

[@shahabislam4912]

set print area ya Cell renage define karden

[@nageshwarsinghbaghel5881]

ई बिस्मिल्लाये,रहमाने रहीम लिखने से क्या होता है भिया ???

[@Ganpatiwomenfashionhub]

how to save pdf format

[@shahabislam4912]

Save as Type has PDF option

[@Ganpatiwomenfashionhub]

I don't understand please explain

[@dwivedihariomrakeshkumar5456]

Jab baad me save karna hi hai to visual basic me coding ku kiye😆😆

[@muzammilkhilji1319]

Asalamulaikum shabab bhai mujay apka contact no chaiye agar dy sktey hai mujay send kr dy

[@talhamehmood8883]

sir is me ek or butthon add krna hai New inovice wo ksy work kry ga